Excel To-Do List Examples and Simple Templates

How-to basics · Updated November 19, 2026

Excel to-do list examples range from a simple personal checklist to a project tracker with owners, priorities, due dates, and progress. A practical starting template has columns for Task, Owner, Priority, Due Date, and Status; Excel Tables, filters, and a couple of formulas can make it easier to manage as the list grows.

What to include in an Excel to-do list

A useful list records enough information to answer three questions: what needs doing, who is responsible, and what should happen next. For a personal list, task name, due date, and status may be enough. For shared work, add an owner, priority, project or category, and perhaps a notes column. Avoid adding fields that nobody will keep up to date.

Here is a small example. The entries are illustrative; the best columns depend on the work being tracked.

Task Owner Priority Due Date Status
Confirm meeting room Alex High Nov 5 In progress
Draft agenda Sam Medium Nov 6 Not started
Send final invitation Alex High Nov 7 Done

Keep one task per row. If a task has several independently trackable parts, split it into subtasks rather than putting a long checklist inside one cell. That makes it possible to assign different owners and dates, filter individual actions, and see which parts are actually complete.

Build a basic list in Excel

In Microsoft Excel for Microsoft 365 on Windows, start with a blank worksheet and place clear column headings in row 1. Enter a task on each following row, then turn the range into a table using Insert > Table. Confirm that the selected range is correct and select the option indicating that the table has headers. A table adds filter controls to the headings and extends its formatting when you add rows.

  1. Choose a short, specific task description, such as “Review draft budget,” rather than a broad label like “Budget.”
  2. Enter real Excel dates in the Due Date column. You can format the column with Home > Number Format and choose a date display.
  3. Use consistent status labels, for example Not started, In progress, Waiting, and Done.
  4. Set a priority scale that everyone understands. “High, Medium, Low” is usually clearer than an unexplained number scale.
  5. Save the workbook in a location you can find and update; if several people need to edit it, consider a shared OneDrive or SharePoint location.

On Mac, the Insert > Table route is also available, although some ribbon labels and window layouts can differ slightly by Excel release. Excel for the web has tables and filters as well, but some desktop features and controls may be arranged differently. A simple table is usually easier to use across platforms than a workbook that relies on macros or specialized add-ins.

Use formulas to summarize progress

A formula can turn a long list into a quick progress measure. With task names in A2:A6 and status entries in E2:E6, enter this formula in a summary cell:

=COUNTIF(E2:E6,"Done")/COUNTA(A2:A6)

If five task names are present and two status cells contain Done, the result is 0.4, or 40% after you format the result as a percentage. The formula counts completed statuses and divides by the number of nonblank task names. If your list grows, use table column references or extend the ranges so new rows are included; a formula that stops at row 6 will not count later entries.

You can also add a flag for past-due work. With the due date for a task in D2 and its status in E2, enter this formula in F2 and fill it down:

=IF(AND(D2<TODAY(),E2<>"Done"),"Overdue","")

If today is November 3, 2026, D2 is November 2, 2026, and E2 says In progress, the formula returns Overdue. For a completed task or a date that has not passed, it returns a blank cell. TODAY updates with the current date when Excel recalculates, so this flag is dynamic; it is not a permanent record of when a task first became overdue. If the workbook is opened in a different time zone or on a later date, the result can change accordingly.

Make the list easier to read and update

Formatting should make important information visible without turning the worksheet into a wall of color. Use a consistent date format, keep headings descriptive, and wrap text for long task names if needed. Excel Tables provide banded rows that help readers follow a task across columns. Use bold or a restrained fill color for the header, but avoid using color as the only indication of status; a written label remains understandable when printed or viewed by someone with color-vision differences.

For a status dropdown, select the cells in the Status column and choose Data > Data Validation > Data Validation. In the settings, set Allow to List and enter the approved labels in the Source box, separated by commas. This reduces variations such as “In progress,” “In Progress,” and “Started,” which can cause filters and COUNTIF formulas to miss some entries. Keep the list of choices short and change it only when the process genuinely requires another status.

To highlight dates, select the Due Date cells and use Home > Conditional Formatting > Highlight Cells Rules. Conditional formatting can help distinguish dates that need attention, but check the rule against the dates and statuses you use. A past due date on a completed task may not need the same visual warning as a past due date on an unfinished one. The formula-based flag above handles that distinction more explicitly.

Examples for different kinds of work

A personal errands list can stay compact: Task, Category, Due Date, and Done. Categories such as Home, Calls, and Shopping can be filtered when you want to focus on one kind of activity. For recurring chores, a “Next Due” date is more useful than repeatedly copying old rows without noting which occurrence is current.

A team project tracker often needs Task, Owner, Priority, Start Date, Due Date, Status, and Notes. Add a Project or Workstream column if one sheet covers several efforts. A “Blocked by” field can be helpful when progress depends on another person or task, but keep it specific—for example, name the approval or deliverable that is missing.

