Yes—Excel has ready-made to-do list templates, and you can also build a simple task tracker in a blank workbook. In Excel for Microsoft 365 on Windows, start at File > New and search for “to do list”; choose a template that fits your work, or create columns for tasks, due dates, priority, and status.
What an Excel to-do list template does
An Excel to-do list template is a preformatted workbook or worksheet for recording tasks and tracking their progress. Depending on the design, it may include columns for due dates, owners, categories, priority, notes, or completion status. Some templates also use filters, colors, formulas, or charts to make the task list easier to review.
A template is a starting point, not a task-management system by itself. Excel can sort and filter a list, calculate simple summaries, and make a printable plan. It does not automatically know whether a task is truly complete, remind you reliably outside the workbook, or coordinate every change with a team unless you add suitable tools and routines.
Templates are useful for personal errands, weekly planning, study schedules, event checklists, and small projects. For a list that needs only a few tasks, a simple worksheet is often easier to maintain than a complex dashboard. For work involving dependencies, approvals, or frequent updates from many people, a dedicated project-management app may be a better fit.
Common template layouts and when to use them
Choose a layout based on how you will review the tasks, not just how attractive the preview looks. These are common patterns:
- Basic checklist: One task per row, with a completion field. It suits groceries, household jobs, and short personal lists.
- Daily or weekly planner: Tasks are grouped by date or day. This works when deciding what to do soon matters more than tracking a project over months.
- Project tracker: Adds fields such as owner, priority, due date, and notes. It helps a small group see who is responsible and what needs attention.
- Kanban-style board: Organizes work into stages such as Not started, In progress, and Done. In Excel, this may be represented by columns or filtered lists rather than movable cards.
- Recurring-task list: Includes a frequency or next-due field for chores and routine checks. A spreadsheet can record recurrence, but someone still needs to update the next date.
A useful template keeps the important information visible without making every task difficult to enter. For example, a household list may need only Task, Due date, and Status. A volunteer event plan might also need Owner, Category, and Notes. Avoid adding fields just because a template offers them: unused columns make the sheet harder to scan.
How to find and evaluate a template
In Excel for Microsoft 365 on Windows, select File > New and search for a phrase such as “to do list,” “weekly planner,” or “project tracker.” Available choices can vary with the Excel release, account, and connected template catalog. You can also look for templates through Microsoft’s template pages, then open or download a suitable workbook. If a search produces no useful result, a blank workbook is a dependable alternative.
Before you adopt a template, open it and check how it behaves. A polished preview does not guarantee that its fields or formulas match your needs. Look for the following:
- Can you add rows without breaking the layout or calculations?
- Are the headings clear, and can you remove fields you do not need?
- Does the status field use understandable values, such as Not started, In progress, and Done?
- Can you filter by due date, owner, or status?
- Are formulas and charts understandable enough for you to maintain?
- Does the workbook contain sample information that should be removed before use?
Save a copy with a meaningful filename before changing a downloaded template. That gives you a clean original if you later decide the design is not suitable. If the workbook comes from outside your organization, inspect its contents and only enable macros or other active features when you have a trusted reason to do so.
Build a straightforward tracker in a blank workbook
A blank sheet can be more practical than adapting a large template. Start with one row of headings, for example: Task, Due date, Priority, Status, and Notes. Put each task on its own row and keep each kind of information in its own column. Avoid merged cells within the list because they can interfere with sorting and filtering.
- Enter the headings in row 1 and add several example tasks underneath.
- Select the list and choose Insert > Table. Confirm that the table has headers. A table makes filtering and adding rows more convenient.
- Format the Due date column as a date and use a consistent date convention. For example, choose a date format that clearly distinguishes the day and month for everyone who will read the file.
- For a consistent Status field, select the cells where statuses will go and choose Data > Data Validation. Set Allow to List and enter values such as Not started, In progress, Done in the Source box. The list lets users choose a standard status rather than typing several variations.
- Use the table filter arrows to show only overdue, unfinished, or assigned tasks when needed. Keep the full list intact; filtering hides rows temporarily rather than deleting them.
For a small list, these steps may be enough. If you are adapting a downloaded workbook, first check whether it already contains a table or validation rules, so you do not accidentally create duplicate controls. On Mac, Excel also provides tables and data validation, although ribbon placement and wording can differ slightly by release. Excel for the web offers many common editing features, but a workbook with advanced formatting or features may be easier to adjust in the desktop app.
Use visual cues without making the sheet noisy
Color can make a task list easier to scan when it communicates a clear rule. For instance, you might highlight overdue tasks, mark completed items in a muted style, and use a small set of priority labels. Do not rely on color alone: keep the status text so the meaning remains clear when printed in grayscale or viewed by someone who cannot distinguish the colors.
To highlight overdue tasks, select the task rows in your table and choose Home > Conditional Formatting > New Rule, then choose the option to use a formula to determine which cells to format. With due dates in column B, status in column D, and the first task on row 2, use this rule:
=AND($D2<>"Done",$B2<>"",$B2<TODAY())
The formula assumes Due date is in B2:B100 and Status is in D2:D100, with row 2 as the first task row. Apply the rule to the task rows, such as A2:E100. It highlights a row only when its date is before today, its date cell is not blank, and its status is not Done. The dollar signs keep the date and status columns fixed as the rule is applied across each row.
Conditional formatting is optional. A crowded palette, too many icons, or multiple competing highlight rules can obscure the actual tasks. Choose a few visual signals and test them with ordinary, overdue, and completed entries before relying on them.
Simple formulas for tracking progress
Formulas can summarize a list, but they depend on consistent entries. If status values vary between “Complete,” “Done,” and “Finished,” a count for Done will not include the other labels. A dropdown list helps prevent that mismatch.
With task names in A2:A20 and statuses in D2:D20, this formula counts rows marked Done:
=COUNTIF(D2:D20,"Done")
If three of the entries in D2:D20 say Done, the result is 3. The formula counts matching status cells; it does not judge whether the work is actually complete.
With task names in A2:A20 and statuses in D2:D20, this formula calculates the share of listed tasks marked Done:
=IFERROR(COUNTIF(D2:D20,"Done")/COUNTA(A2:A20),0)
If there are ten nonblank task names and three Done statuses, the result is 0.3, or 30% when the formula cell is formatted as a percentage. IFERROR returns 0 when the task-name range is empty, avoiding a divide-by-zero error. This is a simple count-based measure: it treats a small task and a large task equally.
For a short checklist, a progress percentage may add little value. If the list changes frequently, check that formula ranges include new rows. Converting the range to an Excel table can make the list easier to extend, but formulas copied into a workbook should still be checked against the actual columns and rows.
Common problems and ways to avoid them
Many problems with to-do list workbooks come from unclear rules rather than complicated Excel errors. A due date may be entered as text, a task may be duplicated, or different people may use different meanings for the same status. Agree on a small set of labels and decide whether dates refer to deadlines, planned workdays, or reminders.
- Sorting only one column: Select a cell in the table and use its filter or sort controls so the task details stay together. Sorting just the date column can detach dates from the tasks they belong to.
- Blank rows inside the list: Keep the task table continuous. Blank rows can make selection, sorting, and summary ranges less predictable.
- Overloaded task descriptions: Break large pieces of work into actionable steps. “Plan conference” is harder to mark complete than “Choose venue” or “Send registration link.”
- Unclear ownership: For shared work, include an owner or initials field. A task without a responsible person can remain open because everyone assumes someone else has it.
- Treating a spreadsheet as an alert system: A due-date column does not, by itself, guarantee a notification. Build a separate reminder routine if missing a deadline matters.
For collaboration, save the workbook in a shared location supported by your organization, such as OneDrive or SharePoint, and confirm that collaborators have appropriate access. Co-authoring and available features depend on the file location, account, and application version. Avoid keeping competing copies in email attachments; users can otherwise update different versions without realizing it.
Excel templates compared with other options
Excel is a good choice when you want a flexible grid, custom columns, simple calculations, and a familiar file that can be printed or shared. It is also useful when a task list is part of a larger workbook, such as an event budget or a project schedule. You can shape the list without learning a new system, though someone must maintain the workbook’s structure.
A paper checklist can be better for a short, immediate list that does not need sorting, sharing, or long-term records. A notes app may suit personal tasks that need quick capture across a phone and computer. Dedicated task-management software is often more appropriate when tasks need reminders, recurring schedules, dependencies, comments, or a team-wide workflow. Those tools vary in features and cost, so compare what they actually provide before moving work.
There is no need to choose one tool for every task. Someone might use Excel to plan a project’s full set of deliverables and a calendar or task app for personal reminders. The important point is to avoid maintaining two supposedly authoritative lists that disagree. Decide which location is the source of truth and make the other a view or temporary aid.
Frequently Asked Questions
Does Excel have a built-in to-do list template?
Excel may offer task-list and planner templates through File > New, where you can search for “to do list.” The catalog and available templates can vary. If none fits, create a table with task, due date, and status columns.
How do I make a to-do list in Excel with checkboxes?
Checkbox availability depends on the Excel version and update channel. If your version includes cell checkboxes, look for the Checkbox command on the Insert tab. Otherwise, use a Status dropdown with values such as Not started and Done; it is a clear alternative and works well for filtering and counting.
Can Excel automatically highlight overdue tasks?
Yes. Apply a conditional formatting rule to the task rows using a formula that checks whether the due date is earlier than today and the status is not Done. Ensure blank due-date cells are excluded if they should not be highlighted.
Can I share an Excel to-do list with other people?
Yes, you can share a workbook from a supported OneDrive or SharePoint location, subject to your account and organization settings. Give collaborators the necessary permissions, agree on how statuses and owners are used, and avoid editing separate emailed copies.
Is Excel or a task app better for reminders?
Excel is suited to maintaining and reviewing a flexible task table, but a due date in a cell is not automatically a dependable reminder. If notifications, recurring tasks, or mobile alerts are central to your workflow, compare a calendar or task-management app with the spreadsheet approach.
Related
- Excel Shortcut to Select All Rows in a Column at Once
- Excel Shortcut to Change Lowercase to Uppercase Text
- Excel Redo Shortcut: Repeat Your Last Action on Windows
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Mail Merge Toolkit in Word: How to Install and Enable ItTo add Mail Merge Toolkit to Word, download its Windows installer from the software publisher, close your Office…
- Google Sheets Date Dropdown: Add a Calendar PickerYes. In Google Sheets in a web browser, select the cell, choose Data > Data validation, add a…
- Employee Schedule Template for Google Sheets: SetupAn employee schedule template in Google Sheets is a reusable spreadsheet for assigning shifts, tracking hours, and sharing…
- Check Track Changes in Word: Review Edits with ConfidenceTo check Track Changes in Word, open the Review tab, set Display for Review to All Markup, and…
- How to Set Out of Office in Outlook on Your DevicesTo set an out-of-office message in Outlook, open Automatic Replies, switch them on, write your message, and—if you…
- Excel RANK vs RANK.EQ: Differences, Ties, and ExamplesRANK and RANK.EQ return the same result in current Excel: each gives a number’s position in a list,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.