Free Near Miss Report Form and Log for Excel
A one-page near miss report anyone can fill in, with the name optional, and a log behind it that follows every fix until it's done. Includes a summary by category and 20 worked examples. Works in Microsoft Excel and Google Sheets.

What is a near miss report?
A near miss is an event at work where nobody was hurt and nothing was damaged, but it could easily have gone the other way: a box that fell where someone had just been standing, a forklift that turned into an aisle as a picker stepped out, a lead with a cracked plug found in use. A near miss report is the short written record of it, made the same day, so the cause gets fixed before the same thing happens with someone in the way.
Keep the form short or people stop using it. The Near Miss Report tab fits on one page and asks four questions in plain words:
- When and where: date, time, location, category, the equipment involved, and how bad it could have been.
- What happened, written in order.
- What could have happened: who could have been hurt, or what damaged.
- What you did straight away, and how it could be prevented next time.
The reporter's name is optional. People report more when they are not worried about blame, and an anonymous report you can act on is worth more than one nobody writes. The bottom half of the page is for the supervisor or safety lead: root cause, corrective actions with an owner and due date, and the date the reporter was told what was done.
Near misses that turn out to involve an injury or damage are incidents; record those on the incident report template, which has room for the people, equipment and witnesses involved.
Why the log matters more than the form
A stack of near miss forms in a tray tells you nothing. The Near Miss Log turns them into a list you can act on: one row per report, with the category, the potential severity, the fix, its owner and its due date. The Action Status column fills itself in: NO ACTION SET while nobody has written a fix, OPEN until it is done, OVERDUE once the due date has passed, and CLOSED when you enter the date it was completed.
The Summary tab counts reports by category, the high-potential ones, anonymous reports, and open and overdue fixes. If one category keeps coming back (vehicles at aisle ends, falling objects from the mezzanine), that is where the next injury is coming from.
The Examples tab lists 20 near misses by category with a typical fix: slips on oil, tools dropped from height, forklifts at blind corners, guards removed, wedged fire doors, ladders on a slope. Use it in a toolbox talk to show people what is worth reporting.
Who uses a near miss report form
Anywhere people work around vehicles, machines, heights or chemicals.
Warehouses and distribution
Forklifts at aisle ends, falling stock, blocked exits and dock edges.
Construction sites
Dropped tools, open edges, plant moving near crews and unsecured ladders.
Manufacturing plants
Guards removed, jams cleared without lockout, leaks and spills at machines.
Facilities and maintenance
Electrical faults, wet floors, roof access and contractors on site.
Fleets and field service
Close calls on the road, in the yard and on customer sites.
Safety committees
Trends by category and fixes that are still open at the monthly meeting.
Before you fill it in
The mezzanine gate was reported in September. It is still open.
Try UNIO24 to automate near-miss follow-up.
Try UNIO24 FreeA spreadsheet goes out of date within days, and keeping it current takes someone's time every day. UNIO24 automates that work: the near miss becomes a ticket with an owner, a due date and a timer, linked to the equipment involved.


| Capability | Free Template | UNIO24 FreeRecommended for safety teams |
|---|---|---|
| Reporting | ||
| Near miss reportThe template prints a one-page form. In UNIO24 anyone reports from a phone as a ticket. | Partial | Yes |
| Photos and the equipment involvedThe photo and the gate, machine or vehicle, attached to the report. | No | Yes |
| Follow-up | ||
| Fix with an owner and a due dateThe log tracks it by hand. UNIO24 assigns it and runs an SLA timer. | Partial | Yes |
| Overdue fixes flaggedBoth flag a fix past its due date. UNIO24 does it without anyone opening a file. | Partial | Yes |
| Data & reliability | ||
| Many reporters at onceA shared file gets overwritten. UNIO24 handles simultaneous users. | Partial | Yes |
| History per piece of equipmentEvery near miss, incident and repair kept on the equipment it involved | Partial | Yes |
| Full support | 0/ 6 | 6/ 6 |
Frequently Asked Questions
About near miss reporting and the template
Is the near miss report form free?
Yes. No cost, no subscription, no card. Enter your name and email and the Excel file downloads instantly.
What is an example of a near miss?
A carton slides off the top shelf and lands where a picker stood a second earlier. A forklift turns into an aisle as someone steps out. A grinder is found running with the guard pushed back. A fire door is wedged open with a box. The Examples tab in the template has 20 more, sorted by category, each with a typical fix.
Is a near miss the same as an incident?
A near miss is an incident where nobody was hurt and nothing was damaged. Once there is an injury or damage, record it as an incident with the people, equipment and witnesses involved, using the incident report template. Keep both in your records: near misses show where incidents are likely to happen next.
What should a near miss report include?
When and where it happened, what happened in order, what could have happened and to whom, what was done straight away, and an idea for preventing it. Add the category, the equipment involved and how severe it could have been, so reports can be compared. The follow-up adds the root cause, the fix, its owner and due date, and the date the reporter was told.
Should near miss reports be anonymous?
Let people choose. A name helps the follow-up and lets you thank the reporter, but making it compulsory means fewer reports, especially when the near miss involved a mistake. The form keeps the name optional; the Summary counts anonymous reports, and a rising share of them often says more about trust than about safety.
Do near misses have to be reported to a regulator?
Usually not. Regulators ask for injuries and certain dangerous occurrences, not every near miss. Many safety programs and client contracts do require them to be logged internally, though, and auditors often ask to see the log. Check the rules for your industry and location.


