To Do List Sample Excel: Create a Practical Task Tracker

How-to basics · Updated November 20, 2026

A useful to-do list sample in Excel has columns for the task, owner, due date, priority, status, and notes. In Microsoft Excel for Microsoft 365, put those headings in row 1, turn the range into a table, and use filters and status dropdowns to keep the list easy to update.

A simple to-do list sample for Excel

Use the example below as a starting point. The dates are illustrative; enter dates that fit your own schedule. The sample includes six tasks so you can see how different priorities and statuses look together.

Task Owner Due date Priority Status Notes
Draft project brief Maya 2027-11-20 High In progress Share with the team for review
Collect team requirements Jordan 2027-11-24 Medium Not started Ask each department lead
Confirm meeting room Sam 2027-11-22 Low Waiting Venue has not replied
Prepare first budget draft Maya 2027-11-28 High Done Saved in the project folder
Review supplier options Jordan 2027-12-02 Medium Not started Compare delivery times
Send kickoff invitation Sam 2027-11-26 Low Done Invitation sent

In Excel, enter the headings across cells A1:F1 and the task records beneath them. Dates entered as actual Excel dates can be sorted and used in calculations; typing a date in a format Excel does not recognize may leave it as text. The ISO-style dates shown here are a clear reference, but the format Excel accepts can depend on your regional settings.

How to build the list in Excel

Start with a blank worksheet and create one row for each task. Keep one task per row and one kind of information per column. This structure makes filtering, sorting, and adding formulas more dependable than putting several tasks in one cell or separating sections with blank rows.

  1. Enter the six headings shown in the sample into row 1, then add your tasks below them.
  2. Select a cell in the filled range and choose Insert > Table. Check that the range includes the headings and that My table has headers is selected, then confirm.
  3. Give the table a useful name from the Table Design tab, such as Tasks, if you plan to refer to it in other workbook features.
  4. Use the filter arrows in the table headings to show only a particular owner, priority, or status. Sort the due-date column to bring the nearest deadlines into view.
  5. Save the workbook somewhere you can find it, and decide who is allowed to edit it if it will be shared.

The Insert > Table path is available in Excel for Microsoft 365 on Windows and Mac. In Excel for the web, the ribbon layout can differ slightly, but the same table feature is available from the Insert tab. A table expands as you add rows directly below it, and its filters and formatting are easier to maintain than a manually formatted range.

Useful columns and what they do

The sample works for a small personal list or a basic team tracker, but the right columns depend on how you will use it. Add only fields that help you decide what to do, when to do it, or who is responsible. Too many fields create extra updating work and can make the important information harder to spot.

  • Task: Start with a clear action, such as “Send kickoff invitation,” rather than a vague label like “Kickoff.”
  • Owner: Use one accountable person where possible. If several people contribute, note collaborators in Notes rather than making ownership ambiguous.
  • Due date: Record the actual deadline, not the date you hope to start. If a task has no firm deadline, leave the date blank rather than inventing one.
  • Priority: A small set such as High, Medium, and Low is usually easier to apply consistently than a long scale.
  • Status: Choose a few meaningful states, for example Not started, In progress, Waiting, and Done.
  • Notes: Capture a short blocker, next step, or link location. Avoid turning this field into a long project history.

For more involved work, consider adding a project or category column, a start date, or a link to a supporting document. A separate completion percentage is not always useful: if a task is either finished or unfinished, a clear status is simpler and less subjective. If the list serves multiple projects, a project column often makes filtering more reliable than creating a separate worksheet for every small workstream.

Add status dropdowns and readable formatting

Dropdowns reduce inconsistent entries such as “In progress,” “In Progress,” and “Started,” which Excel otherwise treats as different text. Select the cells in the Status column below its heading, then choose Data > Data Validation. Set Allow to List and enter the permitted values in Source, separated by commas: Not started,In progress,Waiting,Done. Confirm the dialog. If your regional settings use another list separator, use the separator Excel expects.

Repeat the process for Priority with High,Medium,Low. You can also keep the approved values in a small reference range on another worksheet and use that range as the validation source; this can be easier to maintain if the list is shared or the options may change. The Data Validation dialog and the Data tab are available in the Microsoft 365 desktop app on Windows and Mac, though the dialog’s appearance may vary.

For quick visual scanning, select the status cells and choose Home > Conditional Formatting > Highlight Cells Rules > Text that Contains. Add a rule for Done, then repeat for Waiting or In progress, selecting restrained colors that remain readable. Conditional formatting changes how a value appears, not the underlying status, so users should still update the dropdown when the task changes. Avoid using color alone to communicate meaning; the visible status text should remain understandable if the workbook is printed or viewed by someone who cannot distinguish the colors.

Optional formulas for overdue tasks and progress

You can use formulas to summarize the list, but the basic tracker does not require them. In the sample layout, row 1 contains headings, due dates are in C, statuses are in E, and records occupy rows 2 through 7. To label a task as complete, overdue, open, or missing a date, add a new heading such as Date check in G1. Put this formula in G2 and fill it down through G7:

