CAPA Format & Template — Free Excel Download (with Filled Example)

2026-06-17

Download a free CAPA (Corrective and Preventive Action) format and Excel template — with a filled example and a field-by-field guide. Aligned to ICH Q10, US FDA 21 CFR 211/820, EU GMP and India's revised Schedule M.

If you're here, you want a CAPA format you can actually use — not another lecture. So here it is: a ready-to-use CAPA (Corrective and Preventive Action) template in Excel, the field-by-field guide to filling it, and a fully worked example. It's built to match what US FDA, EU GMP and India's revised Schedule M inspectors expect to see.

⬇ Download the CAPA template (Excel) — free, no sign-up. Copy it into your QMS and adapt the fields to your SOP.

What a CAPA format must contain

A defensible CAPA record has these fields. This is the template — every column earns its place because an inspector will ask about it.

A filled CAPA example

Abstract templates are easy to fill in badly. Here's the same template completed for a real-world case:

Notice the root cause is a system gap (missing from PM schedule), not "operator error" — and the preventive action extends the fix to the other lines before they fail. That's the difference between a CAPA that closes and one that comes back.

How to fill each field (the parts people get wrong)

• Root cause is where most CAPAs fail audit. "Operator error" is where the analysis stops, not the root cause. Use 5 Whys or Fishbone (Man, Machine, Material, Method, Measurement, Environment) and write down the reasoning. The test: if your corrective action wouldn't have prevented the event, you haven't found the root cause.
• Correction vs corrective action — the correction is the immediate containment (quarantine the batch); the corrective action removes the root cause so it can't recur. A complete CAPA has both.
• Effectiveness check — the single most-cited CAPA gap. After a defined period (e.g. next 3 batches / 90 days), prove with objective evidence the problem hasn't recurred. No evidence = the CAPA can't be closed.
• Status — keep it live. If you can't produce a list of open and overdue CAPAs on demand, that is the finding.

The CAPA process behind the template

  Trigger (deviation / OOS / complaint / audit / trend)
        -> Initiate + risk-assess  -> Correction (contain)
        -> Root cause analysis     -> CAPA plan (corrective + preventive)
        -> Implement (train, update SOP/BMR)
        -> Effectiveness check  --(not effective)--> re-open / escalate
        -> QA closure -> feeds the APQR

CAPA is fed by the rest of your quality system — deviations and the wider QMS, OOS investigations, market complaints and product recalls — and every closed CAPA rolls up into the Annual Product Quality Review.

Why CAPA is required (regulatory basis)

• ICH Q10 names CAPA as a core Pharmaceutical Quality System element.
• US FDA 21 CFR 211 / 820.100 require root cause analysis, effectiveness verification, and records.
• EU GMP Chapter 1 requires a CAPA system within the PQS.
• India's revised Schedule M explicitly requires CAPA, root cause analysis and effectiveness review.

From template to live system

A Word/Excel template is a fine start, but on paper CAPA breaks at the seams: the deviation is in one file, the CAPA in another, the effectiveness check in a third, and nobody has a single view of what's open and overdue. A workflow-based quality system fixes that structurally — every CAPA links to its source deviation/OOS/complaint, the effectiveness check is a scheduled stage that can't be skipped, a live dashboard shows open/overdue/recurring CAPAs, and a built-in audit trail supports ALCOA+ data integrity by design.

Frequently asked questions

What is the CAPA format?

A CAPA format is the standard record structure for a Corrective and Preventive Action: CAPA number, source/trigger, description, risk, correction, root cause, corrective and preventive actions, change-control reference, effectiveness check, status and QA closure. Download the Excel template above.

Is the CAPA template free to download?

Yes — the Excel template above is free and needs no sign-up. Adapt the fields to your own SOP and numbering.

What is the difference between correction and corrective action in CAPA?

A correction is the immediate fix to the symptom (e.g. quarantine the batch). A corrective action eliminates the root cause so the problem does not recur.

What is a CAPA effectiveness check?

A verification, after a defined period, that the corrective/preventive action actually prevented recurrence — backed by objective evidence. Without it a CAPA cannot be properly closed.

Which regulations require CAPA?

ICH Q10, US FDA 21 CFR 211/820, EU GMP, and India's revised Schedule M.

Flobri runs CAPA as a connected digital workflow — linked to its source deviation, OOS or complaint, with root cause capture, a scheduled effectiveness check, a live overdue-CAPA dashboard and a built-in audit trail — so CAPA is a system you can prove, not a folder you hope holds up. See how Flobri turns a process description into a live workflow.