Hazard Analysis and Critical Control Points Template in Excel

Easy to Use Fill-in-the-Blank Templates

QI Macros SPC Add-in for Excel contains several templates to perform Hazard Analysis. To open the templates click on QI Macros on your Excel tool-bar, then Improvement Tools, Hazard Analysis - Bow Tie:

improvement tools menu

A template with several tabs will open:

tabs in hazard analysis template

The HACCP and HACCP Plan templates are shown on this page. See these links for descriptions of the other templates:

HACCP Template

haccp template


HACCP plan

FISH Steps


Personnel practices
Manufacturing practices
Cleaning, sanitation, pest control
Receiving, transportation, and storage
Traceability and recall
Supplier control
Hazardous material handling


Assemble the team
Describe the product and distribution
Describe use and users
Develop and verify process flow


1. Conduct hazard analysis
2. Determine critical control points (CCPs)
3. Establish critical limits (CLs)
4. Establish monitoring procedures
5. Establish corrective action plan
6. Establish verification plan
7. Establish record keeping process

Learn More...

To create a Hazard Analysis using QI Macros...
Try It Now!