Excel Spreadsheet Checklist Template: How to Build One

How-to basics · Updated November 22, 2026

Yes, you can build a functional checklist template in Excel in about five minutes using checkboxes, conditional formatting, and a simple COUNTA/COUNTIF formula. Start with a blank sheet, list your tasks in column A, insert checkboxes in column B (Developer tab > Insert > Checkbox), and use a formula to show progress. Below is the full process, along with tips for making the template reusable, avoiding common pitfalls, and deciding whether a pre-made template is worth downloading.

Why Use Excel for a Checklist Instead of a Dedicated App

Excel is not the only tool for checklists, but it has advantages: it is already on most office computers, it handles numbers and dates alongside tasks, and you can customize it without learning a new app. A spreadsheet checklist also integrates with other data—if you track inventory, expenses, or project milestones, the checklist can live in the same workbook. The downside is that Excel lacks push notifications and real-time collaboration is clunkier than in dedicated apps like Trello or Asana. For personal or small-team use, Excel is often sufficient.

How to Build a Basic Checklist Template from Scratch

Here is the step-by-step for Microsoft Excel for Microsoft 365 on Windows. On Mac, the Developer tab is enabled via Excel > Preferences > Ribbon & Toolbar, and the checkbox control is in the same Insert menu.

  1. Open a blank workbook. In cell A1, type Task; in B1, type Done.
  2. Enable the Developer tab if it is not visible: File > Options > Customize Ribbon, then check Developer in the right pane.
  3. In the Developer tab, click Insert and choose the Checkbox control (Form Control). Click on cell B2 to place it.
  4. Resize the checkbox to fit the cell. Right-click it, select Format Control, and under the Control tab, set the Cell link to $B$2. This links the checkbox to the cell, making it return TRUE when checked and FALSE when unchecked.
  5. Copy the checkbox down for as many tasks as you need (e.g., B2:B20). Each checkbox will automatically link to its own row if you copy it correctly.
  6. In cell D1, type Progress. In D2, use the formula =COUNTA(A2:A20)-COUNTIF(B2:B20,FALSE) to count tasks that are checked. (This assumes tasks are in A2:A20 and checkboxes are linked to B2:B20.) For a percentage, use =COUNTIF(B2:B20,TRUE)/COUNTA(A2:A20) and format as a percentage.

If you prefer a simpler approach without the Developer tab, you can use data validation: select B2:B20, go to Data > Data Validation, choose List, and enter TRUE,FALSE as the source. Then users type TRUE or FALSE (or use a dropdown), and the same COUNTIF formulas work.

Adding Conditional Formatting to Highlight Completed Tasks

Conditional formatting makes the checklist visually useful. To grey out completed tasks: select A2:B20, go to Home > Conditional Formatting > New Rule > Use a formula. Enter =$B2=TRUE and set the format to a light grey font and strikethrough. This works on Windows and Mac; on Excel for the web, the same rule applies but the checkbox control is not available, so you would use the data validation dropdown instead.

You can also highlight overdue tasks if you have a Due Date column. For example, with due dates in C2:C20, add a rule with =AND($C2 and format it red. This is a common use case for project checklists.

How to Make the Template Reusable

To avoid rebuilding the checklist each time, save it as an Excel template file (.xltx). Go to File > Save As, choose the file type Excel Template, and save it to your default template folder. Then when you create a new workbook, you can select it from the Personal templates section. Alternatively, keep a master checklist and use File > Save As to create a new copy for each project. If you share the template with others, protect the formula cells: select the cells with formulas, go to Review > Protect Sheet, and uncheck the option to allow users to select locked cells (or just lock the formula cells). This prevents accidental overwrites.

Common Problems and How to Fix Them

  • Checkboxes not linked to the right cell: If you copy a checkbox and the link stays the same, right-click each checkbox and adjust the Cell link manually.
  • COUNTIF not updating when you check a box: Make sure the checkbox is linked to the cell in the same row. If you used data validation, the cell contains the text TRUE or FALSE, so the formula works.
  • Checkbox moves or resizes when sorting: Sort the list by a helper column, not by the checkbox column. Or use a form control checkbox that is anchored to the cell (right-click > Format Control > Properties > Move and size with cells).
  • Progress formula returns #DIV/0! when no tasks are entered: Wrap the formula in IFERROR: =IFERROR(COUNTIF(B2:B20,TRUE)/COUNTA(A2:A20),0).

Pre-Made Templates vs. Building Your Own

Microsoft offers free checklist templates in the File > New gallery; search for “checklist” to see options like a “Basic checklist” or “Project checklist”. These are fine for simple tasks, but they often use a checkbox symbol (like ☐) instead of interactive controls, so you have to manually mark them. Downloadable templates from third-party sites can be more elaborate but may contain macros or broken links. Building your own gives you full control and avoids security risks. If you need a template with multiple columns (e.g., Task, Assigned To, Due Date, Status), start from a blank sheet and add columns—the same checkbox and formula logic applies.

Costs and Alternatives

Excel is part of Microsoft 365, which costs a subscription fee; if you already have it, there is no extra cost. Free alternatives include Google Sheets (which has a native checkbox feature under Insert > Checkbox) and LibreOffice Calc. For a dedicated checklist app, Trello, Todoist, and Microsoft To Do are free for basic use. The choice depends on whether you need offline access, advanced formulas, or just a simple list. Excel’s advantage is its formula power—you can calculate completion percentages, track time, or link to other data.

Frequently Asked Questions

How do I insert a checkbox in Excel without the Developer tab?
You can use data validation with a dropdown list of TRUE/FALSE, or you can use a symbol like ☐ and manually change it to ☑, but that does not link to a formula. The Developer tab is the only way to get a true interactive checkbox that updates a cell value.

Why is my COUNTIF formula not counting checked boxes?
Most likely the checkbox is not linked to the cell you are referencing. Right-click the checkbox, choose Format Control, and verify the Cell link matches the row. Also ensure the formula uses the correct range and that the linked cells contain TRUE/FALSE (not text).

Can I use a checklist template on Excel for Mac?
Yes, but the Developer tab must be enabled differently: go to Excel > Preferences > Ribbon & Toolbar, then check Developer. The checkbox control works the same way, and the keyboard shortcut for conditional formatting is Cmd+1 on Mac.

How do I make a checklist that automatically sorts completed tasks to the bottom?
Add a helper column with the formula =IF(B2=TRUE,1,0), then sort the data by that column (ascending). Note that sorting will move the checkboxes if they are not set to move with cells; use the Format Control > Properties setting to anchor them.

Is there a way to share a checklist template with others without them needing Excel?
You can save the workbook to OneDrive and share a link, or export it as a PDF for viewing. For editing, they need Excel or Excel for the web (free with a Microsoft account). Google Sheets is a better option if you want real-time collaboration without Excel.

Can I use checkboxes in Excel for the web?
No, Excel for the web does not support form control checkboxes. Use data validation with a dropdown list instead, or use a Google Sheets equivalent if you need interactive checkboxes online.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.