Project Tracker Template (Free Excel)
A free Excel project tracker. Track tasks, owners, due dates and progress, with overdue flags and a summary of status counts.
Download the free Excel template (.xlsx)
Free. No email or sign-up needed. One Excel file, 3 sheets.
What is inside the project tracker template
| Sheet | What it does |
|---|---|
| Tasks | 100 task rows with owner, status, priority, start, due, percent complete, days left and an automatic flag (OVERDUE, Due soon, On track, Done). |
| Summary | Counts by status, overdue tasks, average completion and a chart. |
| Read me | Short instructions. |
Yellow cells are for your own numbers and text. Green cells calculate by themselves, so do not type over them. Sample data is included so you can see how it works, then replace it with your own.
How to use it
- Download the file and open it in Excel 2010 or later. It also opens in Google Sheets and LibreOffice.
- Replace the sample data in the yellow cells with your own.
- Read the totals and results that update automatically.
- Save a copy for each month, project or client, or print it from File > Print.
The template is free to use and edit. If you want a version built around your own process, with your branding, extra sheets or automation, tell us what you need.
Free pricing tips for your business
Get short, practical tips on pricing jobs and using our free calculators. No spam, unsubscribe any time.
Frequently asked questions
How do I track a project in Excel?
List each task with an owner and dates, update status and percent complete, and watch the flags and summary.
How are overdue tasks found?
Tasks past due that are not Done are flagged OVERDUE using today date.
Is there a Gantt chart?
Use our Gantt chart template for a timeline view.
Is it free?
Yes.
Need a custom spreadsheet built for your business?
Talk to usMore free tools: All free Excel templates · Gantt chart template · Timeline template · Checklist template