An event-planning list might track Task, Vendor or Contact, Owner, Due Date, Cost Estimate, and Status. A maintenance log may need Asset, Task, Last Completed, and Next Due instead. These are still to-do lists, but the extra columns reflect the decisions each workflow requires. Do not add sensitive personal information unless the workbook’s storage and access controls are appropriate for it.

Sort, filter, and review the work

Table filter arrows let you show only tasks assigned to one owner, a selected status, or a particular priority. Sorting by due date can bring upcoming work to the top; filtering out Done tasks can make an active-work view less cluttered. A filter hides rows rather than deleting them, so clear the filter when a task appears to have disappeared.

A useful review routine is to check the list at a regular interval, update statuses, confirm owners and dates, and remove or archive obsolete tasks. For a small list, the table itself may be all the overview you need. For a larger one, a separate summary area can show counts by status or priority. Keep summaries connected to the actual task records rather than manually typing totals, which can become stale after edits.

Freeze the header row when a long list requires scrolling: choose View > Freeze Panes > Freeze Top Row. This keeps the column names visible while you move down the sheet. On Windows, Ctrl+Z undoes many recent worksheet edits; on Mac, use Command+Z. Undo is useful for ordinary changes, but it is not a substitute for saving a backup before major restructuring.

Sharing, access, and workbook upkeep

For a list that only one person maintains, a workbook stored locally may be sufficient. For collaboration, store the file in OneDrive or SharePoint and use Excel’s Share controls to invite people with the appropriate access. Coauthoring depends on the file being stored in a supported shared location and on the account and application setup. Agree on who may change headings, status choices, or formulas; accidental edits to those parts can affect everyone’s view.

Excel can also be used in a browser, which is convenient for basic editing and sharing, but not every desktop feature behaves identically in every environment. If a workbook depends on complex formatting, external data, macros, or other advanced features, check that those features are supported in the version the group will use. Save in the standard Excel workbook format when you need to retain formulas, formatting, tables, and validation rules.

Common problems and how to avoid them

  • Dates sort incorrectly: A date may have been entered as text. Apply a date number format and check whether Excel recognizes the cell as a date; typing dates consistently and using the date picker when available helps avoid ambiguity.
  • Progress totals look wrong: Check that status spelling matches the formula’s criterion and that the formula range includes all task rows. A blank task row should not be counted as a task.
  • Too many status labels: Labels such as “Started,” “Ongoing,” and “Working on it” may describe the same state. Agree on a small set and use Data Validation to standardize entries.
  • Old tasks overwhelm the sheet: Filter completed work or move it to an archive sheet periodically. Keep enough history for the purpose of the list, but do not let old rows make current work hard to find.
  • Color rules become confusing: Use a few consistent visual cues and keep the text status visible. A color-coded cell without a clear label is less useful when printed, copied, or viewed with different display settings.

Excel versus task-management apps

Excel is a flexible choice for straightforward tracking, custom columns, quick sorting, and a list that benefits from calculations or a familiar grid. It is not automatically a full project-management system. Features such as task dependencies, reminders, comment histories, and workflow automation may require extra setup or another product. A spreadsheet also depends on someone maintaining the records and communicating changes.

Microsoft To Do, Planner, and other task-management tools may suit work that needs notifications, assigned tasks, or dedicated collaboration features. The right choice depends on the team’s existing software, access requirements, and the complexity of the process. Excel’s availability and price depend on the Microsoft license or plan in use; there is no separate charge for a particular to-do-list template, but access to Excel itself is subject to the applicable license. Compare current plans and included features before choosing a tool.

Frequently Asked Questions

Does Excel have a built-in to-do list template?
Excel may offer task-list templates through its template gallery, and availability can vary by version and account. You can also make a basic list from a blank workbook using the columns and steps above, which makes it easier to tailor the sheet to your own workflow.

How do I make a checklist in Excel?
For a simple checklist, create Task and Status columns, then use a status dropdown with values such as Not started and Done. You can filter the status column to show unfinished work. Excel also has checkbox features in some Microsoft 365 builds, but availability and behavior can differ; a text status works across more versions.

Can Excel automatically show overdue tasks?
Yes. Use a due-date column and a status column with the formula shown above, or apply conditional formatting to dates. A formula that checks both the date and whether the task is Done avoids flagging completed work as overdue.

How do I calculate the percentage of completed tasks?
Count the Done entries and divide by the number of task names, as in the COUNTIF and COUNTA example. Format the result as a percentage and make sure the ranges cover the full list. A table-based formula or an expanded range is needed if you expect to add rows beyond the original range.

Can more than one person edit an Excel to-do list?
Yes, when the workbook is stored in a supported OneDrive or SharePoint location and shared with collaborators. Access depends on the account, permissions, and version being used. Set expectations about who maintains the list and avoid changing its structure without telling other editors.

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.