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.

Free Six Sigma Excel Templates by DMAIC Phase
Define
Scope the project and tie it to the customer and the money.
- Project Charter Template: Write the problem, goal, scope and team on one page before the work starts.
- SIPOC Template: The one-sheet version. Pin down where the process starts and stops.
- Cost of Poor Quality (COPQ) Template: Put a dollar figure on the problem. That number gets you a sponsor.
- Communication Plan Checklist: Who hears what, and how often. Fill it in at kickoff.
- QFD House of Quality Template: Turn what customers say into things you can measure.
Measure: Map the Process and Collect the Data
Start with the map. Next, plan how you will collect the data, then collect it.
- Process Flow Chart: Map the steps as they really happen, not as the procedure says.
- Deployment (Swimlane) Flowchart: Same map with one lane per department. Then the handoffs jump out.
- Data Collection Form: Decide what, where, who and how before anyone writes down a number.
- Check Sheet (parts assembly example): Tally defects by type as they happen.
- Inspection Checklist: A yes or no line for every inspection step.
- Tally Sheet and Check Sheet Template: Count by category, and the chart draws itself.
- Cause and Effect (Fishbone) Diagram Template: Brainstorm causes under the 6Ms with your team.
- Cause and Effect Matrix Template: Score your inputs against what the customer cares about. After that, work the top few.
Measure: Plot the Data and Baseline the Process
Check the gage first. After that, plot the data and set your starting sigma level.
- Pareto Chart Template: Find the few categories behind most of the defects.
- Histogram Template: See the shape and spread of your data.
- Dot Plot Template: A quick picture of a small data set.
- Box Plot Template: Compare the spread of several groups side by side.
- Run Chart Template: Plot your data over time. Trends and shifts show up fast.
- Gage R&R Template (ANOVA method): How much of your variation is the measurement system? Check before you trust the data.
- Gage R&R Template (Average and Range method): The quicker hand method. Same question, easier math.
- Attribute Gage R&R Template: Check pass or fail inspectors against each other and against the standard.
- DPMO and Sigma Level Template: Turn defects and opportunities into yield, DPMO and sigma level.
- Rolled Throughput Yield Template: Multiply the step yields to see how many units get through right the first time.
- Baseline Sigma Templates (discrete and continuous data): Your starting sigma level, from defect counts or from spec limits, mean and standard deviation.
- Z Score Templates (positive and negative z): Find the area under the normal curve for any z value.
- Hypergeometric Distribution Template: The odds of finding defects when you sample a small lot without replacement.
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.
- One Sample Z Test (two tailed, right tailed and left tailed): Compare a sample mean to a target when you know the population standard deviation.
- One Sample T Test (two tailed, right tailed and left tailed): Compare a sample mean to a target when you do not know it.
- Two Sample Z Test (two tailed, right tailed and left tailed): Compare two means when both standard deviations are known.
- Two Sample T Test, equal variances (two tailed, right tailed and left tailed): Compare two means when the spreads match.
- Two Sample T Test, unequal variances (two tailed, right tailed and left tailed): Compare two means when the spreads do not match.
- Paired T Test (two tailed, right tailed and left tailed): Before and after on the same units.
- One Proportion Z Test (two tailed, right tailed and left tailed): Compare a defect rate to a target rate.
- Two Proportion Z Test (pooled and unpooled): Compare two defect rates. ASQ and Villanova use pooled, while IASSC uses unpooled.
- F Test for Two Variances (two tailed, right tailed and left tailed): Is one process more variable than the other?
- One Way ANOVA Template: Compare three or more means in one test.
- Chi Square Goodness of Fit Template: Do your counts match the split you expected?
- Chi Square Normality Check Template: Test whether grouped data fits a normal curve.
- Chi Square Test of Independence Template: Are two categories related, or is it chance?
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.
- Control Plan Template: What you measure, how often, and what you do when it drifts.
- p Chart Template: Fraction defective. Sample size can change.
- np Chart Template: Number defective. Same sample size every time.
- c Chart Template: Count of defects. Same size inspection unit every time.
- u Chart Template: Defects per unit. Sample size can change.
- EWMA Chart Template: Catches the small shifts a regular control chart misses.
Lean
Find the waiting and the waste, and set the pace to customer demand.
- Value Stream Map Template (Excel 97 to 2003 file): Map the material and information flow. Then find the waiting.
- Takt Time Calculator: Available time divided by customer demand. That is your pace.
- Lean Metrics Template: Flow time, cycle time and process cycle efficiency from your WIP and throughput.
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)
i need it
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.
Where can I get the Six Sigma Green Belt templates
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.
Need templates
What kind of templates, Prasad? There are many on the site and I’m happy to direct you to exactly what you need.