Project tracker template
A project tracker in Excel with tasks, owner, start and due dates, status, percent complete and a summary of what is late or at risk.
- ๐บ๐ธ US format ยท Letter size
- Free
Pick your options and the preview updates. The file opens in Excel, Google Sheets or Numbers.
The file is built in your browser. Nothing is uploaded or saved.
Sheets
- How to use
- Tasks: #, task, owner, priority (dropdown), start, due, status (dropdown), % complete, days left and flag (formulas from the As of cell), notes
- Summary: tasks per status, total, late, at risk and average % complete (COUNTIF, COUNTA, SUM)
Color key
- Yellow cells: fill these in
- Blue cells: formulas, leave them as they are
- Gray rows: examples you can delete
1 / 2
Project tracker: ________
| # | Task | Owner | Priority | Start | Due | Status | % complete | Days left | Flag | Notes |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Kickoff meeting | Taylor Kim | High | 2026-10-08 | 2026-10-08 | Done | 1 | (auto) | (auto) | |
| 2 | Collect requirements | Sam Park | High | 2026-10-10 | 2026-10-20 | Done | 1 | (auto) | (auto) | Signed off by Sales |
| 3 | Wireframes | Casey Nguyen | Medium | 2026-10-15 | 2026-10-21 | In progress | 0.7 | -1 | Late | Checkout flow still open |
| 4 | Vendor contract | Jordan Lee | High | 2026-10-17 | 2026-10-24 | Blocked | 0.2 | 2 | At risk | Waiting on legal review |
| 5 | Build sign-up page | Riley Chen | Medium | 2026-10-19 | 2026-11-01 | In progress | 0.3 | 10 | (auto) | |
| 6 | Write help articles | Sam Park | Low | 2026-10-27 | 2026-11-11 | Not started | 0 | 20 | (auto) | |
| (auto) | (auto) | (auto) |
Summary
| Measure | Value |
|---|---|
| Not started | (auto) |
| In progress | (auto) |
| Blocked | (auto) |
| Done | (auto) |
| Total tasks | (auto) |
| Late | (auto) |
| At risk | (auto) |
| Average % complete | (auto) |
This shows the first part of each sheet as it prints on Letter paper. The file also has a how-to sheet and formulas, and every column fits one page width when you print from Excel.
How to use it
Name the project, set the as-of date and download. Each task gets a row with an owner, a priority, start and due dates, a status from the dropdown and a % complete. The sheet counts the days left to each due date from the as-of cell and flags anything late or due within three days, so the weekly check-in starts from the flags instead of reading every row.
The Summary sheet is the one-glance view: how many tasks are in each status, how many are late or at risk, and the average % complete. Type =TODAY() in the as-of cell if you want the countdown to run itself.
Things to watch
Mark a task Done rather than deleting it, so the summary keeps the full count and the history. Blocked means someone outside the row has to act; put who and what in the notes. For the timeline view you show in a meeting, pair this with the Gantt chart template, and for the weekly write-up use the status report template.
Calculators that go with this
Frequently asked questions
Can I change the status or priority values?
Yes. Edit the dropdown lists on the Tasks sheet and rename the matching rows in column A of the Summary sheet so the names match exactly. The Done check inside the Days left formula uses the word Done, so keep that one or change it there too.
Why is Days left blank on some rows?
Either the task has no due date or its status is Done. Finished tasks do not count down, and they never show a flag.
Does it work in Google Sheets?
Yes. COUNTIF, COUNTA, SUM, IF and date subtraction work the same in Google Sheets. You may need to re-create the dropdowns.
Is what I type saved anywhere?
No. Everything stays in your browser and nothing is sent to our server. If you refresh the page it is gone, so print, save a PDF or download the DOCX when you are done.