Free Checklist Excel Template: How to Find and Use One

How-to basics · Updated November 22, 2026

Yes—free checklist Excel templates are available from Microsoft’s template gallery and other download sources, and you can also build a reusable checklist in a blank workbook. Choose a template that fits the task, check that its source is trustworthy, then adapt its columns, status options, and checkboxes to the way you work.

What a checklist Excel template does

A checklist template is a prearranged spreadsheet for recording tasks and whether each one is complete. A basic version might have columns for the task, owner, due date, and status; a packing list might instead track the item, quantity, and whether it has been packed. The spreadsheet format makes it easy to sort, filter, print, and revise a list as the work changes.

“Free” can mean different things. A file may be free to download but require a Microsoft account, or it may be offered by a third-party site with its own terms. A template also does not necessarily include every feature shown in a preview. Check the file type, licensing or use conditions, and any account requirements before downloading.

For a small personal list, a simple table is often enough. A team or recurring process may need additional fields such as priority, person responsible, and last-updated date. More columns are not automatically better: each one should help someone take action or understand progress.

Where to find a free template

Start with Microsoft’s own template options. In Excel for Microsoft 365 on Windows, open File > New and search the available templates for terms such as “checklist,” “task list,” or the task itself. You can also browse Microsoft Create online. The selection can vary by region, account, and time, so a particular checklist may not always appear. Review the template details and any sign-in prompt before using it.

Other office-software publishers and productivity websites also offer downloadable spreadsheet templates. Before opening one, consider the source and the file format. An ordinary Excel workbook generally uses the .xlsx extension. A file ending in .xlsm can contain macros, which are programs embedded in a workbook and are usually unnecessary for a basic checklist.

  • Prefer a clearly identified publisher and a direct download page over a page crowded with misleading download buttons.
  • Check whether the template is for Excel, another spreadsheet application, or a PDF intended for printing.
  • Read the stated usage terms if you plan to use or distribute the file at work.
  • Do not enable macros merely to mark tasks complete. Ask the source why they are needed if a checklist unexpectedly requires them.

How to choose a template that fits

Before downloading, think about who will use the checklist and what decision the spreadsheet should support. A home-maintenance list may need a location and date last completed. A project handoff may need an owner, deadline, and notes. A daily routine may need one column for each day of the week. A useful template makes the next action obvious without forcing users to fill in irrelevant details.

  • Task size: Decide whether each row represents a small action or a broader milestone. “Check smoke alarm” is a clear task; “Safety” is too broad to verify.
  • Responsibility: Add an owner field if more than one person is involved. Without it, an overdue item can be visible but nobody may know who should act.
  • Timing: Include a due date only when timing matters. For repeating work, a date completed or next review date may be more helpful.
  • Status: Use a checkbox for a simple done/not-done decision, or a short status list if work can be blocked or in progress.
  • Reading and printing: Check that labels are legible and that the layout will fit the screen or printed page your users need.

A template should be easy to maintain as well as attractive. A colorful dashboard may look polished, but a plain list is often more reliable if several people need to edit it or if it must print cleanly.

Build a basic checklist in Excel

If no ready-made file suits your needs, start with a blank workbook in Excel for Microsoft 365 on Windows. Put a short title at the top, then create column headings in row 1. For example, enter Task, Owner, Due date, and Status in cells A1 through D1. Put one task on each subsequent row and keep the task description specific enough that a person can tell when it is finished.

  1. Enter the headings and task details, leaving a row for each separate action.
  2. Select the range containing the headings and task rows, then choose Home > Format as Table and pick a style. Confirm that the table has headers. A table makes it easier to filter and keeps formatting consistent when rows are added.
  3. Set date cells to a date format using the number-format controls on the Home tab. Use consistent wording for statuses so that filtering works as expected.
  4. Save the workbook with File > Save As. Choose a descriptive filename and a location you can find again.

To create a simple status menu, select the cells where statuses will go, then choose Data > Data Validation. In the settings, choose List as the allowed value and enter a comma-separated source such as Not started,In progress,Done. The drop-down helps prevent accidental variations like “Complete,” “completed,” and “done” from being treated as different labels. Menu options can vary slightly across Excel platforms and updates; Excel for the web and Mac may arrange some controls differently, but the Data Validation feature is also available in supported versions there.

Checkboxes or status drop-downs?

A checkbox works well when the only useful distinction is whether a task is complete. In current Microsoft 365 versions that include Excel’s in-cell checkbox feature, select the cells for the checklist and choose Insert > Checkbox. The cells display checkboxes, and their underlying values are TRUE when checked and FALSE when unchecked. This makes the feature useful for a straightforward completion list, though the command may not be available in every Excel version or update channel.

