What it's for
A job hazard analysis breaks a job into its steps, and for each one names the hazards a worker could meet and the control that removes or reduces each hazard. This job hazard analysis template is a blank Excel file built around that method, and it works as a JSA (job safety analysis) form too.
Fill it in before work starts, then go over it with the crew and collect their signatures and the supervisor's.
What's inside
Two sheets: JHA and About this template.
JHA is the letterhead form, protected with no password so the labels and the NO. formula can't be typed over; pale yellow cells are yours to fill in. Top to bottom:
- Your letterhead, titled JOB HAZARD ANALYSIS, with JHA NO. and DATE.
- JOB: JOB OR TASK, LOCATION, PREPARED BY and REVIEWED BY.
- REQUIRED PERSONAL PROTECTIVE EQUIPMENT: eight items in two columns, each a Yes or No dropdown.
- JOB STEPS, HAZARDS AND CONTROLS: a 12-row table under NO., JOB STEP, POTENTIAL HAZARDS, HAZARD CONTROLS, RISK BEFORE CONTROLS (a Low, Medium or High dropdown) and RESPONSIBLE. Nothing calculates but NO., which fills in once a row holds a step and stays blank otherwise.
- REVIEWED WITH THE CREW: ten rows under NAME, COMPANY OR TRADE, SIGNATURE and DATE, then a SUPERVISOR SIGNATURE line with its own date.
It prints on two pages, one wide by two tall, with the steps table's header row repeated at the top of page 2.
About this template holds three how-to steps, a note that the "Example:" row is there to replace, the version, the license, links, and this method note: "The step, hazard and control columns follow the method in OSHA's Job Hazard Analysis booklet (OSHA 3071). This file is a form to fill in; a completed copy is not a compliance determination." That's OSHA's Job Hazard Analysis Guide (OSHA 3071 - 2002). The layout and labels are our own, not OSHA's form.
How to fill it in
- Type your company details over the yellow letterhead. To remove the YOUR LOGO text, choose Review > Unprotect Sheet (there's no password), then protect the sheet again. Save the result as your JHA template, and start each job from a fresh copy.
- Fill in JHA NO. and DATE. Under JOB, fill in JOB OR TASK and LOCATION, then PREPARED BY and REVIEWED BY side by side.
- Under REQUIRED PERSONAL PROTECTIVE EQUIPMENT, choose Yes or No for each of the eight items from the dropdown.
- Replace the row marked "Example:" with the first step of your own job, then list the rest below it in order.
- For each step, name the POTENTIAL HAZARDS and HAZARD CONTROLS, pick Low, Medium or High under RISK BEFORE CONTROLS (the crew's own judgment; the file doesn't score it), and name who's RESPONSIBLE.
- Review it with the crew before work starts. Under REVIEWED WITH THE CREW, each person there prints NAME and COMPANY OR TRADE, signs under SIGNATURE and fills in the DATE. If you keep a toolbox talk sign-in sheet for the meeting, file the two together.
- Have the supervisor sign on the SUPERVISOR SIGNATURE line and fill in the DATE beside it. If you keep a daily report for the day, note the JHA there too.
The worked example
The file opens on one filled-in row, labeled "Example:". It shows how a filled-in row reads, not a finished analysis: replace it with the first step of your own job.
| Job step | Potential hazards | Hazard controls | Risk before controls | Responsible |
|---|---|---|---|---|
| Example: set an extension ladder to reach the roof edge | Ladder slip; fall from height | Level footing; 4 to 1 angle; extend 3 ft above the landing; a second worker foots the ladder; tie off at the top | High | Crew lead |
Its NO. reads 1 because the row holds a step. High is the example's own rating, not a figure the file works out.
Frequently asked questions
Does it calculate anything?
Only the step numbers: each NO. cell fills in once its row holds a step. Nothing else on the form calculates.
Does it work in Google Sheets or Numbers?
Both open .xlsx files. This one has no macros, and its formulas use only IF and ROW, to number the steps.
Can I add rows to the steps table?
Yes. Unprotect the sheet (there's no password), insert a row between two of the 12, copy the NO. formula into it so the new row numbers correctly, then protect the sheet again.
Can I put my logo on it?
Yes. Insert it where the sheet says YOUR LOGO. That row is 36 pt (half an inch) tall, so a logo sized to it fits without dragging the row taller. To remove the YOUR LOGO text, choose Review > Unprotect Sheet (there is no password), then protect the sheet again.
Is this the same as a JSA?
Yes. Job safety analysis (JSA) is another common name for the same method and its three columns: job step, potential hazards and hazard controls. This file works as a JSA template too.
Does filling this in make us OSHA compliant?
No. The columns follow the method in OSHA's booklet, but the layout and labels are our own, not OSHA's form. A completed copy is not a compliance determination, doesn't decide what OSHA, a state plan, an insurer or a customer requires, and isn't legal advice.