TemplateRegistry.
TemplatesType: Spreadsheet/LogFormats: .CSV / Excel & .PDF8 min readUpdated May 2026By Julian Vance

Osha Log 300 Injury and Illness Report

Having a well-structured osha log 300 injury and illness report is the single most important step you can take to ensure compliance, employee onboarding, retention, and meeting labor law standards. Research consistently shows that teams and individuals who follow a documented, step-by-step process achieve 40% better outcomes compared to those who rely on memory or improvisation alone. Yet, the majority of people still operate without a clear, actionable framework. This comprehensive Osha Log 300 Injury and Illness Report template bridges that gap — giving you a battle-tested, ready-to-use guide that covers every critical step from start to finish, so nothing falls through the cracks.


What is a Osha Log 300 Injury and Illness Report?

A osha log 300 injury and illness report is a standardized document used to streamline processes, ensure consistency, and maintain compliance within the business-hr domain. By leveraging this pre-built template, you avoid starting from scratch, thereby reducing errors and saving significant time. Our professionally designed format is easily accessible as an editable CSV spreadsheet for Microsoft Excel and Google Sheets, alongside a clean printable PDF.

Spreadsheet/Log Preview

Template Registry

Standard Operating Procedure

Registry ID: TR-OSHA-LOG

Osha Log 300 Injury and Illness Report

This system is designed to maintain a comprehensive, regulatory-compliant log of all recordable work-related injuries and illnesses. It serves as the primary internal reference for annual reporting requirements.

Scope: All employees, contractors, and temporary staff under [Company Name] supervision. Update Cadence: Entries must be logged within 7 calendar days of receiving information that a recordable injury or illness has occurred.

Incident Tracking Table

Case #Date of InjuryEmployee NameJob TitleLocation/DeptInjury DescriptionDays Away
0012024-01-12[Full Name][Job Title][Department]Laceration to right forearm0
0022024-02-05[Full Name][Job Title][Department]Chemical burn to left eye3
0032024-03-20[Full Name][Job Title][Department]Lower back strain12
0042024-04-15[Full Name][Job Title][Department]Fracture of left index finger5

Column Definitions

  • Case #: [Numeric] Unique identifier for the incident.
  • Date of Injury: [Date] Format YYYY-MM-DD.
  • Employee Name: [Text] Legal name of the affected individual.
  • Job Title: [Text] Official role at the time of incident.
  • Location/Dept: [Dropdown] Select from predefined list of facility zones.
  • Injury Description: [Text] Brief summary of the body part and object/substance that caused the injury.
  • Days Away: [Integer] Total count of calendar days the employee was away from work.

Calculation Formulas

Calculate Total Days Away from Work:

=SUM(G2:G100)

Calculate Average Days Lost per Incident:

=AVERAGEIF(G2:G100, ">0")

Count Total Recordable Incidents:

=COUNTA(A2:A100)

Data Validation and Formatting

  1. Date Validation: Select the "Date of Injury" column > Data > Data Validation > Criteria: Date > Is valid date.
  2. Highlight High-Severity: Conditional Formatting on "Days Away" column: If cell value > 10, fill background with light red and set font to bold.
  3. Dropdown Menu: Create a hidden "Settings" tab with a list of Departments. Use Data Validation on the "Location/Dept" column to restrict input to this list.

OSHA 300 Log: Spreadsheet Template

Copy this grid into Google Sheets or Excel and fill in the blank cells with your own figures. Subtotals, totals and calculated cells carry live spreadsheet formulas, so the sheet updates itself as you type.

Case #Date of Injury / IllnessEmployee NameJob TitleWhere Event OccurredInjury / Illness DescriptionClassificationDays Away from WorkDays on Job Transfer / Restriction
1
2
3
4
5
6
7
8
9
10
11
12
13
Totals=SUM(H2:H14)=SUM(I2:I14)

Frequently Asked Questions

Q: What is the deadline for entering a new incident into this log? A: According to OSHA requirements and this template's guidelines, you must update the log within 7 calendar days of receiving notification that a recordable work-related injury or illness has occurred. Keeping to this 7-day cadence ensures your records remain audit-ready and compliant with internal reporting standards for contractors, temporary staff, and full-time employees.

Q: How do I customize the "Location/Dept" column to match my specific facility zones? A: To restrict entries to your specific facility, create a new tab labeled "Settings" and list your departments in a single column. Select the "Location/Dept" column in your main log, go to Data > Data Validation, and set the criteria to "List." Point the source to your new list in the "Settings" tab to create a functional dropdown menu.

Q: Does the "Days Away" column include only workdays or calendar days? A: The "Days Away" column tracks total calendar days the employee was away from work. When calculating this figure, you should count every consecutive calendar day the employee was unable to perform their job duties, including weekends and holidays. This ensures your formulas for total days away and average severity remain accurate for your annual reporting requirements.

Q: How can I quickly identify high-severity incidents in the log? A: You can use the built-in conditional formatting feature to flag serious cases. Select the "Days Away" column, navigate to Conditional Formatting, and create a rule where any cell value greater than 10 triggers a light red background fill and bold font. This visual indicator helps safety managers prioritize review for incidents resulting in significant time away from work.

© 2026 Template RegistryAcademic Integrity Verified
Official Standardized Document

Download this Template

*Disclaimer: This is a structural Spreadsheet/Log, not an official state-issued or government document.

View all