FMEA Template: Free Worksheet Structure for DFMEA, PFMEA, and FMECA
A good FMEA template enforces the right structure so your team focuses on analysis, not formatting. A bad template creates a false sense of completeness: every column filled, every row populated, but the content is generic and the analysis is shallow. This guide provides the complete column structures for DFMEA, PFMEA, FMECA, and medical device FMEA templates, along with scoring tables, so you can build a worksheet that matches your standard.
For background on the FMEA process, see our What Is FMEA guide. For scoring details, see our RPN and Action Priority guide.
Why Templates Matter (and Where They Fall Short)
What a template does well: Standardizes the structure. Ensures required columns are present. Gives new team members a starting point. Makes FMEAs consistent across projects and sites.
What a template cannot do: Generate failure modes. Suggest causes. Validate scores. Link to source documents. Update when new data arrives. A template is a container. The quality of the FMEA depends entirely on what you put in it.
Teams that mistake “filled template” for “completed FMEA” produce shelf-ware. The template is the starting line, not the finish line. For why templates alone are not enough, see our FMEA Excel Alternative post.
AIAG-VDA DFMEA Template (Design FMEA)
The AIAG-VDA FMEA Handbook (2019) defines specific columns for DFMEA. This is the structure OEM STA engineers expect in PPAP submissions.
| # | Column | Purpose | Step |
|---|---|---|---|
| 1 | Structure: Focus Element | Component or subsystem being analyzed | 2 |
| 2 | Structure: Higher-Level Element | Parent system or assembly | 2 |
| 3 | Structure: Lower-Level Element | Sub-component or detail | 2 |
| 4 | Function of Focus Element | What the element must do | 3 |
| 5 | Requirement | Measurable design requirement | 3 |
| 6 | Failure Mode | How the function fails | 4 |
| 7 | Failure Effect (End User) | Impact on customer or safety | 4 |
| 8 | Severity (S) | 1-10 per AIAG-VDA table | 5 |
| 9 | Failure Cause | Design condition leading to failure | 4 |
| 10 | Prevention Control (PC) | Design activity that prevents the cause | 5 |
| 11 | Occurrence (O) | 1-10 per AIAG-VDA table | 5 |
| 12 | Detection Control (DC) | Design activity that detects failure/cause | 5 |
| 13 | Detection (D) | 1-10 per AIAG-VDA table | 5 |
| 14 | Action Priority (AP) | High / Medium / Low from AP table | 5 |
| 15 | Recommended Action | What to do for High/Medium AP items | 6 |
| 16 | Responsible Person | Action owner | 6 |
| 17 | Target Date | Completion target | 6 |
| 18 | Status | Open / In Progress / Complete | 6 |
| 19 | Action Taken | What was actually done | 6 |
| 20-23 | Revised S, O, D, AP | Re-scored after action completion | 6 |
| 24 | Special Characteristic | Flag for safety/critical characteristics | 7 |
| 25 | Remarks / Source | Notes, traceability to source documents | 7 |
For a worked example using this template, see our automotive DFMEA example.
AIAG-VDA PFMEA Template (Process FMEA)
The PFMEA template is similar to DFMEA but the content is process-oriented.
| # | Column | PFMEA-Specific Notes |
|---|---|---|
| 1 | Process Step / Operation # | Matches process flow diagram (PFD) |
| 2 | Process Item (Focus Element) | The specific operation being analyzed |
| 3 | 4M Category | Man / Machine / Material / Method |
| 4 | Process Function | What the step must achieve |
| 5 | Product Characteristic | The dimension, property, or feature controlled |
| 6 | Process Failure Mode | How the step fails to produce the design intent |
| 7 | Failure Effect (End User) | Impact on next operation, customer, safety |
| 8 | Severity (S) | Inherited from DFMEA for corresponding characteristic |
| 9 | Failure Cause (4M) | Root cause categorized by Man/Machine/Material/Method |
| 10 | Prevention Control | Process parameter, poka-yoke, SPC that prevents the cause |
| 11 | Occurrence (O) | Based on process capability data and history |
| 12 | Detection Control | Inspection, test, or monitoring that catches the defect |
| 13 | Detection (D) | Based on detection method effectiveness |
| 14 | Action Priority (AP) | From AIAG-VDA PFMEA AP table |
| 15-23 | Optimization columns | Same as DFMEA: action, owner, date, revised scores |
| 24 | Control Plan Reference | Link to control plan entry for this process step |
For a worked example, see our PFMEA manufacturing example.
IEC 60812 FMECA Template
IEC 60812:2018 is the international standard for FMEA and FMECA across industries. The FMECA template adds criticality columns.
| # | Column | Notes |
|---|---|---|
| 1 | Item / Function | Equipment, component, or function |
| 2 | Failure Mode | How the item could fail |
| 3 | Local Effect | Impact on the item itself |
| 4 | End Effect | Impact on the system or end user |
| 5 | Severity Category | Categorical (I, II, III, IV per MIL-STD-1629A or custom) |
| 6 | Failure Rate / Probability | Quantitative failure rate or probability category |
| 7 | Criticality Number | Severity × probability (or per criticality formula) |
| 8 | Detection Method | How the failure is detected |
| 9 | Compensating Provisions | Redundancy, alarms, maintenance tasks |
| 10 | Recommended Action | Risk reduction measures |
| 11 | Remarks | Notes and traceability |
FMECA is common in defense (MIL-STD-1629A), aerospace, and asset-intensive industries. For more on FMECA vs FMEA, see our DFMEA vs PFMEA vs FMECA guide.
ISO 14971 Medical Device Template
Medical device DFMEA requires additional columns beyond automotive templates. See our ISO 13485 DFMEA guide for the full template with column-by-column explanation. Key additions:
- Intended use / foreseeable misuse context
- Hazardous situation (not just failure mode)
- Severity based on patient harm categories (Negligible through Catastrophic)
- Risk acceptability decision (Acceptable / ALARP / Unacceptable)
- Residual risk evaluation after controls
- Benefit-risk analysis reference where applicable
- Verification / validation reference for each risk control
Do not use an automotive FMEA template for medical devices without adding these columns. Auditors will cite the omission.
Severity, Occurrence, and Detection Scoring Tables
These quick-reference tables cover the most common scoring criteria. For a deep dive, see our RPN and Action Priority guide.
Severity (S) - AIAG-VDA
| Score | Effect |
|---|---|
| 1 | No effect |
| 2-3 | Minor: slight inconvenience |
| 4-6 | Moderate: loss of comfort or secondary function |
| 7 | High: loss of primary function |
| 8 | Very high: safety hazard with warning |
| 9-10 | Hazardous: safety/regulatory, with or without warning |
Occurrence (O)
| Score | Likelihood |
|---|---|
| 1 | Extremely unlikely |
| 2-3 | Remote to very low |
| 4-5 | Low to moderate |
| 6-7 | Moderately high to high |
| 8-10 | Very high to almost certain |
Detection (D)
| Score | Likelihood of Detection |
|---|---|
| 1 | Almost certain to detect |
| 2-3 | Very high to high chance |
| 4-5 | Moderately high to moderate |
| 6-7 | Low to very low |
| 8-10 | Remote to no detection method |
Common Template Mistakes
Using the wrong template for your standard. An AIAG-VDA template missing the 3-level structure (higher/focus/lower element) does not match the 7-step method. An ISO 14971 template without risk acceptability does not meet the medical device standard. Match the template to your regulatory context.
Templates without scoring criteria. A template that shows the column “Severity (1-10)” without defining what each score means produces inconsistent scoring across team members. Include the scoring tables on a reference tab or within the template instructions.
No header information. The AIAG-VDA handbook requires a header section with project name, team, date, revision, and scope (the 5T planning information). Templates without headers produce FMEAs that cannot be traced to a specific project or team.
Copy-pasting content, not just structure. Templates with pre-filled failure modes are useful as examples but dangerous as defaults. Teams accept the pre-filled content without evaluating whether it applies to their specific product or process. Use templates for structure. Generate content from your own data.
Beyond Templates: Why Teams Outgrow Excel
Templates solve the “where do I start?” problem. They do not solve the “how do I maintain 50 FMEAs across 12 product lines?” problem. When you outgrow templates:
- Version control becomes unmanageable
- Cross-referencing between DFMEA, PFMEA, and control plan breaks down
- Knowledge stays in individual spreadsheets instead of a shared library
- Updates require manual effort that no one has time for
At that point, dedicated FMEA software or AI-powered platforms offer structural advantages that templates cannot. See our FMEA Excel Alternative guide and Best FMEA Software 2026 comparison for options.
How Tacit AI Approaches This
Tacit AI’s FMEA Template Generator creates starter FMEA structures tailored to your equipment, process, or product - not generic templates, but structures informed by your actual data.
Standards-aligned output. Templates match AIAG-VDA, IEC 60812, ISO 14971, SAE J1739, or MIL-STD-1629A column structures. You choose the standard. The platform enforces the right columns, scoring tables, and required fields.
Pre-populated from your data. Instead of starting from empty columns, Tacit AI generates draft FMEA content from your engineering documents and work order data. The result is a template with real failure modes, not blank rows waiting to be filled.
Failure mode libraries that grow. Each FMEA you create or review adds to a reusable knowledge base. The next project starts from a richer foundation. After 6-12 months, your “template” contains the collective knowledge of your engineering team.
Ready to move beyond blank templates? Book a working session and see what Tacit AI generates from your data. For a step-by-step walkthrough, see our DFMEA tutorial or PFMEA manufacturing example.
Frequently Asked Questions
Which FMEA template should I use?
Match the template to your standard: AIAG-VDA for automotive, IEC 60812 for general industry or defense, ISO 14971 for medical devices. If you are unsure, start with the AIAG-VDA DFMEA or PFMEA template - it is the most structured and translates well to other standards. See our FMEA guide for standard selection.
Can I modify the template for my organization?
Yes. Templates are starting points. Many organizations add columns (e.g., source traceability, special characteristic flags, control plan reference) or customize scoring criteria for their industry. The key requirement is that the modified template still meets the standard your customers and auditors expect.
Where can I get a free FMEA template?
The column structures in this article are the template. Build them in Excel, Google Sheets, or any spreadsheet tool. The AIAG publishes a reference form in the AIAG-VDA FMEA Handbook. Many FMEA software tools also provide templates as part of onboarding. For AI-generated templates populated with your data, see Tacit AI.
Is an Excel FMEA template enough for PPAP?
An Excel template with the right columns and properly completed content can pass PPAP. The challenge is maintaining quality as FMEAs grow in size and number. See our Ford PPAP FMEA Requirements for what gets accepted and rejected.