HACCP Excel - Free Template

1. Open the workbook and review the Instructions sheet before entering production data. Confirm that the terminology and monitoring approach fit your product, process, and facility.
2. On the CCP Hazard Analysis sheet, replace the sample facility name and enter your plan date in the highlighted date cell. Use MM/DD/YYYY format, such as 07/19/2026.
3. List the process in sequence under Step No. and Process Step. Describe the biological, chemical, or physical hazard under Hazard Type and Hazard Description.
4. Mark the CCP? field for steps that require control at a critical control point. Enter the applicable minimum and maximum temperature limits in the Fahrenheit columns.
5. Describe who checks the limit, what instrument or record they use, and how often the check occurs in Monitoring Procedure and Frequency.
6. Record actual production observations and any exceptions on the Monitoring Log. Do not overwrite the critical limits when documenting a result that falls outside them.
7. Review the Dashboard after entries are made, then use the Instructions sheet and your establishment's approved procedures to complete corrective-action and verification work that the workbook does not replace.

A HACCP spreadsheet is useful when a food business needs to connect its written hazard analysis to what employees actually check during a shift. A small bakery, refrigerated meal producer, seafood processor, commissary kitchen, or contract manufacturer can use the workbook as a working document while developing and maintaining its food-safety plan.

The person entering the information may be a quality manager, plant supervisor, kitchen manager, owner, or trained line employee. A four-employee catering kitchen may review receiving, cold storage, cooking, cooling, and holding every production day. A larger facility may assign the Monitoring Log to a lead while the QA manager reviews exceptions and signs off on verification separately.

Start with the actual process flow

Use the CCP Hazard Analysis sheet in the same order that product moves through the facility. For example, a ready-to-eat chicken operation might list receiving, refrigerated storage, cooking, cooling, packaging, and finished-product storage. The critical question is not whether a step sounds important; it is whether a hazard is controlled there and whether loss of control could produce unsafe food.

Image 1 shows the wide analysis table with Step No., Process Step, Hazard Type, Hazard Description, CCP?, minimum and maximum Fahrenheit limits, Monitoring Procedure, and Frequency. That layout is practical for a manager reviewing the entire process on one screen or printed page.

Match the record to the person doing the check

Suppose a line employee checks a cooler three times during a 10-hour shift. The procedure should say what thermometer is used, where the reading is taken, and where the result is recorded. The manager should not leave a vague instruction such as check cooler; a specific entry such as record the product-zone temperature at 7:00 a.m., 11:00 a.m., and 3:00 p.m. gives the employee a usable standard.

Images 2, 3, and 4 show the separate Monitoring Log, Dashboard, and Instructions sheets. Keep the analysis stable and use the log for day-to-day evidence; changing a critical limit in the middle of a run should require documented review, not an informal edit.

That kind of controlled review fits naturally into ongoing improvement tracking, where each change is documented before the next run begins.

The FDA's HACCP framework is built around seven principles: conduct a hazard analysis; identify critical control points; establish critical limits; establish monitoring procedures; establish corrective actions; establish verification procedures; and establish recordkeeping procedures. This Excel workbook supports the analysis, limit, monitoring, and recordkeeping portions, but it does not by itself prove that your plan satisfies every regulatory or customer requirement.

For seafood, juice, and certain other sectors, specific FDA regulations may apply. For example, seafood processors operate under 21 CFR Part 123, while juice processors are covered by 21 CFR Part 120. Many food facilities also operate under the FSMA preventive-controls rule in 21 CFR Part 117. A HACCP plan and a FSMA food-safety plan are related but are not interchangeable documents.

Critical limits must be measurable

A critical limit needs an objective boundary, such as a time, temperature, pH, water activity, or concentration. The template's Critical Limit Min (F) and Critical Limit Max (F) columns are designed for Fahrenheit temperature ranges. Do not enter a convenient target unless you can support it with the applicable regulation, process authority, validated study, product specification, or other defensible basis.

For a hypothetical cooking step with a validated minimum of 165°F, a reading of 164°F is not a passing result merely because it is close. The record should show the actual 164°F observation, the deviation, the product disposition, and the corrective action required by the approved plan. The workbook's cells do not make that judgment automatically.

