Want to Do FMEA - Failure Mode and Effects Analysis in Excel?

QI Macros FMEA Excel Templates Make It Easy!

Create FMEAs using QI Macros

  1. Select FMEA 4th or 5th.
  2. Click on QI Macros menu > DOE MSA - FMEA.
  3. Fill in the blanks

* 5th Edition FMEA (AIAG & VDA FMEA 1st Edition) introduced in QI Macros' October 2019 release *

Go Deeper: Preventing Disaster with FMEA, DFMEA, PFMEA and FMEA-MSR

When you are designing a product or a process that can affect human life, you want to anticipate all of the ways things could go wrong and affect your customer.

The automobile and airline industries do this routinely to mitigate and prevent potential problems. The tool they use is the Failure Modes and Effects Analysis (FMEA).

QI Macros add-in for Excel contains an easy-to-use FMEA Template to guide you through your analysis. You can use it to analyze a:

  • Product (car, x-ray, MRI) using a Design FMEA (DFMEA)
  • Part (car door) using a Design FMEA (DFMEA)
  • Process (part stamping process or elective surgery) using a Process FMEA (PFMEA)
  • Project identification (legal and/or technical requirements, customers' wants/needs/expectations) using a FMEA for Monitoring and System Response (FMEA-MSR)
Gary Larson's crisis clinic and fmea

Seven-Step FMEA Approach

The updated AIAG & VDA FMEA 1st Edition handbook describes a Seven-Step approach that guides design development and process, along with monitoring and FMEA system response:

  1. Planning and Preparation: Develop a FMEA project plan.
  2. Structure Analysis: Using a visual method, decide which product or process that will be analyzed.
  3. Function Analysis: For both your Design (DFMEA) and Process (PFMEA), choose which functions will be performed, along with HOW you will evaluate their performance(s).
  4. Failure Analysis: What is/are the failure mode(s)? And what effects or causes these failures?
  5. Risk Analysis: Assign severity of risk, along with occurrence and detection of the cause of failure. This allows you to estimate your level of design or your process risk.
  6. Optimization: Based upon your Risk Analysis from step 6, decide which aspects of your FMEA will require actions that reduce your risk. And what are those actions?
  7. Results and Documentation: Document your findings! How did you reduce risk, and what were the actions taken? Create a comprehensive report that shows your findings.

Example of the QI Macros FMEA Template in Excel


Use the DFMEA or PFMEA template to analyze and prevent the effects of potential failures before they happen. Can you afford an injury or a death? Probably not. Can you afford the time and money involved in litigation? Probably not. Is it cheaper to use an FMEA worksheet and prevent potential problems? No doubt, especially when the consequences are extreme. Are you going to catch everything? No, because some things are outside of our ability to imagine them.

Stop Struggling with FMEAs!
Start creating your FMEAs in just minutes.

Download a free 30-day trial. Get FMEAs now!

Learn More ...

Why Choose QI Macros for Excel?

easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free



  • Only $349 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support