Free Excel template
Free quality control inspection log Excel template
Record each inspection with its part, lot, measured value and result. A practical starting point for spreadsheet-based manufacturing checks, with no Lucy account required.
What a completed log can look like
Fictional example showing selected columns. Your download contains a blank log, with the full field list below.
| Inspection ID | Part ID | Lot ID | Measured Value | Unit | Result |
|---|---|---|---|---|---|
| QC-1047 | BRK-220 | L-418 | 80.02 | mm | Pass |
| QC-1048 | BRK-220 | L-418 | 24.96 | mm | Pass |
| QC-1049 | HSG-310 | L-419 | — | — | Fail |
QC-1048 identifies a mounting hole diameter check on part BRK-220 from lot L-418. Record 24.96 in Measured Value and mm in Unit. In this fictional example, the inspector has separately assessed the result as Pass. The number alone does not establish acceptance.
How to use this template
- 01
Read the Guide tab
Save a copy of the workbook. Guide opens first and explains the fields, entry aids and an example voice command.
- 02
Define the inspection records
Open Inspection Log. Give each check a unique Inspection ID and enter the part, lot and feature being inspected.
- 03
Record the result and disposition
Use your approved inspection method. Enter the reading and unit, then the assessed result, any defect code, disposition, date and inspector.
Fields included in the Excel workbook
- Inspection ID
- A unique identifier for each check, such as QC-1048. Give repeat inspections their own IDs.
- Part ID
- The part being inspected. A part may appear on several inspection rows.
- Lot ID
- The batch or lot associated with the inspected item.
- Feature
- The characteristic being checked, such as mounting hole diameter or surface finish.
- Measured Value
- The numeric reading. Leave it blank for a qualitative check and describe that check in Result and Notes.
- Unit
- The unit associated with the numeric reading, such as mm.
- Result
- Choose Pending, Pass, Fail or Needs review using your approved criteria. The workbook does not calculate pass/fail.
- Defect Code
- A code from your team’s established defect classification, when applicable.
- Disposition
- Choose Pending, Accept, Hold, Rework or Reject according to your team’s decision.
- Inspection Date
- The date of the check, displayed as YYYY-MM-DD.
- Inspector
- The inspector’s initials or established identifier.
- Notes
- The drawing or work-instruction reference, relevant context and follow-up actions.
Common mistakes to avoid
Using the lot number as a unique row key
One lot can contain many checks. Use a distinct Inspection ID for every row so the measurement can be traced to one inspection.
Inferring pass/fail from an unexplained number
The template does not contain tolerance limits or acceptance formulas. Apply your approved drawing and work instructions, then enter the result and disposition yourself.
Overwriting a reinspection
Give a repeat check a new Inspection ID and reference the earlier check in Notes. This workbook remains editable and does not provide an immutable audit history.
Within rows 2–101, red ID cells flag duplicates and amber ID cells flag a missing ID when other fields are filled. Review pasted values yourself. To add more rows, copy a prepared blank row and extend dropdown and conditional-format ranges, including the duplicate-ID formula.
Optional voice entry
Update this log with Lucy
Lucy is a voice-first interface for structured spreadsheet updates. In its Excel desktop task pane, select Inspection Log, confirm row 1 as the header row and Inspection ID as the key, then start Listening Mode. Create the record before speaking an update.
Illustrative command
“For inspection QC-1048, set measured value to 24.96 and result to pass.”
Expected changes to the named record
| Field | Before | After |
|---|---|---|
| Measured Value | Blank | 24.96 |
| Result | Pending | Pass |
This is a worked example, not a recording of a live session. Lucy reports each applied, skipped or failed action. Ambiguous targets are skipped. Keep rows and columns visible and avoid merged cells and filtered ranges when using Lucy.
Lucy is available through beta access. Its current tested host workflow uses local workbooks in Excel desktop on macOS; Windows, Excel on the web and native Google Sheets support are still being validated or developed.
Quality control inspection log FAQ
Practical answers before you start your log.
Is this inspection log template free?
Yes. Download the Excel workbook without an email address or Lucy account. It works as a manual entry log.
Does the spreadsheet automatically determine pass or fail?
No. The inspector enters Result using the approved criteria for the feature. Disposition is also a manual decision. No tolerance or acceptance formulas are included.
Can I record visual inspections?
Yes. Describe the inspected characteristic in Feature, leave Measured Value and Unit blank when they do not apply, and complete Result, Defect Code, Disposition and Notes as needed.
Can the same part or lot appear more than once?
Yes. Part and lot identifiers can repeat. Inspection ID must uniquely identify each check, including any reinspection.
Do I need Lucy to use this workbook?
No. You can type directly into the workbook and use its dropdowns without a Lucy account. Voice updates are an optional beta workflow.
Make the log your own
Start with the Guide tab, then add your records to the blank entry sheet.