OSHA 300 and 301 case data CSV
Establishments with 100+ employees in Appendix B industries must submit case data. Build OSHA's 24-column case CSV from your log, names left out.
Who needs the case data file
An establishment that had 100 or more employees at any time in the year and is in an industry listed in Appendix B to subpart E must also submit information from its 300 log and 301 reports once a year (1904.41(a)(2)). OSHA publishes a CSV specification with 24 columns: case number, job title, dates, location, description, outcome, day counts, type, date of birth and hire, sex, treatment, times and the four 301 narratives.
Safetally builds that file from your log — case and 301 details in one spreadsheet — and tells you which required fields are empty before you upload. OSHA doesn't collect the employee's name, address, the health care professional or the treatment facility's name and address (1904.41(b)(9)), and Safetally's file leaves them out.
Files it reads
A CSV or Excel export from your incident tracker, HR system or the spreadsheet you keep the log in: one row per case with the employee, job title, date, where it happened, a description, the outcome and the day counts. Column names like “Case #”, “Date of injury”, “Days away” or “Classification” are recognised. Add a second file (or sheet) with your establishments' address, EIN, NAICS, employees and hours — or type them in once. An ITA 300A CSV you already made can be opened and checked too.
Injury records stay on your computer
An injury log holds names, injuries and medical detail. Safetally reads your spreadsheet with JavaScript in your browser tab; nothing is uploaded and no account is needed. Close the tab and the cases are gone. Privacy concern cases (29 CFR 1904.29(b)(6)–(9)) print as “Privacy case”, and the ITA case file has no name or address columns.
How it works
- Open your injury log (CSV or Excel) — or try the sample, or start a zero-injury year.
- Fill in each establishment once: address, EIN, NAICS, peak and average employees, hours worked, and who certifies.
- Fix what it flags, then print the 300A to post by February 1, the 300 log and the 301s — or with Pro download the ITA CSVs for March 2.
FAQ
What are the OSHA 300, 300A and 301?
The three injury and illness recordkeeping forms in 29 CFR Part 1904. The 300 is the log of recordable cases, the 301 is the incident report for each case, and the 300A is the yearly summary a company executive certifies and posts from February 1 to April 30. Some establishments must also submit the 300A — and some, 300 and 301 case data — to OSHA's Injury Tracking Application by March 2.
Is my data uploaded?
No. Your log is read by JavaScript in your browser tab and never sent to us or anyone else. Injury cases aren't stored; close the tab and they're gone. With Pro you can save establishment details (not cases) in this browser for next year.
Which files can I use?
CSV, tab-separated or Excel: one row per case with the employee, job title, date, location, description, outcome and day counts. Establishment details can be in a second sheet or file. A 300A CSV made for ITA can be opened and checked too. Download the templates to see the layout; your own column names usually work.
What's free?
Every check for any number of cases and establishments, the TRIR and DART rates, the printed 300A summary, and the 300 log and 301 reports with up to 3 cases and a small footer. Pro prints every case without the footer and adds the ITA 300A CSV, the ITA case data CSV, an Excel workbook and saved establishments.
Will OSHA accept these forms?
29 CFR 1904.29 allows OSHA's forms or equivalent forms with the same information, as readable and completed using the same instructions. Safetally's 300A uses OSHA's wording, and the ITA files follow OSHA's published CSV formats. You review, certify and submit them yourself; Safetally is not affiliated with OSHA.
Does it decide whether a case is recordable?
No. You decide recordability under 29 CFR 1904.4–1904.7. Safetally checks that what you recorded is complete and consistent, totals it and lays it out on the forms.