Project Tracker (Excel)
Keep tasks, owners and deadlines in one sheet. Days left, overdue flags and a summary are calculated for you.
Download the template
Download project-tracker.xlsx Excel workbook (.xlsx), 14 KB. Works in Microsoft Excel, LibreOffice Calc and Google Sheets.
What is inside
- Tasks: ID, task, owner, start, end, status, percent complete, days left and an overdue flag, with data bars for progress.
- Summary: Counts by status, overdue tasks and the average completion.
Key columns and cells
- Status: Not started, In progress, Blocked or Done, from a drop-down.
- Days left: end date minus today; blank for Done tasks.
- Overdue: shows when the end date has passed and the task is not Done.
How to use it
- Replace the example task.
- Add each task with owner and dates.
- Update status and percent complete as work moves.
- Check the Summary sheet in your weekly review.
Notes and assumptions
- Done tasks count as 100% in the Summary average.
- Holds 100 tasks.
Frequently asked questions
Does it draw a Gantt chart?
Not in the sheet. The online project planner shows a simple timeline.
Why is Days left negative?
The end date has passed.