A complete FMEA template needs 12 columns: from Function and Failure Mode through Severity, Occurrence, Detection, RPN, and post-action revised scores. Below you’ll find free downloads (Excel, Word, PDF), the blank template you can copy directly into Excel or Google Sheets, a guide to what each column means, and a step-by-step setup guide.
Download the FMEA template
Free FMEA worksheet with all 12 columns plus revised-score tracking. The Excel version has the RPN formula (S×O×D) pre-filled, 1–10 score validation, and red/amber/green risk formatting. No signup, no email, direct download.
FMEA Template — Excel
Editable .xlsx with auto-calculating RPN, 1–10 dropdowns, and color-coded risk levels. Works in Excel, Google Sheets, and LibreOffice.
Download .xlsxFMEA Template — PDF
Printable A4 worksheet for workshops and design reviews. Fill by hand, then transfer the scores into the spreadsheet.
Download .pdfFMEA Template — Word
Editable .docx (landscape) for Microsoft Word or Google Docs — best when the FMEA is part of a longer quality report.
Download .docxFMEA Calculator — Online
Enter failure modes and scores; RPN calculates automatically with color-coded risk levels. No spreadsheet setup.
Open the toolChoose Your Format
Online FMEA Calculator
Enter your failure modes and scores — RPN calculates automatically with color-coded risk levels (green / amber / red). No spreadsheet setup required.
Open FMEA Calculator →No signup · Works on mobile · PDF export
Excel / Google Sheets
Copy the blank template below into a spreadsheet. Add the RPN formula and conditional formatting to highlight high-risk items automatically.
Step-by-step setup guide below ↓
The Blank FMEA Template
Copy this structure into Excel or Google Sheets. The grey italic cells show what type of content goes in each column — replace them with your own data.
📋 FMEA Worksheet — Blank Template
Header row: add Product/Process Name, FMEA Type (DFMEA / PFMEA), Revision, Date, Team Members.
| Item / Function | Potential Failure Mode | Potential Effect(s) | S | Potential Cause(s) | O | Current Controls | D | RPN | Recommended Action | Owner | Target Date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Enter function or process step | How could this fail? | What happens to the customer? | — | Why does the failure occur? | — | What controls exist today? | — | — | What action will reduce risk? | Name | MM/DD/YY |
| — | — | — | — | ||||||||
| — | — | — | — |
After completing actions, add four more columns: Revised S · Revised O · Revised D · New RPN — to document that risk has been reduced.
What Each Column Means
| Column | What to enter |
|---|---|
| Item / Function DFMEA: component or subsystem. PFMEA: process step. |
The function being analyzed, stated as a verb + noun: “Seal fluid pressure”, “Fill mold cavity”, “Authenticate user”. |
| Potential Failure Mode How the function fails to perform. |
The specific way the function could fail: “Leak at joint”, “Short shot”, “Session not invalidated on logout”. One row per failure mode. |
| Potential Effect(s) What the customer or downstream process experiences. |
Describe the worst reasonable consequence: “Reduced braking force”, “Defective part — scrap”, “Patient harm”. |
| Severity (S) Rate 1–10. 9–10 = safety or regulatory impact. |
Rate the severity of the effect on the customer. Rate the effect as if the failure actually occurred — not the probability. S never changes unless the design changes. |
| Potential Cause(s) Root cause or failure mechanism. |
The specific, correctable root cause: “Insufficient clamp pressure”, “No idempotency key on retry”. Avoid vague causes like “human error”. |
| Occurrence (O) Rate 1–10. Use historical data when available. |
Likelihood that the cause leads to the failure mode. Use failure rate data, warranty history, or process capability (Cpk) where possible. |
| Current Controls Prevention AND detection controls both go here. |
List everything that currently exists to prevent the cause or detect the failure: inspections, tests, poka-yoke, SPC, design reviews. Separate prevention from detection controls if your format allows. |
| Detection (D) Rate 1–10. Lower = better. 1 = almost certain to catch. |
Likelihood that current controls will detect the failure or cause before it reaches the customer. D = 1 means a poka-yoke or 100% automated check. D = 10 means no detection control. |
| RPN = S × O × D. Range 1–1,000. |
Calculated automatically: RPN = S × O × D. Sort descending to find the highest-risk items. Also review any row with S ≥ 9 regardless of RPN. |
| Recommended Action Specific corrective action — not “improve controls”. |
Be specific: “Add in-cavity pressure sensor with alarm at < 800 bar”, not “monitor injection pressure more carefully”. The action should reduce S, O, or D. |
| Owner + Target Date | Name one person responsible. Set a specific date. Without these, FMEA actions rarely get implemented. |
How to Set Up the FMEA Template in Excel
- Create the header block. In rows 1–4, add: Product/Process Name, FMEA Type (DFMEA or PFMEA), Revision number, Date prepared, and Team members. This becomes the document header for printing and version control.
- Add the column headers in row 5. The 12 columns in order: Item/Function — Failure Mode — Effect — S — Cause — O — Controls — D — RPN — Recommended Action — Owner — Target Date. Bold the header row and freeze it (View → Freeze Top Row).
- Set column widths. Item/Function: 160px. Failure Mode, Effect, Cause, Controls, Action: 180px each. S, O, D, RPN: 50px each. Owner: 100px. Target Date: 90px. Freeze column A so the function stays visible when scrolling right.
- Add the RPN formula. If S is in column D, O in column F, D in column H, enter in column I (row 6):
=D6*F6*H6. Drag down for all rows. Format column I as a number with no decimal places. - Add conditional formatting to RPN. Select the RPN column → Conditional Formatting → New Rule. Add three rules: RPN ≥ 200 = red fill; RPN 100–199 = amber fill; RPN < 100 = green fill. This gives instant visual risk triage.
- Add a data validation dropdown for S, O, D columns. Select the S column cells → Data → Data Validation → List → enter
1,2,3,4,5,6,7,8,9,10. Repeat for O and D. This prevents typos and speeds up scoring. - Sort and filter. Add AutoFilter to row 5 (Data → Filter). After filling in all rows, sort by column I (RPN) descending to instantly see your top priorities. Use the filter to view only high-severity or high-RPN items.
DFMEA Template vs PFMEA Template
The column structure is identical. What changes is who fills it in, and what they enter in the first two columns:
| DFMEA | PFMEA | |
|---|---|---|
| Filled in by | Design / engineering team | Manufacturing / process engineering |
| “Item / Function” column | Product component or subsystem and its design function | Manufacturing process step and its intended output |
| “Failure Mode” column | Design weakness: wrong material, insufficient clearance, missing feature | Process deviation: under-torque, wrong dimension, contamination |
| “Controls” column | Design reviews, FEA, prototype tests, design standards | SPC, go/no-go gauges, poka-yoke, operator instructions |
| Typical actions | Design change, tolerance revision, material upgrade | Process parameter change, new inspection step, mistake-proofing device |
| When to run | During concept and detail design phases | Before process validation and production launch |
5 Tips for a More Useful FMEA Template
- One failure mode per row. Never combine two failure modes in a single row. If a function has three possible failure modes, it gets three rows — each with its own S, O, D, and RPN.
- Be specific in the Cause column. “Operator error” is not a useful cause — it tells you nothing to fix. “Torque wrench not calibrated — reads 10% low” is actionable.
- Rate S, O, D independently. Teams often anchor on RPN and then work backwards to justify it. Rate each dimension independently before calculating RPN.
- Review S ≥ 9 items in a separate pass. After sorting by RPN, do a second pass that filters for S ≥ 9 regardless of RPN. These are your safety and compliance items — they require action even if O and D scores keep the RPN low.
- Set a document revision schedule. Add a “Next review date” cell to your header block. FMEA is a living document — it should be reviewed whenever the design or process changes, and at minimum annually.
When an FMEA Risk Becomes a Real Failure
Our free 5 Whys and Fishbone tools help you investigate the root cause in minutes — no signup, no downloads.
Explore Free RCA Tools →Frequently Asked Questions
What columns does an FMEA template need?
A standard FMEA template needs: Item/Function, Potential Failure Mode, Potential Effect(s), Severity (S, 1–10), Potential Cause(s), Occurrence (O, 1–10), Current Controls, Detection (D, 1–10), RPN (S×O×D), Recommended Action, Owner, and Target Date. A complete template also includes post-action revised S, O, D, and New RPN columns to track risk reduction after corrective actions are implemented.
What is the difference between a DFMEA and PFMEA template?
Both use the same column structure. The difference is who fills it in and what goes in the first two columns. A DFMEA template is filled in by the design engineering team and lists product components and design functions. A PFMEA template is filled in by the manufacturing/process engineering team and lists process steps and their intended outputs. The RPN scoring methodology is identical for both.
How do I calculate RPN in Excel?
Place your Severity score in one column (e.g., D), Occurrence in the next (F), and Detection after that (H). In the RPN column (I), enter the formula =D6*F6*H6 and drag it down. Then apply conditional formatting: red for RPN ≥ 200, amber for 100–199, green for < 100. Sort column I descending to see highest-risk items first. Add a data validation dropdown (1–10) on the S, O, and D columns to prevent scoring errors.
Is there a free FMEA template I can use right now?
Yes — copy the blank template on this page directly into Excel or Google Sheets. The column structure follows the AIAG-VDA FMEA standard used in automotive, aerospace, and medical devices. Or use our free online FMEA Calculator which fills in the worksheet and calculates RPN automatically with color-coded risk levels, no spreadsheet setup required. CSV download and PNG export included.
Related Resources
- FMEA: The Complete Guide — RPN formula, rating scales, 7-step process, DFMEA vs PFMEA
- FMEA Examples: 6 Real-World Cases Across Industries — full worksheets from manufacturing, healthcare, software, and aerospace
- RCA Tools Compared: 5 Whys, Fishbone, FTA, FMEA & Pareto
- Free 5 Whys Tool — investigate failures that your FMEA did not prevent