How to Make a Task Tracker in Excel: Step by Step

To make a task tracker in Excel, create columns for Task, Owner, Status, Priority, Due Date, and Notes. Turn the range into an Excel table with Ctrl+T. Add drop-down lists for Status and Priority, then use conditional formatting to highlight overdue tasks. Finally, add a summary with COUNTIF to count tasks by status.
This guide walks through each step, from the column layout to a small status dashboard. It includes the exact formulas for overdue flags and percent complete, plus a worked example for a team event. Steps come from Microsoft's support pages, read on November 17, 2026.
Why use a task tracker in Excel
A task tracker is a single list of everything that needs doing, who owns it, and when it is due. It replaces scattered notes, chat threads, and memory.
Excel is a good home for one when:
- The team is small. Two to ten people can share one workbook easily.
- The work is short-lived. An event, a launch, a month-end close, or a small project.
- You need flexibility. You can add any column you like without asking for a new tool.
- Everyone already has Excel. No new logins or training.
Dedicated project tools are better for large teams, long projects, or work with many dependencies. For most day-to-day work, though, a well-built task tracker in Excel is enough.
The same layout works for many kinds of lists. Use it for a project task list, a school assignment tracker, a job application tracker, or an operations log. Only the column names change.
Plan your columns
Decide what you need to know about each task before you open Excel. Too few columns and the tracker is vague. Too many and nobody fills it in.
Start with these:
| Column | What goes in it | Example |
|---|---|---|
| Task | A short action, starting with a verb | Send invites |
| Owner | One person responsible | Ana |
| Status | Not started, In progress, or Done | In progress |
| Priority | High, Medium, or Low | High |
| Due Date | The deadline, as a real date | 11/12/2026 |
| Notes | Blockers, links, or context | Waiting on guest list |
Optional columns include Start Date, Category, Effort, and Date Completed. Add them only if you will use them in a filter or a summary.
Two habits keep the tracker useful. Give every task exactly one owner, even if several people help. And write tasks as actions, such as Book venue, not topics, such as Venue.
Build the table
An Excel table makes the task tracker easier to sort, filter, and extend. Microsoft says you can "turn a range of cells into an Excel table" to make data easier to manage and analyze.
- Type your column headers in row 1.
- Enter a few tasks so Excel can see the data.
- Click any cell in the range and press Ctrl+T.
- Check My table has headers, then select OK.
The table gives you several features at once:
- Filter buttons. Microsoft notes that "Every table column has filtering enabled in the header row." Filter by owner or status in two clicks.
- Banded rows. Alternate shading "helps to better distinguish the data."
- Calculated columns. A formula typed in one cell fills the whole column.
- Automatic growth. New rows typed below the table join it, keeping formats and formulas.
Give the table a name, such as Tasks. Select a cell in it, then type the name in Table Name on the Table Design tab. Named tables make formulas easier to read.
Format the Due Date column as a date. Select it, then pick Short Date from the number format list on the Home tab.
Add drop-down lists for status and priority
Free text in the Status column causes trouble. One person marks a task as finished, another as complete, and your counts stop matching. A drop-down list fixes this.
Microsoft explains the benefit: drop-downs "allow people to pick an item from a list that you create."
- On a new sheet named Lists, type your status values in one column: Not started, In progress, Done.
- Select them and press Ctrl+T to make a small table.
- Go back to your tracker and select the Status column cells.
- Go to Data > Data Validation.
- On the Settings tab, in the Allow box, select List.
- Click in the Source box and select your list of status values.
- Select OK.
Repeat for the Priority column with High, Medium, and Low.
Putting the lists in a table pays off later. Microsoft says that when you add or remove items, "any drop-downs you based on that table will automatically update."
You can also add an error alert under the Error Alert tab of the same dialog. Then Excel blocks entries that are not on the list.
Highlight overdue tasks
A good task tracker should warn you about late work without anyone checking dates by hand. Conditional formatting with the TODAY function does this.
Microsoft says TODAY "returns the serial number of the current date." It is useful "when you need to have the current date displayed on a worksheet, regardless of when you open the workbook."
To color overdue rows red:
- Select the data rows of your table, starting at A2.
- Select Home > Conditional Formatting > New Rule.
- Choose Use a formula to determine which cells to format.
- Enter this formula:
=AND($E2<TODAY(),$C2<>"Done") - Select Format, pick a light red fill, and select OK.
Here column E holds the due date and column C holds the status. The dollar signs lock the columns, so every cell in a row checks the same due date and status.
Add a second rule for tasks due in the next three days, with a yellow fill:
=AND($E2>=TODAY(),$E2<=TODAY()+3,$C2<>"Done")
You can also gray out finished tasks with =$C2="Done" and a gray font. That keeps attention on open work.
Add a status summary
A short summary at the top, or on its own sheet, shows progress at a glance. COUNTIF does most of the work.
Microsoft describes COUNTIF simply. It counts "the number of cells that meet a criterion." The syntax is COUNTIF(range, criteria).
Build a small block like this:
| Measure | Formula |
|---|---|
| Not started | =COUNTIF(C2:C9,"Not started") |
| In progress | =COUNTIF(C2:C9,"In progress") |
| Done | =COUNTIF(C2:C9,"Done") |
| Overdue | =COUNTIFS(E2:E9,"<"&TODAY(),C2:C9,"<>Done") |
| Percent complete | =COUNTIF(C2:C9,"Done")/COUNTA(A2:A9) |
The overdue line uses COUNTIFS, because it checks two conditions. Microsoft notes that COUNTIF "uses only a single criteria," and says to use COUNTIFS "if you want to use multiple criteria."
Format the percent complete cell as a percentage. For a visual touch, add a data bar to it from Conditional Formatting > Data Bars.
To see the workload per person, list each owner and count their open tasks with =COUNTIFS(B2:B9,"Ana",C2:C9,"<>Done").
A worked example: tracking a team event
Here is a task tracker in Excel for a company event. The date of the check is November 17, 2026.
| Task | Owner | Status | Priority | Due Date |
|---|---|---|---|---|
| Draft event budget | Ana | Done | High | 11/5/2026 |
| Book venue | Ben | Done | High | 11/8/2026 |
| Confirm speakers | Ana | Done | Medium | 11/10/2026 |
| Send invites | Ana | In progress | High | 11/12/2026 |
| Order catering | Chris | Not started | Medium | 11/14/2026 |
| Prepare slides | Ben | In progress | Medium | 11/20/2026 |
| Print badges | Chris | Not started | Low | 11/24/2026 |
| Test AV setup | Ben | In progress | High | 11/26/2026 |
The summary formulas return:
- Done: 3 tasks.
- In progress: 3 tasks.
- Not started: 2 tasks.
- Overdue: 2 tasks, Send invites and Order catering.
- Percent complete: 3 of 8, or 37.5%.
The red rows tell the story. Invites are five days late, and catering has not started though it was due three days ago. Both block other work, so they go to the top of the next team check-in.
Ana owns one open task, Ben owns two, and Chris owns two. The load is fairly even, so the fix is to unblock the late tasks, not to reassign them. Ana can finish the invites today, and Chris can place the catering order once the guest count is final.
Track recurring and operational work
Not every task is a one-off. Many teams also use a task tracker for work that repeats or that never really ends, such as equipment checks, stock counts, or weekly reports. The same tracker can handle it with two small changes.
Add a Frequency column. Use a drop-down with Daily, Weekly, and Monthly. When a recurring task is done, change its due date to the next cycle instead of closing it.
Add an exceptions log. On a second sheet, log anything unusual: a machine that failed a check, a missing delivery, or an item found in the wrong place. Use columns for Date, Item, Issue, Owner, and Resolved. One row per event keeps a clean history.
Over a few months, that log becomes useful data. Count issues by item with COUNTIF to see which equipment fails most. Count by week to see whether problems are rising. A PivotTable summarizes the log in seconds.
This is where a task tracker turns into a record. The task list shows what to do next, and the log shows what has happened over time.
Add a progress chart. Numbers in a summary block are useful, but a small chart makes progress obvious in a meeting.
- Select the status labels and their counts from your summary block.
- Select Insert > Charts and choose a bar or doughnut chart.
- Title the chart with the finding, such as "3 of 8 tasks done."
The chart updates when a status changes, because it reads from the COUNTIF formulas. Place it next to the summary at the top of the sheet, so it is the first thing people see.
Keep the tracker up to date
A task tracker is only as good as its last update. These habits keep it trustworthy.
- Update at a fixed time. A short weekly review, or a daily one in busy weeks, works well.
- Close tasks right away. Set the status to Done as soon as the work finishes.
- Add a Date Completed column. It shows how long tasks really take, which helps future planning.
- Archive finished work. Move Done tasks to an Archive sheet each month so the main list stays short.
- Share one file. Store the workbook in a shared folder, such as OneDrive, so everyone edits the same copy.
- Freeze the header row. Select View > Freeze Panes > Freeze Top Row so the column names stay visible.
Make a task tracker in Excel with AI
Building the sheet takes about half an hour. Keeping it current is harder when tasks arrive by email, chat, and meeting notes. An AI tool can turn those raw lists into a clean tracker and a summary.
Here is the method in three steps, using Powerdrill Bloom.
Step 1: Upload your task list
Upload the tasks you already have, such as an exported list, a CSV from another tool, or a rough spreadsheet. The Excel AI Assistant page says you can "upload your Excel/CSV files."
Include owner names and due dates if you have them. The cleaner the input, the better the tracker.
Step 2: Ask for the tracker and summary in natural language
Describe what you need. For example: "Clean this task list into a tracker with Task, Owner, Status, Priority, and Due Date columns. Then count open and overdue tasks by owner."
The page says the tool can "automatically analyze data, uncover insights, and create visual reports." Ask for a chart of open tasks by owner, too.
Step 3: Export and keep updating
Download the cleaned task tracker and add the drop-downs and formatting rules from this guide. The page also says you can "Export insights as PowerPoint slides, infographics, or Notion pages in one click." That makes a weekly status update quick to share.
Common mistakes to avoid
These are the problems that come up most often with a task tracker in Excel.
- Free-text status. Use a drop-down list so counts stay correct.
- Dates stored as text. Text dates break the overdue rule. Format the column as a date.
- Shared ownership. A task with two owners often has none. Pick one.
- Too many columns. Remove any column nobody uses.
- No overdue warning. Without conditional formatting, late tasks hide in plain sight.
- Never archiving. A list of 300 rows, mostly finished, is hard to scan.
- Many copies. Emailing the file creates competing versions. Keep one shared workbook.
For a status report built on top of your tracker, see our guide on how to write a weekly status report from your data. For timelines, see how to create a Gantt chart with AI.
When your tasks are scattered across exports, try Powerdrill Bloom to turn them into one clean tracker.
Frequently asked questions
How do I create a simple task tracker in Excel?
Add columns for Task, Owner, Status, Priority, and Due Date. Turn the range into a table with Ctrl+T, add drop-down lists for Status and Priority, and highlight overdue tasks with conditional formatting.
How do I highlight overdue tasks in Excel?
Use a conditional formatting rule with a formula such as =AND($E2<TODAY(),$C2<>"Done"). It colors any row whose due date has passed and whose status is not Done.
How do I add a drop-down list for status in Excel?
Type your status values on another sheet, then select the Status cells. Go to Data > Data Validation, choose List in the Allow box, and select your values as the source.
How do I calculate percent complete in a task tracker?
Divide the number of Done tasks by the total number of tasks. For example, =COUNTIF(C2:C9,"Done")/COUNTA(A2:A9), formatted as a percentage.
Does Excel have a task tracker template?
Yes, Excel offers templates, but building your own takes about half an hour. A custom tracker fits your columns and your team's way of working.
Sources: Microsoft Support, Overview of Excel tables · Microsoft Support, Create a drop-down list · Microsoft Support, TODAY function · Microsoft Support, Use the COUNTIF function in Microsoft Excel.