Records need traceability

Each monitoring entry should be tied to a date, time or production lot, responsible employee, measured result, and review. Calibration records for thermometers, verification checks, corrective-action documentation, and the approved plan should be retained with the monitoring records according to your regulatory and customer requirements.

Do not treat the displayed plan date of 07/19/2026 as an approval date. Update it when the plan is formally reviewed, document the reviewer and verification outside the fields shown in the workbook, and follow the record-retention rule that applies to your facility and product category.

That same retention discipline applies to equipment upkeep, so the maintenance log keeps inspections, corrective actions, and review dates aligned with the records you already maintain.

The most expensive HACCP failures are usually not caused by an unattractive spreadsheet. They happen when the written limit, the employee's observation, and the response to a deviation do not agree. A facility can have a polished analysis sheet and still receive a serious finding if its monitoring records show repeated out-of-limit readings with no documented disposition.

Limits get copied without a process basis

A common mistake is copying a cooking temperature or cooling target from another product. Imagine a facility producing 200 trays of prepared food and entering 165°F as a generic limit for every step. If the actual validated process requires a different time-temperature combination, the copied value can create either unsafe processing or unnecessary product holds. Critical limits should be tied to the specific product and process, not to a familiar number.

Another problem is entering a range that is too broad to control the hazard. If a cooler is intended to stay at or below 41°F but the sheet shows a maximum of 50°F, an employee may record a passing result that does not protect the product. The spreadsheet preserves what you enter; it cannot correct a scientifically unsupported limit.

Employees record the result but not the exception

Suppose a thermometer reads 46°F when the maximum is 41°F. Writing 46°F in the Monitoring Log is only the observation. The record also needs the immediate action, such as moving product to a verified cooler, evaluating exposure time, checking the instrument, notifying the supervisor, and documenting the final disposition under the approved procedure.

Blank cells create a different audit problem. If a shift has 12 required checks and only 9 appear, a reviewer cannot tell whether three checks were missed, the product was not made, or the employee forgot to record them. A missing entry can cost hours of reconstruction and may require a product hold while the facility determines what happened.

The plan is not verified after changes

New equipment, a different ingredient supplier, altered batch size, or a longer production run can change the hazard analysis. A four-employee kitchen that adds a blast chiller should not continue using an old cooling procedure without reviewing the process flow, limits, monitoring frequency, and verification evidence. Treat the workbook as a controlled document, not as permission to skip validation, employee training, calibration, or management review.

The best way to keep a HACCP Excel file alive is to attach it to an activity that already happens. Have the lead employee open the Monitoring Log at the start of the production shift, enter each observation as it occurs, and give the supervisor a fixed review point before the lot leaves the facility.

Use a short review cycle

Set a 10-minute review after each shift for a small operation. The reviewer should compare the required checks with the entries, inspect out-of-limit values, and confirm that deviations were handled under the approved corrective-action procedure. At the end of the week, review recurring results; five cooler readings of 40°F followed by one at 47°F may indicate a failing door seal or overloaded unit rather than a one-time clerical mistake.

Keep entries consistent

Use the same temperature unit, time convention, lot identifier, and employee naming method every day. A practical routine includes these checks:

• Keep the approved critical limits on the analysis sheet and enter actual measurements in the Monitoring Log.
• Use one calibrated thermometer for the designated check and retain its calibration evidence with the food-safety records.
• Review the Dashboard after the log is updated, then investigate any result that does not match the expected range.
• Save a dated copy after formal review, such as HACCP_Plan_2026-07-19.xlsx, while keeping the working file protected from casual overwrites.

Know when Excel is no longer enough

Excel is a reasonable fit for one facility with a manageable number of checks. If three shifts create 100 observations per day, that becomes about 36,500 rows in a year; at that volume, user permissions, electronic signatures, audit trails, and automated escalation are stronger reasons to move to a food-safety management system than adding more worksheet tabs.

Until then, make one person responsible for the weekly review and one person responsible for controlled plan changes. The Instructions sheet should explain your local process, while the approved HACCP plan and regulatory requirements remain the authority for what must be monitored.