Home › Projects & Work › Task Tracker Spreadsheet & To-Do List

The Task Tracker spreadsheet for Excel and Google Sheets, a task manager and to do list for small business, freelancers and small teams. A preview shows the dashboard with open tasks, due today, overdue, due this week and charts by status, priority, due date and assignee.

Task Tracker Spreadsheet & To-Do List

A to-do list is more useful when it tells you what is due and what is late. In the Task Tracker you list your tasks with a priority, a status and a due date, and the sheet shows the days left and a color-coded heads-up.

Repeating tasks get a next due date, an Upcoming view puts open tasks in date order with overdue ones first, and the Dashboard counts what is open, due today, overdue and due this week.

It is a digital download for Excel and Google Sheets, made for individuals, small teams and small businesses.

View on Etsy

Digital download. Works in Excel and Google Sheets. Nothing is shipped.

What this spreadsheet tracks

Up to 1,000 tasks with category, assignee, priority, status, start and due dates
Days left and a heads-up for every task
Repeating tasks with the next due date
An Upcoming view, overdue first
Up to 30 assignees with open, overdue, due this week and completed tasks
Up to 20 categories you can rename, and a dashboard with 8 tiles and 4 charts

Who it's for

Individuals who want a simple task list with deadlines
Small teams that share work between a few people
Small business owners who track recurring jobs

How it works

Add your name or team on Start Here (optional).
List your tasks with a category, priority, status and due date.
Set Repeats on tasks that come back.
Open the Dashboard and Upcoming to see what to do next.

See inside

Task dashboard with 8 summary tiles (open tasks, due today, overdue, due this week, completed, high priority, recurring and data warnings), 4 charts and two tables listing the overdue tasks and the next tasks coming due.

Tasks tab with one row per task: category, assignee, priority, status, start date, due date, repeats, last completed and notes, plus days left and a color-coded heads-up such as Overdue, Due today and Due this week.

Upcoming tab listing open tasks by due date with overdue tasks first, showing days left, heads-up, assignee, priority, status, category and repeats.

Recurring Tasks tab listing repeating tasks (daily, weekly, monthly, quarterly or yearly) with the next due date calculated from the last completed date.

Assignees tab with up to 30 people and, for each, open tasks, overdue tasks, tasks due this week, completed tasks and total, plus an Unassigned row and a total.

Categories tab with up to 20 renamable categories and, for each, the number of open, completed and total tasks, plus a No category row and a total.

List of the 7 tabs included in The Task Tracker and three steps: download, add your tasks, then read what is due. Task tracking helper, no macros, no subscription, digital download.

Frequently asked questions

Does it work in Excel and Google Sheets?

Yes. You get an Excel workbook and a PDF guide with a link to make your own copy in Google Sheets. The two versions are separate files and do not sync.

Can several people use it?

You can list up to 30 assignees in one file. It is a single spreadsheet, not a shared app, so people need to edit the same file or sheet.

Does it send reminders?

No. It shows heads-ups inside the sheet but does not send emails or notifications.

Is there an example file?

Yes. A second Excel file is filled with example data, so you can see how everything works before using your own numbers.

More in Projects & Work

The Project Command Center project management spreadsheet for Excel and Google Sheets, with room for 500 tasks. A dashboard preview shows tiles for open tasks, overdue and at-risk work, project progress and team load, with labels for Projects, Tasks, Gantt, Kanban and Capacity & Risk.

Gantt Chart Template SpreadsheetPlan project timelines and tasks in a simple Gantt chart.