These Six Sigma Excel templates are free. Each one sits on the article that teaches the tool, so you learn the method and get the file in the same place. Most come with a worked example already filled in. Swap in your own data, and then check your answer against the article.

There are 67 templates below, sorted by DMAIC phase, plus three Lean tools. The order follows the phases in the ASQ Six Sigma Green Belt Body of Knowledge: Define, Measure, Analyze, Improve and Control. Click a template name to open its article. The download link is on that page.

Six Sigma Excel templates

Free Six Sigma Excel Templates by DMAIC Phase

Define

Scope the project and tie it to the customer and the money.

Measure: Map the Process and Collect the Data

Start with the map. Next, plan how you will collect the data, then collect it.

Measure: Plot the Data and Baseline the Process

Check the gage first. After that, plot the data and set your starting sigma level.

Analyze

The hypothesis tests come one file per tail, so pick the tail that matches your alternative hypothesis. These Six Sigma Excel templates cover Green Belt and Black Belt topics.

Improve

Before you roll out a fix, find out how it could fail.

  • FMEA Template: Rank what could go wrong by severity, occurrence and detection. Then fix the top risks before you roll out the change.

Control

Hold the gain. The control plan says who watches what, and the charts tell you when to act.

Lean

Find the waiting and the waste, and set the pace to customer demand.

Three More Templates, Free With Your Email

These three Six Sigma Excel templates are our newest. Enter your email in the box on the article, and you can download the file right away.

  • Process Map and SIPOC Template: a SIPOC, a swimlane map, a step analysis that totals value-added time, and the standard flowchart symbols.
  • House of Quality Template: weighted technical importance calculated for you, competitor ratings, target values and the roof correlation matrix, with a worked example.
  • Porter’s Five Forces Worksheet: rate each force factor by factor. It scores and charts all five forces and leaves room for your response to each.

Build Your Own in Excel

Would you rather build the chart yourself than use one of our Six Sigma Excel templates? The Pareto chart article has a video that walks through it in Excel. Likewise, the box and whisker plot article lists the steps. Need a template that is not here? Tell us what you are working on.

Every Template for Your Belt in One Place

Members do not need to hunt for these Six Sigma Excel templates. Each paid course has a Downloads section with the templates for that belt, sorted by DMAIC phase, with a link to each lesson. See the study guide plans.

Comments (6)

Hi Hani,

If you’re preparing for a Six Sigma exam, there is no better way to do so than through my materials. You can sign up here.

Also included are all of my templates available for download.

Best, Ted.

Hi Krishnakumar,

My Six Sigma templates are available on each of the pages the concept is discussed. They can be downloaded if you are logged in with a valid membership.
For example, if you are looking for the template for 2 sample z proportions, then go to that page and download from there.

Best, Ted.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.