Free OSHA 300 Log Template (Excel Preparation Worksheet)
A 50-case working log with case-outcome dropdowns, six injury/illness classifications, summary totals and TRIR/DART formulas. Transfer reviewed entries and totals to official OSHA forms.
Get the Excel preparation worksheet. Review entries and use the official forms for recordkeeping and posting.
Created by Jacob Szyszka, founder of BasinCheck · ASSP member · built with safety managers in the Permian Basin
OSHA 300 Log Excel Preparation Workbook
PDF Checklist
Industry membership and independent recognition
Energy producer network member
SoftwareWorldCustomer Choice recognitionWhat’s Included in This Checklist
Why OSHA 300 Log Excel Preparation Workbooks Matter in Oil & Gas
The workbook helps organize entries and calculate totals for review. It does not determine recordability, replace official Forms 300, 300A or 301, or certify compliance. Formulas cover the 50 provided case rows only. Transfer reviewed information to the official forms and follow their instructions.
Key Inspection Areas Covered
Calculated Summary Totals
Review totals for outcomes G–J, days K–L and all six injury/illness types M1–M6. Complete establishment and employment information before transferring the reviewed totals to official Form 300A.
Two Sets of Dropdowns
Choose exactly one most-serious outcome in G–J and one injury/illness type in M. Body-part and event details are typed in the description; there are no body-part or privacy-case dropdowns.
Entry Warnings
Red cells flag missing/multiple outcomes and combined day counts above 180 for review. These warnings do not check every required field or decide whether a case is recordable.
Annual Rate Calculations
Enter actual employee hours worked for the same year to calculate TRIR and DART. Missing or zero hours leave the rates blank. Review the underlying case classifications before using a rate.
Regulatory Requirements & Compliance
Employers with more than 10 employees at any time in the previous year generally keep OSHA records unless a partial industry exemption applies. Enter recordable cases on Forms 300 and 301 or equivalent forms within seven calendar days of learning they are recordable. For 2026 records, certify and post Form 300A from February 1 through April 30, 2027. Covered establishments separately submit data through the ITA by March 2, 2027. Use OSHA’s current establishment-size and NAICS coverage rules.
Why Safety Teams Trust This Template
Preparation Worksheet
Use official OSHA forms and instructions for recordkeeping, certification and posting.
Excel Formulas
Summary totals cover the 50 provided case rows. Review them before transferring data.
Employer Review
The employer remains responsible for recordability, completeness and privacy-case handling.
Common Questions About OSHA 300 Log Excel Preparation Workbooks
Can I post this workbook as Form 300A?
No. This is a preparation worksheet. Transfer reviewed information to official Form 300A, have a company executive certify it, and post that summary. Do not post the named 300 Log or this worksheet.
What dropdown menus are included?
The workbook has case-outcome selectors in G–J and one injury/illness-type selector in M. Select only the most serious outcome for each case. Complete the other information manually and follow OSHA’s privacy-case instructions.
Can I upload the workbook to the ITA?
No. It is not an ITA CSV file and does not submit records. If your establishment is covered, enter the reviewed data in the ITA or prepare a CSV using OSHA’s current specifications. Form 301 or an equivalent incident report must be completed separately.
About This Free Download
Is this OSHA 300 template free?
Yes. Request the Excel preparation workbook using your email. Official OSHA Forms 300, 300A and 301 are also free at OSHA.gov.
Why do I need to provide an email?
Your request provides a download link and a delivery email. You can unsubscribe from marketing messages.
What makes this different from the official OSHA forms?
This working spreadsheet adds dropdowns and calculated totals. It is not an official form, an equivalent-form certification or a guarantee of complete records. Transfer reviewed information to the official forms.
Ready to Go Paperless with OSHA 300 Log Excel Preparation Workbooks?
Automate your OSHA recordkeeping with digital incident tracking. BasinCheck classifies injuries, calculates DART rates, and generates 300A summaries automatically.
More Free Safety Checklists
Want All 6 Templates Including This OSHA 300 Log Excel Preparation Workbook?
Get Complete KitGet Your Free OSHA 300 Log Excel Preparation Workbook
Get the Excel preparation worksheet. Review entries and use the official forms for recordkeeping and posting.