Free XLSX template
Free Project Tracker Excel template
Track tasks, owners, dates, status and manual progress. Download an original XLSX workbook or make it your own in the online editor.
Download original XLSXMake your workbook
| 1 | ID | Task | Owner | Start | Due | Status | Percent Complete | Duration Days | Notes |
|---|---|---|---|---|---|---|---|---|---|
| 2 | T-001 | Draft plan | Alex | 2026-10-11 | 2026-10-13 | In progress | 50.0% | =IF(OR(D2="",E2=""),"",E2-D2+1) | Fictional task |
| 3 | =IF(OR(D3="",E3=""),"",E3-D3+1) | ||||||||
| 4 | =IF(OR(D4="",E4=""),"",E4-D4+1) | ||||||||
| 5 | =IF(OR(D5="",E5=""),"",E5-D5+1) | ||||||||
| 6 | =IF(OR(D6="",E6=""),"",E6-D6+1) | ||||||||
| 7 | =IF(OR(D7="",E7=""),"",E7-D7+1) | ||||||||
| 8 | =IF(OR(D8="",E8=""),"",E8-D8+1) | ||||||||
| 9 | =IF(OR(D9="",E9=""),"",E9-D9+1) | ||||||||
| 10 | =IF(OR(D10="",E10=""),"",E10-D10+1) | ||||||||
| 11 | =IF(OR(D11="",E11=""),"",E11-D11+1) | ||||||||
| 12 | =IF(OR(D12="",E12=""),"",E12-D12+1) |
First 12 rows and 9 columns of Tasks. Formula cells show their expressions; generate the workbook to see calculated results.
What is in this workbook?
- Tasks: ID, Task, Owner, Start, Due, Status, Percent Complete, Duration Days, Notes
- Summary
- Instructions
How to use the project tracker template
- Choose blank content or keep the fictional example, then set the dates and size you need.
- Generate the workbook and download it, or open it in the editor to enter your own details.
- Keep formula cells when replacing examples. Supported formulas update when you edit their inputs. Check any calculation diagnostics, then save your XLSX file.
Things to know
Manual progress; no automatic dependency scheduling or resource optimization.
Dates are stored in Excel’s 1900 date system. Currency options change display formatting only. Each workbook includes an Instructions sheet.
Browse all twelve templates