Yes—free Microsoft Excel checklist templates are available from Microsoft Create and through Excel’s template search, although the selection can vary. You can also make a simple checklist yourself in a blank workbook, using Excel checkboxes when available or a status dropdown when they are not.
Where to find a free Excel checklist template
Start with Microsoft Create, which offers downloadable Office templates, or open Excel and search its template gallery for checklist. The gallery may appear under File > New in Excel for Microsoft 365 on Windows. Template names and availability can change, so search results may differ by version, account, region, or whether you are using the desktop app or Excel for the web.
Before downloading from another website, check that the file is genuinely free and that it is an Excel workbook or template, usually an .xlsx or .xltx file. Read the page’s terms: a free download may be offered only for personal use, may require an email signup, or may be paired with paid upgrades. A file that asks you to enable macros just to use a basic checklist deserves extra caution.
After downloading, open the file in Excel and inspect its sheets, formulas, and instructions before entering important information. If you want to keep an untouched original, use File > Save As to create a working copy. For a reusable template, save a completed blank version as an Excel Template (.xltx); for ordinary day-to-day use, save it as an Excel Workbook (.xlsx).
What an Excel checklist template usually includes
A checklist is more than a column of tick boxes. A useful template makes it clear what must be done, who is responsible, when it is due, and how to tell whether the work is finished. A personal packing list may need only an item and a completion field; a recurring workplace inspection may also need dates, owners, notes, and a record of follow-up.
Common columns include:
- Task or item: the action to complete, written specifically enough that two people would interpret it the same way.
- Complete or status: a checkbox or a choice such as Not started, In progress, and Done.
- Owner: the person accountable for the task, if the list is shared.
- Due date: useful when order and timing matter.
- Notes: a brief place for exceptions, links, or details that do not belong in the task name.
For example, a home-move checklist might have Task, Due date, Done, and Notes columns. A project handoff list might add Owner and Status. Keep the first version lean: extra columns can make a small checklist harder to maintain than the work it is tracking.
How to build a simple checklist in Excel
If a ready-made template does not fit, a basic list takes only a few steps. In a blank worksheet, put headings in row 1, such as Task, Done, Owner, and Due date. Enter one task per row, then select the task range and use Home > Format as Table if you want filter arrows and consistent formatting. A table is particularly helpful when the list will grow, because its formatting and filters extend as rows are added.
In recent Microsoft 365 versions of Excel, an in-cell checkbox can be added by selecting the cells and choosing Insert > Checkbox. The feature’s availability can depend on the update channel and version, and it may not appear in older perpetual editions. These checkboxes store a TRUE or FALSE value in their cells, which makes them useful for counting completed items. If you cannot find the command, a dropdown is a practical fallback rather than a reason to abandon the checklist.
To make a dropdown, select the cells in the Status column and choose Data > Data Validation. Set Allow to List and enter a short, consistent set of choices in Source, for example Not started,In progress,Done. Use the same spelling for every row so that filters and counts remain reliable. A dropdown is also easier to read when a user needs to distinguish unfinished work from work that has begun.
For a small list, freeze the heading row with View > Freeze Panes > Freeze Top Row so column labels stay visible while scrolling. If a task name is long, turn on Wrap Text from the Home tab and adjust the column width. These small layout choices often make a template more usable than decorative formatting.
Track completion with a formula
A progress percentage can help summarize a list, but define what counts as a task first. In this example, task names are in A2:A11 and in-cell checkboxes are in B2:B11. Enter this formula in a summary cell:
=IFERROR(COUNTIF(B2:B11,TRUE)/COUNTA(A2:A11),0)
With six checked boxes and ten nonblank task names, the result is 0.6, or 60% when the result cell is formatted as a percentage. The formula divides completed checkboxes by the number of tasks with names; IFERROR returns zero instead of an error if the task range is empty. If rows contain blank task names, the denominator ignores them. If you use a text dropdown instead of checkboxes, this formula needs to be adjusted to count the Done status rather than TRUE.
For a simple completed-task count, with the same checkbox range in B2:B11, use =COUNTIF(B2:B11,TRUE). It returns 6 when six boxes are checked. Put a label such as Completed beside the result so another person understands what the number measures. Avoid reporting a percentage without showing the list’s scope: 60% complete means something different for a ten-item packing list than for a project with a hundred unevenly sized tasks.
How to choose the right template
Choose a template based on the job, not on how elaborate its preview looks. A reusable daily routine list should be quick to reset and easy to scan. A project checklist may need owners and due dates. A compliance or safety checklist may require documented evidence, sign-off, and retention practices that a generic spreadsheet does not provide on its own.
Before adopting a template, check these points:
- Compatibility: confirm it opens in the Excel version and device your users have. Features such as in-cell checkboxes may not be available everywhere.
- Editing: make sure the sheet is not protected in a way that blocks ordinary updates, or learn the intended input cells.
- Clarity: check that status labels, dates, and instructions are understandable without relying on color alone.
- Capacity: see whether the layout can accommodate more rows and whether formulas include the rows you plan to use.
- Sharing: consider whether several people will edit it and whether they can work in the same file without creating conflicting copies.
Try a few representative tasks before making the template your standard. Add a long task name, leave a date blank, mark an item complete, and filter the list. This can reveal clipped text, confusing labels, or a progress formula that stops before the last row.
Excel checklist versus other formats
Excel is a good fit when the checklist needs sorting, filtering, dates, owners, calculations, or a printable summary. It is less convenient when many people need to update the same list at once, when tasks need automatic reminders, or when the record must follow a formal approval process. A spreadsheet can track information, but it does not automatically establish a reliable audit trail or prove that a task was done correctly.
For a very short personal list, a notes app or paper may be faster. For shared assignments and due dates, a task-management tool may offer notifications and clearer ownership. Microsoft To Do or Microsoft Planner may suit some Microsoft 365 users, depending on their account and organizational access. For a form that collects structured responses, Microsoft Forms can be more appropriate than asking people to edit worksheet cells directly.
Excel for the web can be useful for accessing and editing a workbook in a browser, and Microsoft makes web versions of Office apps available with a free Microsoft account, subject to account and service conditions. That does not mean every desktop feature is available in the browser, nor does a free template make the full Excel desktop application free. Check the current Microsoft plan and feature details if desktop access or a particular control is essential.
Costs, sharing, and safe use
A template can cost nothing while the software or services around it have separate conditions. Microsoft’s template downloads may be free, but access to the Excel desktop app depends on the user’s license or subscription. Excel for the web may be an option for basic work, while some advanced features, administration controls, or organizational services depend on the account. Confirm current terms with Microsoft rather than assuming a template download includes an Excel license.
When a checklist contains personal, customer, health, financial, or workplace-sensitive information, store and share it according to the rules that apply to that information. Avoid placing private data in a public link. In a shared workbook, give people only the access they need, and consider keeping a separate copy or version history if you must recover earlier changes. A password or hidden sheet should not be treated as a substitute for proper access controls.
Download templates from sources you trust. Excel files can contain macros or external links; a normal checklist should rarely need either. Do not enable macros merely because a file prompts you to do so. If a workbook contains unfamiliar formulas, links, or buttons, inspect them before relying on the file, especially if it came from an unknown site.
Common problems and practical fixes
The checkbox option is missing. Your Excel build may not include the newer in-cell checkbox feature, or it may not yet be available in your update channel. Update Office if appropriate, or use a Data Validation dropdown. Older Form Controls checkboxes are another option in desktop Excel, but they require more setup and can be awkward to use in shared or browser-based workflows.
The completion percentage seems wrong. Check that every task row has a task name, that the checkbox cells align with those rows, and that no checkbox was copied outside the formula range. If using dropdowns, confirm that the status text is consistent. A Done value with an extra space or different spelling may not be counted by a formula that expects an exact match.
The list prints across multiple pages. Use Page Layout to review paper orientation, margins, and print area, then use Print Preview before printing. Do not shrink the sheet so much that task names become unreadable. A checklist intended for paper may be easier to use if you hide nonessential columns or create a separate print-friendly sheet.
Several users overwrite one another’s edits. Agree on where the current workbook lives and avoid emailing separate copies as if each were authoritative. A cloud-stored workbook may support collaboration, depending on the storage location, account, and file features. If the checklist is high-stakes or needs a detailed change history, a dedicated workflow tool may be safer than a general-purpose spreadsheet.
Frequently Asked Questions
Does Microsoft have a free Excel checklist template?
Microsoft Create and Excel’s template gallery may offer free checklist templates. Availability changes, so search for checklist in the gallery or on Microsoft Create and review the download and usage terms.
How do I make a checklist in Excel without a template?
Enter tasks in one column, add a completion column, and use Insert > Checkbox if the feature is available in your Microsoft 365 build. Otherwise, create a status dropdown with Data > Data Validation.
Can I use an Excel checklist online for free?
Excel for the web is available to many users with a free Microsoft account, subject to Microsoft’s current service terms. Some desktop features may be missing, so check that the controls in your workbook work in the browser.
Can multiple people update the same checklist?
They may be able to coauthor a workbook stored in a supported cloud location, if their accounts and workbook features allow it. Share one current file and set suitable permissions instead of circulating multiple email attachments.
Is an Excel checklist suitable for safety or compliance records?
It can help organize tasks, but a generic spreadsheet may not meet requirements for approvals, audit trails, evidence, or record retention. Check the applicable workplace or organizational rules and use an approved system when required.
Related
- Interpolate in Excel: Does Solver Help?
- Insert Row Shortcut in Excel on a Laptop
- Insert Row Shortcut in Excel and Repeat It Quickly
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Average Keyboard Shortcut and Fastest MethodsExcel does not have a single, dedicated keyboard shortcut that inserts an average formula in every situation. In…
- Google Sheets Meal Prep Planner: Set One Up EasilyYes. Google Sheets can work as a flexible meal prep planner for weekly menus, recipes, serving counts, shopping…
- How to Insert a Citation in Word OnlineTo insert a citation in Word Online, open the document and check the References tab for Insert Citation.…
- Add a Header in Excel on the First Page OnlyTo add a header only to the first printed page in Excel for Microsoft 365 on Windows, open…
- Google Sheets Duplicate Table: Copy Data or a Whole SheetTo duplicate a table in Google Sheets, select its cells, copy them, and paste them into a new…
- Excel Column Letters: How to Find or Convert Them EasilyIn Excel, a column letter is the label at the top of a worksheet column: A is the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.