Microsoft Excel Checklist Template: Build or Download

How-to basics · Updated November 20, 2026

A Microsoft Excel checklist template is a workbook for listing tasks, marking their status, and tracking details such as owners and due dates. In Excel for Microsoft 365 on Windows, look for one under File > New by searching for checklist, or build a flexible version with Task, Owner, Due date, Status, and Notes columns.

What an Excel checklist template can do

A checklist is more than a set of boxes to tick. A well-structured workbook can show who is responsible for each item, when it is due, what remains unfinished, and whether a process is ready to move forward. It can suit a one-time packing list, a recurring equipment inspection, or a project with tasks shared among several people.

Unlike a printed list, an Excel checklist can be sorted and filtered. For example, a project coordinator can filter a task table to show only items assigned to one person or only items marked In progress. A basic template works best when it captures the information the checklist actually needs, rather than adding columns that make a short list harder to use.

Find a ready-made checklist template

In Excel for Microsoft 365 on Windows, select File > New and search the available templates for checklist. Select a result to preview it, then choose Create if it meets your needs. The exact selection of templates can change, and online templates may require an internet connection; if a checklist does not appear, creating a simple workbook yourself is a reliable alternative.

Before using a downloaded or built-in template, check its layout and remove sample tasks that do not apply. Look for useful fields such as task, deadline, completion status, and notes. Also check for formulas or formatting that may assume a particular number of rows. A template is a starting point, not a guarantee that every column or calculation suits your workflow.

Build a basic checklist from scratch

A compact checklist can be set up in a few steps. In a blank workbook, add headers in row 1 and enter one task per row beneath them. For example, use columns A through E for Task, Owner, Due date, Status, and Notes. Keep each task in its own row; this makes sorting, filtering, and counting much easier than putting several tasks into one cell.

  1. Enter the headings in A1:E1 and add tasks starting in row 2.
  2. Select the header and task area, then press Ctrl+T on Windows to format it as an Excel table. Confirm that the table has headers. On a Mac, Cmd+T opens the Create Table dialog.
  3. Use the Status column consistently, for example Not started, In progress, Done, or Blocked.
  4. Save the workbook with a clear name, such as Office Move Checklist, and keep an untouched copy if you intend to reuse it as a template.

Excel tables are useful because their filter controls appear in the header row and the table can expand when you add rows. If the Create Table dialog selects the wrong range, correct it before confirming. For a short personal list, a table is optional, but it becomes helpful as soon as you need to filter, sort, or extend the checklist.

Choose columns that match the job

Start with the smallest set of fields that will help someone complete or review the work. A household shopping list may need only Item, Quantity, and Done. A project checklist may need Task, Owner, Due date, Status, and Notes. An inspection log might also include Location, Result, and Inspection date. The right template depends on what the reader needs to decide from the list.

  • Task: Use a specific action, such as “Confirm delivery window,” rather than a broad label such as “Delivery.”
  • Owner: Include this when work is shared. A blank owner can then signal that a task still needs assignment.
  • Due date: Enter actual Excel dates so the column can be sorted chronologically. Avoid typing dates into a general notes field.
  • Status: Agree on a small set of labels. Too many near-synonyms make filtering and reporting less dependable.
  • Notes: Keep supporting detail here, but put any information that needs its own sorting or reporting into a separate column.

Use dropdowns or checkboxes for completion

A status dropdown is a practical option when a task can be unfinished, underway, blocked, or complete. Select the cells in the Status column, then choose Data > Data Validation. In the Data Validation dialog, set Allow to List and enter the permitted status values in Source, separated by commas—for example, Not started,In progress,Done,Blocked. Use the same spelling and spacing throughout so filters and formulas recognize the labels consistently.

Microsoft 365 versions that include Excel’s in-cell checkboxes also let you select cells and choose Insert > Checkbox. Checkbox cells store TRUE when checked and FALSE when unchecked. This is suitable for a simple complete-or-not-complete list, but it cannot show intermediate states such as Blocked. If Insert > Checkbox is not available in your Excel installation, use a status dropdown or a Done column instead. Checkbox availability can depend on the Microsoft 365 update channel and rollout.

Track progress with a formula

A progress percentage can summarize a small checklist, but it is only meaningful if the task rows are filled in consistently. With task names in A2:A6 and statuses in D2:D6, enter this formula in a progress cell:

=IFERROR(COUNTIF(D2:D6,"Done")/COUNTA(A2:A6),0)

