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.

CAPA Format and Template — Free Excel Download with Filled Example

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.

| Field | What goes in it |

|---|---|

| CAPA No. / Date raised | Unique ID + date logged |

| Source / Trigger | Deviation no., OOS no., complaint no., audit ref |

| Description | What happened, where, batch/product affected |

| Risk classification | Minor / Major / Critical |

| Correction (immediate) | Containment taken right away (quarantine, line stop) |

| Root cause | Method used (5 Whys / Fishbone / FMEA) + the actual cause |

| Corrective action(s) | Action · owner · target date |

| Preventive action(s) | Same problem prevented on other lines/products/sites |

| Change control ref | If a process/SOP/spec change is needed |

| Effectiveness check | Criteria · due date · evidence · verdict |

| Status | Open / Overdue / Closed |

| QA closure | Approver · date |

A filled CAPA example

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

| Field | Example entry |

|---|---|

| CAPA No. / Date | CAPA-2026-014 · 12 Jun 2026 |

| Source / Trigger | OOS-2026-031 — moisture content out of specification, Batch B-4471 |

| Description | Tablet moisture 4.8% vs spec ≤ 3.0% on Compression Line 2; batch quarantined |

| Risk | Major |

| Correction | Batch B-4471 quarantined; Line 2 held pending investigation |

| Root cause | 5 Whys → dehumidifier on Line 2 failed; failure not caught because it was not on the preventive-maintenance schedule |

| Corrective action | Repair/replace dehumidifier; add it to PM schedule — Owner: Engineering, due 20 Jun 2026 |

| Preventive action | Audit dehumidifiers on Lines 1, 3, 4 and add all to PM schedule — Owner: Engineering, due 30 Jun 2026 |

| Change control | CC-2026-009 (PM schedule revision) |

| Effectiveness check | Next 3 batches on Line 2 within moisture spec + PM record shows dehumidifier serviced — due 31 Jul 2026 |

| Status | Open |

| QA closure | — (pending effectiveness check) |

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.