Task Tracking Template Excel Users Keep: Build It in 7 Steps

A task tracking template Excel can run on is one structured table: one row per task, with columns for owner, status, priority and due date, plus drop-down lists so everyone types the same values and a rule that turns overdue rows red. You can build it in about seven steps, in Excel or as a Google Sheets task list. It works well for one person or a small team. It stops working when several people edit at once, statuses go stale and nobody gets a reminder. That point is easy to spot, and we show it below.

What a task tracker needs before you open Excel

Most homemade trackers fail because they start as a to-do list and grow columns at random. Decide the structure first. A task tracker answers four questions for every task: what it is, who owns it, where it stands and when it is due. Everything else is optional. If you want the wider method behind this (capturing, prioritizing, reviewing), our task management guide covers it. Here, we build the sheet.

These are the columns worth having, in this order:

• Task: a short verb-first name, such as Draft Q4 budget.
• Project: which project or client it belongs to, so you can filter.
• Owner: one person. Two owners usually means no owner.
• Status: a fixed list, for example Not started, In progress, Blocked, Done.
• Priority: High, Medium or Low.
• Start date and Due date: real dates, not text.
• Notes: one line on what is blocking or what changed.

Keep the status list short. Four values are enough. Every extra status is one more thing people forget to update, and a tracker is only as good as its least updated row. Put the lists of allowed values on a separate sheet called Lists, so you can change them in one place later.

Build the task tracking template Excel needs, step by step

These steps follow Microsoft's own instructions for Excel on Windows. Mac and web menus use the same names with small layout differences.

1. Type the headers in row 1 of a new sheet: Task, Project, Owner, Status, Priority, Start date, Due date, Notes.
2. Turn the range into a table. Select any header cell and press Ctrl+T, then confirm that your table has headers. A table extends formatting and rules to new rows automatically, and every header gets a filter button for free.
3. Create the Lists sheet. Type your statuses in one column, priorities in another and owners in a third, with no blank cells. Microsoft recommends keeping these lists in a table too, because drop-downs based on a table update automatically when you add or remove items.^[1]
4. Add the drop-downs. Select the Status column, go to Data, then Data Validation. On the Settings tab, set Allow to List, click in the Source box and select your status range. Keep In-cell dropdown checked. Repeat for Priority and Owner.
5. Block typos. On the Error Alert tab of the same dialog, keep the error alert on with the Stop style. Now nobody can type Doen or In-progress.
6. Format the date columns as dates (Home, then the Number format box, then Short Date), so formulas can compare them with today.
7. Flag overdue work. Select the table rows, go to Home, then Conditional Formatting, then New Rule, and choose Use a formula to determine which cells to format. Enter =AND($G2<>"",$G2<TODAY(),$D2<>"Done") and pick a red fill. The first check keeps tasks without a due date from turning red. Microsoft's own example uses the same TODAY comparison to color past dates.^[2]

Add a second rule for tasks due within a week: =AND($G2>=TODAY(),$G2<=TODAY()+7,$D2<>"Done") with a yellow fill. The two rules never overlap, because one checks dates before today and the other dates from today on. If you later add a rule that does overlap, remember that new rules go to the top of Manage Rules and win.

The formulas that turn a list into a tracker

A list shows tasks. A tracker shows progress. Put a small summary block above the table or on its own sheet:

• Percent done: =COUNTIF(Tasks[Status],"Done")/COUNTA(Tasks[Task]), formatted as a percentage.
• Overdue count: =COUNTIFS(Tasks[Due date],"<"&TODAY(),Tasks[Status],"<>Done").
• Open tasks per person: =COUNTIFS(Tasks[Owner],"Maria",Tasks[Status],"<>Done"), one line per owner.

Name the table Tasks first (Table Design, then Table Name). The formulas then read like sentences and keep working as rows are added. That is the whole engine. No macros needed.

The same tracker as a Google Sheets task list

Google Sheets gets you the same result, and sharing is easier. Type the same headers, then add the drop-downs. You have three routes. Select the Status cells and click Insert, then Dropdown. Or type @ in a cell and pick Dropdowns from the components section, where Google also offers preset dropdowns for Project status and Priority. Or go to Data, then Data validation, then Add rule, and set the criteria to Dropdown or Dropdown from a range.^[3]

Each dropdown value can carry its own color, so Done can be green and Blocked red without any extra rule. By default, an entry that is not on the list is rejected. Leave it that way. If one task really needs several tags, the chip style allows multiple selections, but keep Status to a single value.

For overdue rows, use Format, then Conditional formatting, choose Custom formula is, and paste the same AND formula with your column letters. The COUNTIF and COUNTIFS summaries work in Sheets too, with plain ranges such as D2:D500 instead of table names.

The main reason to pick Sheets over Excel here is live editing. Five people can update their own rows at the same time, and each change is saved as it happens. Excel can do this through OneDrive or SharePoint, but many small teams still email copies around, which is how two versions of the truth are born.

A mini example: one week of a five-person team

Here is what the tracker looks like on a Wednesday, with today as October 28 for the formatting rules:

The summary block reads 20% done, one overdue and two due in the next seven days. In a Monday meeting, filter Status to Blocked and you have the agenda. Filter Owner to Sam and you have his week. That is most of what a small team needs from task tracking, and the sheet delivers it.

Notice what the sheet does not tell you. It does not say why the budget is late, or that the venue booking had to happen before the client deck could be finished. Those gaps are the start of the next section.

Where the spreadsheet stops working

A spreadsheet tracker holds up longer than people expect. It breaks at a few specific points, and you will usually hit two of them together.

Dependencies do not move. If Fix invoice template slips three days, every task that waits on it should slip too. In a sheet, nothing moves. Someone has to notice and retype the dates by hand.

Statuses go stale. The tracker is only true when people open it. In a shared tool, status changes as people work. In a sheet, it changes when someone remembers, usually the night before the meeting.

Nobody gets told. A red cell is useless if nobody looks at it. A sheet does not notify an owner when a task is assigned, when a due date arrives or when a blocker clears.

Context lives elsewhere. The files, comments and decisions about a task end up in email and chat. The row says Blocked, and the reason sits in someone's inbox.

Several people, several projects. Once several people edit every day, or you run more than one or two projects in the same file, the filters, the per-person formulas and the extra tabs start to fight each other.

When two of these hit at once, a task app pays for the switch. You keep the same columns. The difference is that statuses, owners and dates live where the work happens. These three map most directly onto the tracker you just built:

For the full set of options, grouped by team type and situation, see our guide to task management apps. If you already know you want one of these, the Asana review goes deeper on how it handles assignments and status updates.

The bottom line

For one person or a small team, a well-built sheet is a serious task tracker: one table, fixed drop-downs, a red rule for overdue work and three COUNTIF formulas for progress. Build it in Excel if your files already live there, or in Google Sheets if several people need to edit at the same time. Then watch for the threshold. When dates have to move together, when statuses go stale between meetings or when people need to be told about their work, the sheet has done its job. Move the same columns into a task app and keep the habits you built.