To Do List Excel Sheet Template: Make a Useful Tracker

How-to basics · Updated November 20, 2026

A useful to-do list Excel sheet template can be made with columns for the task, priority, due date, status, and notes. In Excel for Microsoft 365 on Windows, enter those headings in row 1, select them with several blank rows, choose Home > Format as Table, and then add tasks beneath them.

What a to-do list template should include

A template is a reusable layout, not a particular Excel feature or a fixed design. The best one makes it easy to see what needs doing, when it is due, and whether it is finished. A practical starting layout is:

  • Task: A short, specific action, such as “Send the revised project outline.”
  • Category: A grouping such as Work, Home, School, or Errands.
  • Priority: A small set of choices, such as High, Medium, and Low.
  • Due date: The date the task should be completed, if it has one.
  • Status: Not started, In progress, Waiting, or Done.
  • Notes: A link, next step, or other detail that would be hard to fit in the task name.

Keep the initial design lean. A personal list may need only task, due date, and status; a team tracker may also need an owner and category. Adding fields “just in case” makes a list slower to maintain, and blank or inconsistently filled columns can make filtering less useful.

How to create the sheet in Excel

Start with a blank workbook and put one column heading in each cell of row 1. For example, use A1:G1 for Task, Category, Priority, Due date, Status, Owner, and Notes. Keep one task per row and avoid merged cells: merged headings can interfere with sorting, filtering, and table expansion.

  1. Enter a few sample tasks below the headings so you can check that the columns suit your needs.
  2. Select the headings and the task rows, then choose Home > Format as Table and select a style.
  3. In the dialog, confirm the range and select My table has headers, then select OK.
  4. Replace the sample rows with real tasks. When you type directly below the table, Excel generally expands the table to include the new row.
  5. Save a reusable blank copy with File > Save As. Give it a clear name, such as “Weekly To-Do Template,” so the original stays available for later.

An Excel table is useful because it supplies filter buttons, carries formatting down new rows, and gives the list a defined structure. To sort, use the arrow in a heading—for instance, sort Due date from oldest to newest or filter Status to show only In progress. If you convert a table back to a normal range, its data remains, but table-specific filtering and automatic expansion are lost.

Choose columns for the way you work

The right fields depend on the decisions you need the list to support. For a solo daily list, Owner is redundant; for a shared project, it can prevent uncertainty about who is taking the next step. A due date is also not the same as a planned work date: if you need to schedule when to do a task as well as when it must be complete, use separate columns and explain the distinction to collaborators.

Make task names actionable. “Website” is a topic, not a task; “Check the contact form on the staging site” tells the reader what to do. Break a large project into individual next actions rather than using one row for a multi-week effort. If a task has several independent deliverables, separate rows make it possible to mark progress accurately.

Use consistent labels. If one person enters “Complete,” another enters “Finished,” and a third enters “Done,” a status filter will treat those as different values. Decide on a short vocabulary before sharing the workbook. You can create a drop-down by selecting the cells in the Status column and choosing Data > Data Validation; in the dialog, set Allow to List and enter the permitted values separated by commas, such as Not started,In progress,Waiting,Done. The exact dialog layout can vary slightly by Excel build.

Track due dates and progress with formulas

Formulas are optional. A simple list can be maintained entirely by entering dates and updating status manually. Formulas become helpful when the workbook has enough rows that calculating days remaining or counting finished tasks by eye is inconvenient.

With a due date in D2 and a status in E2, put this in F2 to show the number of days remaining; the formula assumes a blank cell means there is no due date, and completed tasks should not show a countdown: =IF(OR(E2="Done",D2=""),"",D2-TODAY()). For an illustrative check, if today is November 3, 2026, D2 contains November 10, 2026, and E2 is In progress, the result is 7. If E2 is Done or D2 is blank, the result is blank. Because TODAY updates with the current date when Excel recalculates, the result changes over time. Format F as a number, not as a date, and fill the formula down the column.

With status entries in E2:E20, this formula counts the rows marked Done: =COUNTIF(E2:E20,"Done"). If exactly three cells in that range contain Done, the result is 3. The count depends on consistent status text; a value such as Finished is not included. If you use an Excel table, structured references can make formulas easier to read, but ordinary cell references are often simpler for a first template.

