Free FMEA Template (Excel)
What is an FMEA and when to use this template
FMEA (Failure Mode and Effects Analysis) is a structured way to catch problems before they happen: for each step in a process or design, you name what could go wrong, how bad it would be, how likely it is, and how easily you'd catch it before it reaches a customer.
This template gives you one sheet built for that workflow, pre-formatted with 50 rows so you can start scoring failure modes immediately instead of building the column structure and formulas yourself.
It works equally well as a Design FMEA (evaluating a product or part) or a Process FMEA (evaluating a manufacturing or service process) - the same columns apply to both, you just change what you put in the Process step / item column.
How the severity, occurrence, and detection scoring works
Each failure mode gets three 1-10 scores: Severity (how serious the effect is), Occurrence (how likely the cause is to happen), and Detection (how likely your current controls are to catch it before it causes harm - a 10 means you'd probably miss it).
The Risk Priority Number multiplies the three: RPN = Severity x Occurrence x Detection, giving you a single number from 1 to 1000 to rank every failure mode by, without doing the math by hand.
Because RPN recalculates the instant you change any of the three scores, you can immediately see the effect of a corrective action that lowers occurrence or improves detection.
Reading the RPN risk heat map
Conditional formatting colors each row by its RPN automatically: anything over 200 highlights red as a high-risk item, and 126-200 highlights amber as elevated risk, so a long list of failure modes turns into a visual priority order at a glance.
The summary counts above the table total how many items fall in each band, so you can report exactly how many are high-risk or elevated without manually scanning the sheet.
Work the red rows first, then the amber ones - rescoring a failure mode after a corrective action often drops it out of the highlighted range entirely, which is a fast way to show progress in a review meeting.
Tracking corrective actions to closure
Each row has a Recommended action, Owner, and Status (Open, In progress, Closed) column, so the FMEA doesn't stop at identifying risk - it becomes the tracker for closing it out too.
As actions get implemented, go back and lower the Occurrence or Detection score to reflect the real improvement, and watch the RPN and its color drop accordingly.
The Status column lets you sort or filter to see exactly which open items still need attention before a design review or audit.
Design FMEA vs Process FMEA: which tab to use
This template is one flexible sheet rather than separate Design and Process tabs - you decide which type of FMEA you're running by what you put in the Process step / item and Potential cause columns.
For a Design FMEA, that means part names and design causes (material choice, tolerance, geometry); for a Process FMEA, it means operation steps and process causes (fixture, machine setting, operator handling).
If you run both types regularly, duplicate the sheet (right-click the tab > Move or Copy) and keep one copy per FMEA type so your 50 rows aren't split between two projects.
How to use it
- List each process step or design item with its potential failure mode, effect, and cause.
- Score Severity, Occurrence, and Detection from 1 to 10 for each row - the RPN calculates automatically as Severity x Occurrence x Detection.
- Scan the color-coded RPN column: red is over 200, amber is 126-200. Work the red rows first.
- Assign a recommended action, owner, and status to each item, then rescore Occurrence or Detection after the action closes to show the improvement.
Download the free Free FMEA Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
Can I use this FMEA template in Google Sheets?
Yes. Upload the file to Google Drive and open it with File > Save as Google Sheets. The scoring formulas and RPN calculation keep working.
Is this template really free?
Yes. You give an email address to download it, and it's yours to use afterward with no further cost.
How many failure modes can I track?
The sheet ships with 50 rows, which covers most single-process or single-design FMEAs. If you need more, copy the RPN formula down into additional rows.
What do the Severity, Occurrence, and Detection scores actually mean?
Severity rates how serious the effect on the customer or next process would be, Occurrence rates how likely the cause is to happen, and Detection rates how likely your current controls are to catch it first - a 10 in Detection means you'd probably miss it.
Can I edit the layout or add my company logo?
Yes, it's a standard Excel/Google Sheets file. Add a logo, resize columns, or add extra rows - just don't delete the RPN formula cells.
What's the usage license?
Personal use or use within one business. It's not meant to be resold or redistributed as a template product.