The fastest way to get a daily checklist template in Excel is to use the built-in Daily Task Planner template (File > New, search “Daily Task Planner”) or create your own with a simple table, checkboxes, and conditional formatting. For a custom version, list your tasks in column A, add checkboxes in column B (Developer tab > Insert > Checkbox), and use a formula to count completed items.
Why Use Excel for a Daily Checklist
Excel is more flexible than a paper list or a notes app because you can add dates, priorities, categories, and automatic progress tracking. Unlike specialized to-do apps, Excel works offline, stores data locally, and lets you customize every column, color, and formula. You can also reuse the same template daily by copying the sheet or using a date formula to auto-fill today’s date. For teams, Excel files can be shared on OneDrive or SharePoint, allowing multiple people to edit simultaneously (though checkboxes work best when each person edits their own copy).
How to Create a Daily Checklist from Scratch
Here is a step-by-step method for Excel 365 on Windows. Mac steps differ slightly (the Developer tab is enabled via Excel > Preferences > Ribbon & Toolbar).
- Set up columns: In row 1, put headers: Task, Category, Due Time, Done, Notes.
- Add checkboxes: Go to Developer > Insert > Checkbox (Form Control). Click in cell D2 to place a checkbox. Right-click it, select Format Control, and set the Cell link to D2. Repeat for each task row. On Mac, the Developer tab must be enabled first.
- Create a progress formula: In a cell below the list, enter
=COUNTIF(D2:D10,TRUE)&" of "&COUNTA(A2:A10)&" tasks done"(assuming tasks are in A2:A10 and checkboxes linked to D2:D10). This returns something like “3 of 5 tasks done”. - Add conditional formatting: Select A2:D10, go to Home > Conditional Formatting > New Rule > Use a formula. Enter
=$D2=TRUEand set a gray font or strikethrough to visually mark completed tasks. - Auto-date: In a cell, enter
=TODAY()to show today’s date. Format it as a date.
If you don’t want to use the Developer tab, you can type “Y” or “1” in the Done column and use a formula like =COUNTIF(D2:D10,"Y") instead. That works in any version.
How to Choose a Template That Fits Your Work
Before downloading a template, think about what you track. A simple daily checklist might have just tasks and a checkbox. A more detailed one could include columns for priority, time estimate, and notes. If you need to track habits, add a column for each day of the week. If you manage a team, you might want an assignee column and a status dropdown (Not Started, In Progress, Done). The built-in Excel template “Daily Task Planner” includes a priority column and a notes section, but it doesn’t have checkboxes by default—you can add them. For a free template, search Microsoft Create (create.microsoft.com) for “daily checklist”; many are editable Excel files.
Common Problems and Fixes
- Checkboxes not working: If clicking a checkbox doesn’t change the linked cell, right-click the checkbox, choose Format Control, and confirm the Cell link is set. Also, ensure the checkbox isn’t in Edit mode (click once to select, then click again to toggle).
- Conditional formatting not applying: Make sure the formula is relative to the first row of your selection (e.g.,
=$D2=TRUEnot=$D$2=TRUE). The dollar sign locks the column, but the row must be relative. - Formula not counting checkboxes: Checkbox linked cells return TRUE/FALSE. If you used a checkbox from the ActiveX controls, the link is different—use Form Controls for simplicity. Also, ensure the linked cell range matches your formula range.
- Template won’t open in older Excel: Some templates use newer functions like FILTER or XLOOKUP. If you’re on Excel 2016 or earlier, avoid these or replace them with older equivalents (INDEX/MATCH, COUNTIF).
Comparing Excel to Other Tools
Excel is not always the best choice. For a solo user who wants reminders and mobile sync, a dedicated app like Todoist or Microsoft To Do is easier. Excel lacks push notifications and has a clunky mobile experience for checkboxes. However, Excel wins when you need to analyze your tasks: you can create pivot tables to see which categories take most time, or chart completion rates over weeks. Google Sheets is a free alternative with similar functionality, but its checkbox feature (Insert > Checkbox) is simpler and works on mobile. If your checklist is simple and you need it on your phone, a notes app is faster. If you need reporting and customization, Excel is stronger.
Costs and Safety Considerations
Excel is not free—it requires a Microsoft 365 subscription (about $6.99/month for personal, as of 2025) or a one-time purchase of Office Home & Student. However, you can use the free Excel for the web at office.com with a Microsoft account, which supports checkboxes and basic formulas. For safety, always save a backup copy of your checklist before adding macros or complex formulas. If you use a macro to automate resetting the checklist daily, remember that macros cannot be undone with Ctrl+Z, so save a copy first. Also, be cautious when downloading templates from third-party sites: they may contain macros or broken links. Stick to Microsoft’s official template gallery or trusted sources.
Frequently Asked Questions
How do I add a checkbox in Excel?
Enable the Developer tab (File > Options > Customize Ribbon, check Developer). Then go to Developer > Insert > Checkbox (Form Control). Click where you want it, then right-click it and choose Format Control to link it to a cell. That cell will show TRUE when checked, FALSE when unchecked.
Can I make the checklist reset automatically each day?
Yes, but it requires a macro. Press Alt+F11 to open the VBA editor, insert a new module, and paste code that clears the checkbox-linked cells. For example, Range("D2:D10").Value = False unchecks all boxes. Save the workbook as a macro-enabled file (.xlsm) and run the macro each morning. Remember to save a copy before running any macro.
Why is my checkbox not linking to the cell?
If you inserted a checkbox and didn’t set the cell link, it won’t affect any cell. Right-click the checkbox, select Format Control, go to the Control tab, and enter the cell reference in the “Cell link” box. Also, ensure the checkbox is not in Design Mode (Developer > Design Mode should be off).
Can I use Excel for a daily checklist on my phone?
Yes, the Excel mobile app can open and edit checkboxes, but it’s not as smooth as on desktop. Alternatively, use Excel for the web on a phone browser. For a better mobile experience, consider using Microsoft To Do, which syncs with Excel via Microsoft 365, or use Google Sheets if you prefer free.
What is the difference between a checklist and a to-do list in Excel?
They are often used interchangeably. A checklist typically implies a fixed set of items you need to verify (e.g., daily tasks), while a to-do list may have priorities and due dates. In Excel, both are just tables; the difference is in how you use them. A checklist might have a simple checkbox, while a to-do list might have columns for priority and due date.
How do I count completed tasks in a checklist?
If your checkboxes are linked to cells D2:D10, use =COUNTIF(D2:D10,TRUE) to count the number of TRUE values. To show a percentage, use =COUNTIF(D2:D10,TRUE)/COUNTA(A2:A10) and format the cell as a percentage.
Related
- Excel Conditional Formatting for Past Dates
- Excel Conditional Formatting Duplicate Rows: Full Guide
- Excel Conditional Formatting Date Occurring: How To
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Split an Excel Row in HalfTo split a row’s contents between two rows in Excel, insert a blank row beneath it, then cut…
- Share an Outlook Calendar So Others Can EditTo let someone edit an Outlook calendar, open Calendar, choose Share Calendar, enter their email address, set the…
- Excel Gridlines: How to Make Them Print on Every PageTo make worksheet gridlines print in Excel for Microsoft 365 on Windows, select the worksheet, open Page Layout,…
- Excel Table Absolute References: How They WorkExcel tables do not use dollar signs to make structured references absolute: a reference such as Orders[Amount] continues…
- How to Remove a Dropdown List from an Excel CellTo remove a dropdown list from a cell in Excel for Microsoft 365 on Windows, select the cell,…
- How to Create Letter Labels in Word: Step-by-Step GuideTo create labels that display letters, open Word and choose Mailings > Labels, select a label product or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.