Buy Now

Check Sheet
Excel and Google Sheet Template

Our Check Sheet Excel and Google Sheet Template provides a structured format to collecting and analyzing production data. Equipped with dynamic Pareto and Defects charts and formulas, improve your quality control processes with this spreadsheet.
Buy Now

What's Inside the Check Sheet Template?

Details | 2 Sheets 

Supported Versions | Excel 2010, 2013, 2016, 2019, Office 365 (Mac), Google Sheets

Category | Supply Chain & Operations

Tags | Supply Chain, Six Sigma, Quality Control

Why Professionals Choose Simple Sheets

It's simple. Access to the largest library of premium Excel Templates, plus world-class training.

100+ Professional Excel Templates

100+ Professional Excel Templates

Optimized for use with Excel. Solve Excel problems in minutes, not hours.

Buy Now
World-Class Excel University

World-Class Excel University

With our university, you'll learn how we make templates & how to make your own.

Explore Catalog
How-To Videos

How-To Videos

Each template comes with a guide to use it along with how-to videos that show how it works.

Buy Now

Inside Our Check Sheet Excel and Google Sheets Template

The Check Sheet Excel and Google Sheets template makes it easy to record production issues and automatically updates defects bar and pareto charts.

If you work in operations, you’re likely familiar with a Check Sheet. Our Check Sheet Excel Template helps you collect and analyze data in a structured way.

Often used for quality control, our template is built with a Pareto Analysis Graph and Defects Bar Chart that auto populate based on your inputs. A Check Sheet is one of the Seven Basic Tools of Quality Control, a popular tool used in Six Sigma as well.

If you find this template useful, you’ll also want to check out other statistical analysis templates like Pareto Analysis, Stratification Data Analysis, Scatter Diagram and Fishbone Diagram. Each of these templates is designed to help you analyze data faster and with more accuracy. 

The formulas are baked into the template and automate the manual calculations you’d normally do to run those analyses.

Let’s dive into how to use the Check Sheet, also referred to as a Tally Sheet when using it for quantitative analysis.

Begin by labeling the Product Weekly Check Sheet Report fields such as Product Name, Data Recorder Name, Location, and the Data Collection Date.

In the Defect Type column, record the defects category related to the product. Once that is setup, you can then record defect results for each defect type on a daily basis.

The Pareto Chart and Bar Chart will auto populate according to your data set.

These visuals make it simple to identify where the highest percentage of defects are happening. 

Check Sheets is considered one of the seven basic tools of quality control. This Excel template automates your quality control efforts.

This data can be incredibly useful because once you identify where the defects are happening, you can seek out ways to prevent them.

This is a repeatable process that has massive potential benefits for your organization, so we made it easy to be a tool you can use all the time using VBA.

Click the Clear Data button once you’ve saved it. Click the Print Copy button to have a tangible copy you can share with your boss or colleagues. Click Full Screen if you are using it during a presentation and want to maximize its visual impact.

If that wasn't enough reason to get this template, did you know this template is compatible with Google Sheets? Collaborate with your co-workers in real time and enjoy the cloud auto-save feature of Sheets when you use this template!

More Operations Templates For You

Simple Pricing for Full Access

Unlock full access to the entire library for one low price.



(no bundle savings)

  • 45+ Customizable Excel Templates
  • One User
  • One-Time Payment

Premium + University


($699 bundle savings)

  • Full Access to Excel University ($399 bundle savings)
  • 100+ Customizable Excel Template
  • Personal Membership Portal
  • Excel, PowerPoint, & Word 101 Courses ($199 bundle savings)
  • Two Users
  • One-Time Payment



($299 bundle savings)

  • 100+ Customizable Excel Templates
  • Excel, PowerPoint & Word 101 Courses ($199 bundle savings)
  • One User
  • One-Time Payment