If three of the five task names are present and exactly three corresponding statuses say Done, the result is 3 divided by 5, or 60%. Format the result cell as a percentage using Home > Number, or select the Percentage Style button on the Home tab. IFERROR returns 0 when there are no task names to count, instead of showing a division error. Adjust both ranges when your checklist uses a different number of rows; if the list grows regularly, a table-based design can be easier to maintain.

This calculation treats every task as equally important and counts any row with a task name in column A. It does not measure effort, quality, or whether a task is overdue. A checklist with three small tasks and one major task might show a high completion percentage while substantial work remains, so keep the underlying task list visible.

Make the checklist easier to read

Use clear headers, sensible column widths, and a readable font before adding decorative formatting. Select the table and choose a simple style from Table Design if you want alternating row colors. To highlight statuses, select the relevant status cells and choose Home > Conditional Formatting > Highlight Cells Rules > Text that Contains; enter a status such as Done and choose a format. Apply separate rules only when the colors genuinely help readers identify important states.

Freeze the header row if the checklist is long: select the row below the heading, then choose View > Freeze Panes > Freeze Panes. For a table with only a few tasks this may be unnecessary. If dates are important, make sure the column displays them clearly and sort by date using the table’s header filter rather than manually rearranging individual cells.

Print, share, and reuse the workbook

For a paper checklist, check the print preview before printing. Choose Page Layout > Orientation to switch between portrait and landscape, and use Page Layout > Print Area > Set Print Area if you want to print only the checklist. If the sheet spills across pages, adjust scaling carefully: shrinking a very wide sheet to one page can make the text difficult to read. Repeating header rows on multiple printed pages can also help, using Print Titles under the Page Layout tab.

For a reusable blank version, save a clean copy before entering live tasks. To share editing with others, store the workbook in OneDrive or SharePoint and use Excel’s sharing controls; available collaboration options depend on the account and storage location. Agree on the meaning of each status and avoid having collaborators create slightly different labels. If people only need to read or print the list, share a view-only copy or export a PDF rather than granting editing access.

Common checklist problems and fixes

Inconsistent entries are a frequent source of confusing results. “Done,” “Complete,” and “Finished” may all seem clear to a person, but a COUNTIF formula looking for Done will not count the other labels. A dropdown helps prevent variations. Likewise, blank task rows should remain blank: typing spaces or placeholder text into the Task column can cause a progress formula to treat an apparently empty row as a task.

  • Filters do not include new tasks: Add rows directly below the Excel table so it can expand, or check that the new row is inside the table range.
  • Dates sort incorrectly: Some entries may be text rather than real dates. Re-enter them as dates and check the cell’s number format.
  • Colors do not update: Review the conditional formatting rule’s selected range and make sure its text matches the status exactly.
  • Progress seems wrong: Check the task and status ranges, remove stray entries, and confirm that completed items use the same Done label.

When Excel is the right tool—and when it is not

Excel is a good fit when a checklist needs custom columns, sorting, filtering, calculations, or a printable layout. It is also convenient if the people using it already work with spreadsheets. For a very short list, a notes app or a printed page may be quicker. For assigned work with notifications, dependencies, and ongoing team updates, a task-management service may be more suitable than a spreadsheet. Those tools may offer workflow features that an Excel checklist does not provide automatically.

A Word document can be easier to format as a fixed-page handout, but it is less convenient for filtering a large task list or summarizing statuses. Excel’s advantage is structured data; its limitation is that people must maintain the sheet carefully. Choose based on how the checklist will be used, not simply on which format looks more polished.

Frequently Asked Questions

Does Excel have a checklist template?
Excel’s File > New template gallery may include checklist-related templates. Search for checklist and review the available options. If none fits, a table with task, status, owner, and due date columns is easy to create yourself.

How do I insert a checkbox in Excel?
In Microsoft 365 versions with the feature, select the target cells and choose Insert > Checkbox. If that command is missing, use a Data Validation list for completion status or enter a Done/Not done value manually.

Can I make a checklist that counts completed tasks?
Yes. Use a consistent status label such as Done and a COUNTIF formula to count it. A percentage can divide that count by the number of nonblank task names, as in the example above.

How do I print an Excel checklist on one page?
Check File > Print preview, adjust orientation or margins, and use scaling if needed. If the text becomes too small, print across more than one page or reduce unnecessary columns rather than forcing the entire sheet onto one page.

Can several people use the same Excel checklist?
Yes, when the workbook is stored in a supported OneDrive or SharePoint location and shared with appropriate permissions. Use consistent status labels and make clear who can edit the workbook to avoid conflicting changes.

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.