Make the list easy to scan

Formatting should help someone find the next action, not decorate every cell. Use a readable font, a distinct but restrained header style, and enough width for task names. If Notes contains long text, wrap text in that column rather than making every column excessively wide. Set Due date cells to a date format so Excel displays dates consistently.

Freeze the heading row if the list is long: choose View > Freeze Panes > Freeze Top Row. Table headings can remain visible while you scroll, and filter arrows let you narrow the rows without deleting anything. For a shared list, filter by Owner or Category to focus on a subset, then clear the filter when you need to see all tasks again.

Conditional formatting can make overdue or high-priority tasks stand out. Select the relevant cells and choose Home > Conditional Formatting, then select a rule suited to the data. For example, a text rule can highlight cells containing “High” in the Priority column. Avoid relying on color alone: retain the word High or the status text so the meaning is clear if the sheet is printed in grayscale or viewed by someone who cannot distinguish the chosen colors.

Common template problems and how to avoid them

  • Dates sort incorrectly: Some entries may be stored as text rather than real Excel dates. Enter dates consistently, and check whether the cells use a date number format. Text dates may not sort chronologically.
  • Filters miss some tasks: A blank row inside the task list can split a normal data range. Keep the table continuous, with one record per row.
  • Completed work disappears: Filtering to active tasks is useful, but it can hide completed rows. Clear filters when reviewing the full history, or move older completed work to a separate archive if the list becomes unwieldy.
  • Priority becomes subjective: Define what High means—for example, a deadline risk or a blocker for someone else—rather than marking every task High.
  • The list turns into a project plan: A to-do list is suited to tracking actions. If you need dependencies, durations, milestones, or a timeline across many people, a dedicated project-planning tool or a more structured workbook may be more appropriate.

Another common misconception is that a color-coded sheet automatically sends reminders. Standard formatting only changes how information appears in the workbook; it does not, by itself, email someone or notify them when a date arrives. A reminder requires a separate process or tool, and the workbook must be opened or otherwise connected to that process.

When Excel is a good fit—and when it is not

Excel works well when you want a flexible, printable list, need to sort or filter tasks, or already use workbooks for related information. It also makes it easy to customize fields and keep a simple record without adopting a new service. A single-user list with a few dozen tasks is often straightforward to maintain in one table.

Collaboration depends on how the file is stored and how people use it. A workbook saved in OneDrive or SharePoint can support co-authoring in Microsoft 365, subject to account, file, and organizational settings. A workbook attached to email can quickly produce conflicting copies, so agree on one shared location if several people update it. Excel for the web supports many common table and editing tasks, but some desktop features and controls may differ; use the desktop app if a particular workbook feature is unavailable in the browser.

For a very small personal checklist, paper or a notes app may be quicker. For recurring reminders, assignments, comments, or notifications, a task-management app may suit the workflow better. The useful comparison is not which tool has the most features, but whether the people responsible will keep the information current and notice changes.

Frequently Asked Questions

Is there a built-in to-do list template in Excel?
Excel may offer templates through its New or template gallery, and the available choices can change. You can also make a reusable sheet by creating a table with task, due date, priority, and status columns, then saving a blank copy as an Excel workbook.

How do I make a to-do list drop-down in Excel?
Select the cells where users will choose a value, open Data > Data Validation, set Allow to List, and provide the permitted labels. A consistent list such as Not started, In progress, Waiting, and Done makes filtering and counting more reliable.

Can Excel highlight overdue tasks automatically?
Yes. Conditional formatting can highlight dates according to a rule, and a formula-based rule can also consider whether the status is Done. Remember that highlighting is visual only; it is not a notification or reminder.

How do I make a to-do list printable?
Set a clear print area if needed, check the page layout and orientation, and use print preview before printing. If the table is wider than the page, adjust scaling carefully so the text does not become too small to read.

Can I use the same template in Excel for Mac?
Yes. Tables, basic formulas, sorting, and filtering are available in Excel for Mac, although some ribbon labels or dialog details can differ from Windows. Follow the equivalent commands in the Mac ribbon, and verify the print layout on the device that will print the sheet.

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.