Project Tracker
Tasks, owners, deadlines and a Gantt view in one workbook.
Track a project from a single sheet: task list with owner, status, priority, dates and progress, plus a conditional-formatting Gantt chart that draws itself from the start and end dates. Overdue tasks turn red automatically.
- Price
- Free
- Your files
- Never uploaded
- Runs
- In your browser
or drag it here
· up to 50 MB · processed locally, never uploaded
Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.
Files stay on your device
What it does well
- Gantt bars drawn with conditional formatting — no images, fully dynamic
- Overdue and at-risk highlighting driven by today’s date
- Progress roll-up per phase with a completion percentage
How to use Project Tracker
- 1
Set the project start date and the timeline granularity.
- 2
Add your task list, or import it from a CSV.
- 3
Assign owners, dates and priorities.
- 4
Download the tracker with the Gantt view included.
Watch a walkthrough
Common problems and fixes
Gantt bars do not appear.
The project start date does not overlap the timeline header. Set it to the earliest task start and the grid realigns.
Every task shows as overdue.
The date column is text, so comparisons against TODAY() fail. Run the Date Formatter on it.
Frequently asked questions
More templates tools
Invoices, payroll, timesheets, budgets and dashboards — every template ships with real formulas, not screenshots, and downloads as a native .xlsx.
Browse Templates