What is the best free task tracker spreadsheet?

One that flags status automatically. Our free Excel task tracker template and online tool both compute on-track / at-risk / late from each task's due date and %-complete, then sort the at-risk items to the top.

Can I use it in Excel or Google Sheets?

Yes. The template is an .xlsx you can open in Excel or import into Google Sheets. The online version runs in any browser with no signup.

How does it decide a task is at risk?

A task due within 7 days and under 70% complete is flagged At risk; past its due date and under 100% is Late; 100% is Done; everything else is On track.

Task tracker spreadsheet

Updated July 2026 · free template and online tool, no signup to try.

Quick answer

The most useful task tracker spreadsheet does more than list tasks — it tells you which ones need attention. Give each task an owner, a due date and a %-complete, and it should automatically flag anything late or at risk and roll up an overall completion figure. You can download a free Excel task tracker below, or paste your tasks into our online tool and it sorts the at-risk items to the top for you.

⬇ Download the Excel templateFree .xlsx with the RAG status and %-complete formulas built in.⚡ Build one online nowAdd tasks in your browser and get status + a mini Gantt instantly. No signup.📖 Read the tutorialBuild a tracker in Excel from scratch, with the RAG formula explained.

What the template contains

Field	Example	What the tracker does with it
Task	Draft Q3 report	The item being tracked
Owner	Priya	Who to chase if it slips
Due	2026-08-01	Compares to today for days-left
% complete	40	Combines with the due date to set status
Status	At risk (auto)	Due soon and under 70% → flagged, sorted to top
Roll-up	62% overall	Average completion across all open tasks

The point of a task tracker is triage, not a longer to-do list

A flat list of tasks hides the two or three that will actually hurt you. Both the Excel template and the online tool compute an on-track / at-risk / late status from each task's due date and progress, then surface the at-risk and late ones first — so a five-minute glance tells you exactly where to spend your attention this week.

Run it on your own task list — free

Upload your spreadsheet and DataHub Pro computes the RAG status, roll-up and an AI health summary automatically.

Try DataHub Pro free →