Free FMEA Template — Excel, Google Sheets & Online (2026)

Q: 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.

Q: 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.

Q: 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.

Q: 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. Our free online FMEA Calculator (coming soon at 5xwhys.com/tools/) will let you fill in the worksheet and calculate RPN automatically with color-coded risk levels, without any spreadsheet setup.

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 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.

Choose Your Format

Coming Soon

Online FMEA Calculator

Enter your failure modes and scores — RPN calculates automatically with color-coded risk levels (green / amber / red). No spreadsheet setup required.

Explore Free Tools →

No signup · Works on mobile · PDF export

Available now

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.

Tip: Add four columns at the right for post-action tracking: Revised S, Revised O, Revised D, New RPN (formula = Revised S × Revised O × Revised D). Fill these in after corrective actions are complete to document that risk has been reduced and to satisfy IATF 16949 / ISO 13485 audit requirements.

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?