=IF(E2="Done","Complete",IF(C2="","No date",IF(C2<TODAY(),"Overdue","Open")))

The formula checks for Done first, then checks whether the due date is blank, then compares the due date with TODAY. With the sample’s first task, a due date of 2027-11-20 and status In progress, the result is Open on 2026-11-03. The result changes as the calendar advances because TODAY updates when Excel recalculates. A task due today is labeled Open, not Overdue, because the comparison uses less than rather than less than or equal to. If you want “due today” treated differently, adjust the rule deliberately and explain that convention to anyone using the file.

To count completed tasks, place a label such as Completed in another cell and use a COUNTIF formula. With statuses in E2:E7, the formula is =COUNTIF(E2:E7,"Done"). It returns 2 for the sample because two of the six status cells contain Done. If you add more tasks, extend the range or use a table-based reference so new rows are included. Check that status values match the dropdown exactly; a spelling difference can make a count lower than expected.

Prioritize work and keep the list useful

A task list is most helpful when it makes the next action obvious. At the start of a work session, filter Status to exclude Done, sort by Due date, and review High-priority items. Then consider whether a task is genuinely urgent, blocked, or dependent on another person. Priority and due date answer different questions: priority describes relative importance, while the date indicates timing. A high-priority task might not be due first, and the earliest deadline is not automatically the most important work.

Break large, unclear tasks into actions that can be completed and checked off. For example, “Plan event” could become “Confirm venue,” “Draft agenda,” and “Send invitation.” Smaller entries make ownership and progress easier to see, but avoid making the list so granular that maintaining it becomes a task of its own. For recurring work, decide whether to create the next occurrence after marking the current one Done or to keep a separate recurring-work template. A simple list should not be expected to automatically generate future tasks unless you deliberately build that process.

Common problems and practical fixes

  • Dates will not sort correctly: Some entries may be text rather than dates. Check a sample cell’s number format and re-enter or convert the value to a real date before relying on date sorting or formulas.
  • Filters miss some entries: Check for blank rows inside the data or inconsistent spellings. An Excel table helps keep the filter range connected as tasks are added.
  • The overdue label seems wrong: Confirm that the due-date column is the one referenced by the formula, that the date is a real date, and that the status is not already Done. TODAY uses the computer’s current date when Excel recalculates.
  • Colors do not update: Conditional formatting rules may cover only part of the status column, or the entered text may not match the rule. Review the rule’s Applies to range and use the dropdown values consistently.
  • Several people overwrite changes: Store a shared workbook in a location that supports coauthoring, such as OneDrive or SharePoint, and check the sharing permissions. Avoid circulating multiple email copies as if they were one live tracker.
  • The worksheet becomes cluttered: Filter completed rows out of the active view or move old work to an archive sheet periodically. Keep a copy or agreed record if completed tasks need to remain available.

Template, custom workbook, or task app?

A blank workbook is flexible and costs no extra purchase beyond access to Excel, but it requires you to choose columns, set up validation, and maintain the process. Excel also offers ready-made templates through its template gallery; availability can vary by account, language, and version. Search the available templates for task or to-do lists, then inspect the columns and formulas before entering important work. A template is a starting point, not a guarantee that its workflow fits your needs.

Excel is a sensible choice when tasks need to sit alongside budgets, schedules, or other spreadsheet data, or when people need custom columns and familiar sorting. A dedicated task-management service may be more suitable when you need reminders, recurring assignments, comments, notifications, or a clear history of changes. Those features and their costs depend on the product and plan. For a short personal list, a spreadsheet can be more than enough; for a team relying on deadlines and automatic reminders, compare the real collaboration features before choosing.

Frequently Asked Questions

Does Excel have a built-in to-do list template?
Excel may show task or to-do templates in its template gallery. Availability can depend on the version, account, and region. If none suits your needs, the sample columns above can be entered into a blank workbook and turned into a table.

How do I make a to-do list dropdown in Excel?
Select the status cells, choose Data > Data Validation, set Allow to List, and enter the status choices in Source, separated by commas. Add the choices you intend to use before sharing the list so entries remain consistent.

Can Excel automatically show overdue tasks?
Yes. A formula can compare each due date with TODAY and return an Overdue label when the date has passed, as long as the due date is a real Excel date and the task is not marked Done. The label updates as the current date changes.

How do I sort a to-do list by due date?
Use the filter arrow in the Due date table heading and choose a date sort order. If the order looks incorrect, check that the cells contain real dates rather than text, and confirm that blank dates are handled in the way you expect.

Can multiple people edit an Excel task list?
Yes, if the workbook is saved in a supported cloud location such as OneDrive or SharePoint and shared with appropriate permissions. Coauthoring availability depends on the account and file setup, so confirm that collaborators can access the same workbook rather than separate copies.

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.