Header row
Formatted, frozen, with set column widths so the sheet scrolls cleanly on long registers.
HAZOP worksheet Excel template.
A HAZOP, hazard and operability worksheet is the process safety study document. One row per node-parameter-deviation tuple carries the cause, consequence, severity, likelihood, the existing safeguards, the recommendation if additional protection is required, the recommendation owner, and the closure status. The guide-word method follows IEC 61882, the HAZOP application standard. The seven standard deviation modes are NO, MORE, LESS, REVERSE, AS WELL AS, PART OF, OTHER THAN, each applied to every parameter at every node.
What the template carries.
HAZOP study worksheet template with 13 columns covering node, parameter, deviation guide word, cause, consequence, severity, likelihood, existing safeguard, recommendation, recommendation id, assignee, status, and closure reference. Pre-formatted with frozen header, auto-filter, and 48 blank rows.
By Tagsight Team·Published Jan 3, 2026·Reviewed Jun 4, 2026
- Format.xlsx
- Columns13
- Rows48 blank
- Opens inExcel · Sheets · LibreOffice
Every column, defined.
13 columns mapped to how a hazop study worksheet is issued on a real project. Dropdown columns enforce values; free-text columns let house notation preserve as drawn.
| # | Column | Type | Description |
|---|---|---|---|
| 01 | Node ID | Text | HAZOP node identifier |
| 02 | Node Description | Text | Process boundary covered by the node |
| 03 | Parameter | List | Flow, Level, Pressure, Temperature, Composition, Other |
| 04 | Guide Word | List | No, More, Less, Reverse, As Well As, Part Of, Other Than |
| 05 | Cause | Text | Specific cause of the deviation |
| 06 | Consequence | Text | Hazard consequence if deviation occurs |
| 07 | Severity | List | Risk matrix severity, 1-5. |
| 08 | Likelihood | List | Risk matrix likelihood, 1-5. |
| 09 | Existing Safeguard | Text | Current protective layer |
| 10 | Recommendation | Text | Recommended action |
| 11 | Recommendation ID | Text | Unique recommendation identifier |
| 12 | Assignee | Text | Action owner |
| 13 | Status | List | Open, In Progress, Closed, Rejected |
What ships in the file.
Worked example
One filled row shows the format for every column so the schema is clear before the engineer starts typing.
Auto-filter
Enabled on every column. Pivot by any field without a single formula.
48 blank rows
Pre-formatted and ready to paste into. Extends without breaking the dropdown or filter range.
Enforced dropdowns
Categorical columns (priority, signal class, status, type) enforce values so the register stays clean.
Cross-tool
Plain .xlsx. Opens cleanly in Excel, Google Sheets, and LibreOffice. No macros, no add-ins.
No tracking
No macros, no add-ins, no telemetry inside the file. Edit and ship.
Quiet signoff
A single mint-italic line at the bottom: Drag a source document at tagsight.io to fill this automatically. Easy to delete.
Extract from a source document instead.
Upload the source document instead and the same 13-column schema this template defines comes back populated. Type, tag, vendor, model, and per-row metadata come from the document itself.
Scanned binders, CAD-exported PDFs, and image scans all work. House conventions, vendor-specific forms, and dialect-specific tag schemes read as drawn.
Common questions
What is a HAZOP study worksheet.
The HAZOP, hazard and operability worksheet is the process-safety register of every deviation considered during a HAZOP study. One row per, node, parameter, guide word, cause combination with consequence, existing safeguard, recommendation, and assignee. It is the document the LOPA team reads to scope independent protection layers and the action tracker reads to drive closure.
What columns are in this template.
Thirteen columns. Parameter, Guide Word, Severity, Likelihood, and Status are dropdowns. The seven guide words, No, More, Less, Reverse, As Well As, Part Of, Other Than are enforced. Deviation rows that fall outside the standard set are typically a sign the parameter list needs revisiting.
Does this drive the LOPA worksheet too.
No. LOPA, layer of protection analysis is a separate worksheet that takes the high-consequence HAZOP rows as input. The two documents are linked at the recommendation level. A HAZOP recommendation that calls for additional protection becomes a LOPA scenario with an independent protection layer count.
Related.
Run it on your drawings.
The template is a manual starting point you fill yourself. Upload the source document instead and the same schema comes back populated.