Project tracker template for Excel and Google Sheets
A project tracker is a spreadsheet with one row per piece of live work, showing who owns it, its status, its due date and how far along it is, so you can see what is late or stuck at a glance. This page gives two layouts: a task tracker for one project and a multi-project tracker for five to ten client projects. Download the task tracker CSV, the multi-project tracker CSV or the formulas and setup steps. Both CSVs open in Google Sheets and Excel.
A tracker follows work already under way. To build the schedule first, use the project plan template; for cards in columns, see the kanban board examples.
Layout 1: a single-project task tracker
One row per task. Use these ten columns, in this order, so the formulas below work as written.
| Column | What goes in it | Rule |
|---|---|---|
| A Task | A verb and an object | One person can finish it within a week |
| B Owner | One name | Never "team" |
| C Status | Dropdown: Not started, In progress, Blocked, Done | No other values |
| D Priority | Dropdown: High, Medium, Low | Set once |
| E Start | Date | Planned start |
| F Due | Date | Every task gets one |
| G % complete | A whole number from 0 to 100 | 100 only when Status is Done |
| H Days late | Formula | Never typed |
| I Blocker | What it waits for, and from whom | Filled only when Status is Blocked |
| J Notes | Short context, and "Done 13 Nov" when a task closes | One line |
Cell M2 holds the as-of date: =TODAY() for daily use, or a fixed date to check the sample.
Filled sample: holiday menu and online ordering
Saltbox Catering is a fictional eight-person caterer launching a holiday menu with online ordering, from Monday 2 November to Wednesday 2 December 2026. Status is as of Wednesday 18 November 2026; the CSV writes dates as 2026-11-02.
| Task | Owner | Status | Priority | Start | Due | % | Days late | Blocker | Notes |
|---|---|---|---|---|---|---|---|---|---|
| Agree holiday menu and prices | Maya | Done | High | 2 Nov | 6 Nov | 100 | 0 | Done 6 Nov | |
| Cost each dish and set the minimum order | Tom | Done | High | 4 Nov | 10 Nov | 100 | 0 | Done 10 Nov | |
| Choose the online ordering service | Tom | Done | High | 5 Nov | 12 Nov | 100 | 0 | Done 11 Nov | |
| Photograph 12 menu dishes | Priya | Done | Medium | 9 Nov | 13 Nov | 100 | 0 | Done 13 Nov | |
| Print order labels | Leo | Done | Low | 12 Nov | 13 Nov | 100 | 0 | Done 12 Nov | |
| Hire two seasonal drivers | Maya | Blocked | Medium | 2 Nov | 13 Nov | 30 | 5 | Checks pending | |
| Confirm turkey and ham quantities with supplier | Maya | Blocked | High | 9 Nov | 16 Nov | 25 | 2 | No price list | Asked 11 Nov |
| Write menu descriptions | Priya | In progress | Medium | 11 Nov | 17 Nov | 60 | 1 | ||
| Update opening hours on the website | Leo | In progress | Low | 16 Nov | 18 Nov | 50 | 0 | ||
| Order holiday packaging | Leo | Not started | Medium | 16 Nov | 19 Nov | 0 | 0 | ||
| Set up ordering page and card payments | Tom | In progress | High | 13 Nov | 20 Nov | 50 | 0 | ||
| Test five orders end to end | Priya | Not started | High | 23 Nov | 25 Nov | 0 | 0 | ||
| Train staff on order pickup | Maya | Not started | Medium | 25 Nov | 27 Nov | 0 | 0 | ||
| Email past customers about the menu | Priya | Not started | Medium | 30 Nov | 1 Dec | 0 | 0 | ||
| Go live and announce | Maya | Not started | High | 2 Dec | 2 Dec | 0 | 0 |
Formulas for the task tracker
Tasks sit in rows 2 to 16; ranges run to row 200 so new rows count. Every function here works the same in Google Sheets and Excel 2016 or later.
| What it shows | Put it in | Formula | Sample result |
|---|---|---|---|
| Days late | H2, then fill down | =IF(OR(F2="",C2="Done"),0,MAX(0,DAYS($M$2,F2))) | 5, 2 and 1 on the three late rows |
| Project % complete | M4, formatted as a percent | =AVERAGE(G2:G200)/100 | 48% (715 / 15 = 47.7) |
| Share of tasks done | M5 | =COUNTIF(C2:C200,"Done")/COUNTA(A2:A200) | 33% (5 of 15) |
| Overdue tasks | M6 | =COUNTIF(H2:H200,">0") | 3 |
| Due this week, not done | M7 | =COUNTIFS(F2:F200,">="&($M$2-WEEKDAY($M$2,3)),F2:F200,"<="&($M$2-WEEKDAY($M$2,3)+6),C2:C200,"<>Done") | 5 |
| Count by status | M8 to M11, labels in L8 to L11 | =COUNTIF($C$2:$C$200,L8), filled down | Not started 5, In progress 3, Blocked 2, Done 5 |
How the references work:
- $M$2, the as-of date, stays fixed when you fill down; F2 and C2 move to F3 and C3.
- DAYS(end, start) counts days from the due date to the as-of date; MAX(0, ...) turns future dates into 0. A Done task is never late.
- WEEKDAY($M$2,3) returns 0 for Monday to 6 for Sunday in both apps, so $M$2 minus it is this week's Monday: 16 November, with the week ending Sunday 22 November.
Highlight overdue and blocked rows
Make two rules on A2:J200: =$H2>0 for overdue (red) and =$C2="Blocked" (amber). The $ before the column letter colours the whole row.
Google Sheets:
- Select A2:J200.
- Click Format, then Conditional formatting.
- Under "Format cells if", choose Custom formula is.
- Type =$H2>0, pick a fill colour, and click Done.
- Click Add another rule and repeat with =$C2="Blocked".
Excel:
- Select A2:J200.
- On the Home tab, click Conditional Formatting, then Manage Rules, then New Rule.
- Choose "Use a formula to determine which cells to format".
- Type =$H2>0 in "Format values where this formula is true".
- Click Format, choose a fill, and click OK twice. Repeat with =$C2="Blocked".
For the Status dropdown, select C2:C200. Google Sheets: Data, Data validation, Add rule, Dropdown, then type the four values. Excel: Data, Data Validation, Allow: List, Source: Not started,In progress,Blocked,Done.
Layout 2: a multi-project tracker for five to ten client projects
One row per project; each project's tasks stay in their own task tracker tab, and the guide to managing multiple clients covers capacity around a sheet like this. Columns: A Project, B Client, C Owner, D Stage (dropdown: Kickoff, In delivery, Client review, Launch), E Start, F Due, G % complete (from the project's task tracker), H Health (formula), I Next milestone (the next thing the client will see), J Milestone date and K Last update (the date the owner last checked the project). The as-of date sits in N2.
| What it shows | Put it in | Formula |
|---|---|---|
| Health | H2, then fill down | =IF(OR(AND($N$2>F2, G2<100), AND(J2<>"", $N$2>J2)), "Late", IF(OR(G2<100*DAYS($N$2,E2)/DAYS(F2,E2)-15, DAYS($N$2,K2)>7), "At risk", "On track")) |
The rule it applies, checked in this order:
- Late: the due date has passed and the project is under 100%, or the next milestone's date has passed.
- At risk: percent complete is more than 15 points behind the share of time used, or nobody has updated the row for more than 7 days.
- On track: everything else.
Filled sample: a four-person studio
Northline is a fictional marketing studio with seven live projects, as of Wednesday 18 November 2026. On the sheet, start, due, milestone and date are separate columns.
| Project | Client | Owner | Stage | Start to due | % | Health | Next milestone, date | Last update |
|---|---|---|---|---|---|---|---|---|
| Website refresh | Fernwood Dental | Ana | In delivery | 5 Oct to 11 Dec | 55 | On track | Homepage design approved, 20 Nov | 17 Nov |
| November SEO retainer | Harbor Physio | Ben | In delivery | 2 Nov to 30 Nov | 50 | At risk | November report sent, 30 Nov | 9 Nov |
| Brand guidelines | Cobalt Coffee | Ana | Client review | 12 Oct to 13 Nov | 90 | Late | Client sign-off, 13 Nov | 16 Nov |
| Newsletter setup | Juniper Yoga | Cara | Kickoff | 16 Nov to 18 Dec | 5 | On track | Kickoff call held, 19 Nov | 16 Nov |
| Winter sale campaign | Atlas Bikes | Ben | In delivery | 26 Oct to 4 Dec | 30 | At risk | Ad creative approved, 24 Nov | 18 Nov |
| Trade show graphics | Pine and Pike Furniture | Cara | Launch | 19 Oct to 27 Nov | 80 | On track | Print files sent, 20 Nov | 17 Nov |
| Annual report design | Lakeside Food Bank | Dev | In delivery | 9 Nov to 15 Jan 2027 | 20 | On track | First layout draft, 27 Nov | 13 Nov |
Check your copy against these: 4 on track, 2 at risk, 1 late, average 47% (330 / 7). Harbor Physio is at risk because its last update is 9 days old; Atlas Bikes because 59% of its time has gone (23 of 39 days) at 30% done. Cobalt Coffee is late: its due date, 13 November, has passed. In N4 to N6, =COUNTIF($H$2:$H$50,M4) filled down counts each health value against the labels in M4 to M6.
A weekly routine that keeps the tracker true
| When | Who | What | Time |
|---|---|---|---|
| Friday by 4pm | Each task owner | Update status, % and blocker on their own rows only | 5 minutes |
| Monday 9:00 | Project lead | Sort by days late; send one message per blocker naming who owes what | 15 minutes |
| Monday 9:15 | Business owner | Call the owner of every At risk or Late project; write the date in Last update | 10 minutes per 5 projects |
A status report from the tracker in five minutes
Each section of the project status report template is a filter on the task tracker:
- Finished this period: Done rows whose note date falls in the period.
- In progress: In progress rows, with owner and due date.
- Risks and blockers: Blocked rows, copying the Blocker column word for word.
- Coming next: rows due this week and next.
- Overall status: green, amber or red, with the overdue and blocked counts as evidence.
Saltbox's first line: "Amber: 3 tasks overdue and 2 blocked (supplier price list, driver background checks); go-live on Wednesday 2 December holds if the price list arrives by Friday 20 November."
When a spreadsheet tracker stops working
A spreadsheet never reminds anyone; a red row only helps whoever opens the file. Emailed copies drift apart. And it is only true if people update it.
The test: run the Monday routine for two weeks. Move to a tool if either week shows a row with no update for over 7 days, a task living in email or chat but not the sheet, or more than about three people editing.
Add a RACI chart when nobody is sure who approves, and a project budget template to track hours or money. For customers rather than projects, use the Google Sheets CRM template.
The same tracker in Flori
Flori is a CRM with project management for 1 to 20 person businesses. Each project holds tasks with an owner, a status (To do, In progress, Waiting, Done), a priority, a planned date, a due date and a blocker reason. My work lists each person's tasks across projects, and dashboards show tasks by status, by assignee and due this week. Every task is marked On track, At risk or Off track from its due date, and on every plan a project can set work-in-progress limits that warn rather than block. The same tasks can be shown as a Gantt chart with dependency lines and milestones, where dragging a bar previews the knock-on dates before you confirm. Flori does not import a plain spreadsheet as tasks: task import reads exports or connections from Asana, Trello, monday.com, Airtable, Notion, ClickUp, Linear, Jira and GitHub. The free plan holds 3 active projects, so a seven-project tracker needs Core ($12 per person a month, or $10 billed yearly).
FAQ
What should a project tracker include? Task, owner, status from a fixed list, priority, start, due, percent complete, days late, blocker and notes. A multi-project tracker adds client, stage, health, next milestone and last update.
Is there a free project tracker template for Excel? Yes. Download the task tracker CSV above, open it in Excel, then paste the formulas from the table into H2 and M4 to M11. Leave the as-of date at 18 November 2026 and compare your results with the figures on this page.
How do I make a project tracker in Google Sheets? Choose File, then Import, pick the task tracker CSV and choose Create new spreadsheet. Add the Status dropdown, the days late formula and the two conditional formatting rules. The formulas are the same as in Excel.
Why do my formulas return an error or zero? Usually the dates came in as text. Type =ISTEXT(F2) in a spare cell: TRUE means the date is text. Retype it, or convert it with =DATEVALUE(F2) in a helper column formatted as a date.
Start your workspace