If you do not see Insert > Checkbox, use a status drop-down or a dedicated Done column instead. A drop-down is usually clearer when a task can be “In progress,” “Waiting,” or “Not applicable,” not just done or not done. It also avoids confusing an unchecked box with a task that has not yet been reviewed.

For collaborators, agree on what each state means. For example, “Done” could mean the work is complete, while “Reviewed” could mean another person has checked it. If review matters, use separate fields rather than treating completion and approval as the same event.

Track completion without making the sheet complicated

You can add a completion percentage using a formula, but the result is only as meaningful as the status data. Suppose task descriptions are in A2:A11 and their status values are in C2:C11, with “Done” entered for completed tasks. If eight of the ten tasks are marked Done and every task description is filled in, enter this formula in another cell:

=COUNTIF(C2:C11,"Done")/COUNTA(A2:A11)

The result is 0.8, or 80% when displayed as a percentage. Select the result cell and use Home > Number > Percent Style to show it as a percentage. This calculation counts rows with a task description as the total and rows with the exact status “Done” as complete. If your status wording differs, change the text in the formula to match it. For a short checklist, a manually maintained status column may be more useful than a dashboard.

Filtering is another practical way to see what needs attention. Use the filter arrows in the table headings to display only one owner, due date range, or status. Avoid sorting just one column by itself: select and sort the table so that task details remain on the correct rows.

Adapt the checklist to real tasks

For a weekly office opening checklist, rows might include “Test the meeting-room display,” “Restock printer paper,” and “Confirm the visitor area is ready.” Columns could show the owner, due date, and status. For a trip-packing list, useful fields might be item, quantity, packed, and notes. These examples illustrate why a general template should be edited rather than accepted unchanged: the right columns depend on the task.

For recurring work, decide how you will reset or archive the list. You might keep one worksheet per week, copy a clean checklist for each cycle, or record a completion date for each repeated task. Reusing one sheet without a reset rule can make old checkmarks look like current progress. If several people will work in the same file, document the reset routine and who is responsible for it.

Use conditional formatting sparingly to draw attention to important values. For example, Excel’s Home > Conditional Formatting > Highlight Cells Rules > Text that Contains can highlight a status such as “Waiting.” A color should reinforce written status text, not replace it; color alone may be difficult to interpret for some readers or when printed in black and white.

Common problems and safe sharing

A frequent issue is that a checklist looks complete but does not support useful filtering. This happens when people type slightly different status terms, enter several tasks in one row, or merge cells across the data area. Keep one task per row, use consistent status choices, and avoid merged cells inside the table. If a template has formulas or a summary panel, check that those elements still refer to the right cells after you add or remove columns.

Before sharing a checklist, remove information that recipients do not need. A task sheet might reveal customer names, staff schedules, or internal deadlines. Share it only with the intended people and use the access controls available in the storage service where the workbook is saved. If the workbook is stored in OneDrive or SharePoint, access and simultaneous editing depend on the sharing permissions and file setup.

Keep a clean copy before making major changes, especially if a downloaded workbook contains unfamiliar features. On Windows, Excel’s Protected View may open some files from the internet with editing restricted; do not enable editing or content automatically without considering whether you trust the source. A simple checklist should not need macros or an external program to function.

Frequently Asked Questions

Is there a free checklist template in Excel?
Excel’s File > New page and Microsoft Create are places to look for templates. Availability varies, and you can also make a simple checklist in a blank workbook at no cost if you already have access to Excel.

How do I add checkboxes in Excel?
In a Microsoft 365 version that supports in-cell checkboxes, select the target cells and choose Insert > Checkbox. If that command is absent, use a Data Validation list or a Done column instead.

Can I use a checklist template in Excel for the web?
Many ordinary workbooks can be opened and edited in Excel for the web, but some features or controls may differ from the Windows desktop app. Check the specific workbook in the web version before relying on a feature such as a newer checkbox control.

What is the difference between a checklist and a to-do list?
The terms overlap. A checklist emphasizes confirming each required item, while a to-do list often emphasizes assigning and scheduling work. Adding owner, due-date, or priority columns can make a checklist behave more like a task tracker.

Why is my completion percentage wrong?
Check that task descriptions are filled in consistently and that the status text exactly matches the formula’s criterion. Also confirm that the formula ranges include all intended rows and exclude headings or unrelated notes.

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.