Free CAPA log template for Excel
A corrective & preventive action tracker that runs itself: type a title and the CAPA ID, days-open counter, and OVERDUE flag fill in automatically, while a live dashboard tracks on-time close rate. 100% macro-free — no "Enable Content" prompt.
What’s in the download
- 200-row CAPA log with auto-numbered IDs (CAPA-0001, CAPA-0002 …) — just type a title to start a row
- Root cause, corrective action, preventive action, and verification / effectiveness columns — the fields an auditor asks about
- Dropdowns for source (NCR, audit, complaint, supplier…), department, owner, priority, risk, and status — all editable on the CONFIG sheet
- Automatic Days Open counter and OVERDUE flag, color-coded status and priority
- Live dashboard: Total / Open / Closed / Overdue cards, on-time close rate, average days-to-close
- Status, priority, source, owner, and monthly Opened-vs-Closed charts
- 100% macro-free — works in Excel 2010+ on Windows and Mac, no security prompts
The zip contains the workbook (.xlsx) and a README quick-start. Sample data is included so you can see it working — delete it and the formulas refill on their own.
Where this spreadsheet breaks
A CAPA log keeps score. It doesn’t make corrective action actually happen — and that gap is where audit findings come from:
1.CAPAs close without evidence
The spreadsheet accepts "Closed" whether or not anyone verified the fix worked. Six months later the same problem is back and the log says everything was handled.
NominalQC refuses to close a CAPA without a root cause, corrective action, and a completed effectiveness check on record — then stamps the verifier’s name and timestamp automatically.
2.Root cause is a text box
A blank cell labeled "Root Cause" produces "operator error" every time. There’s no method on record, and no path from a weak answer to a better one.
NominalQC has guided 8D and 5-Why worksheets whose conclusions promote into the CAPA’s official root cause and corrective action in one click — with the methodology on record.
3.The customer wants an 8D, not a spreadsheet row
When a customer demands a formal response, you’re rebuilding the story in Word at 9 PM — signatures, D1–D8, the lot.
NominalQC prints a customer-submittable 8D Response Report under your own logo — D1–D8 sections, embedded 5-Why and fishbone tables, signature lines, and the originating NCR cited.
Who built this
I spent 16 years in manufacturing quality — machining, fabrication, assembly — and in every shop I ended up building the same Excel tools with macros because the software budget went elsewhere. These workbooks are the ones I kept rebuilding. Eventually I stopped rebuilding spreadsheets and built NominalQC instead — but the spreadsheet is still the right starting point for a lot of shops, so here they are, cleaned up and free.
Questions
Is it really free?
Yes. You get the full workbook and the setup guide in exchange for an email address. Two short follow-up emails about running the process, then silence — unsubscribe anytime.
Does it work on Mac or older Excel?
Yes — this workbook is 100% macro-free, so there’s no "Enable Content" prompt and it works in Excel 2010 or later on Windows and Mac.
How is a CAPA different from an NCR?
An NCR records a specific nonconformance — this part, this lot, this defect — and its disposition. A CAPA addresses the underlying cause so it stops happening: root cause analysis, corrective action, and a check that the fix worked. Not every NCR needs a CAPA; repeat offenders and serious escapes do. This workbook tracks the CAPA side; the free NCR Log template covers the other.
Can I change the lists and dropdowns?
Yes — every dropdown pulls from the CONFIG sheet (your people, work centers, categories), and it’s all editable with no code involved. That’s the point: it should match your process, not ours.
More free templates
Ready to skip the spreadsheet stage?
Inspections, NCRs, CAPAs, LPAs, and gauge calibration — from $29/month flat, unlimited users.
Start your free trial