Skip to content
The title slide and first slides of the Task Tracker template

Task Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
3
Style
Bold
Difficulty
Beginner
Updated
November 6, 2026

Every slide (3)

Overview

This task tracker gives you one list for personal or team tasks. Each task has a done tick box, a category, a priority and a due date. The Tasks tab is where you add tasks and tick them off, and the Summary tab shows open and done tasks by category, plus the high-priority items still open.

It comes with sample data for a home and work to-do list. Make a copy, replace the sample rows with your own, and the counts and charts update on their own as you tick tasks off.

Useful for

  • Managing a personal to-do list for the week
  • Keeping a small team's tasks in one place
  • Seeing how much of a list is finished

What's included

  • 3 tabs: Summary, Tasks, How to use
  • Summary: a dashboard with 4 summary figures
  • Tasks: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Tasks tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Is this Task Tracker template free?

Yes. The Task Tracker template is free to download and use. Make a copy in Google Sheets or download the Excel file.

Does it work in Excel?

Yes. Download the .xlsx file and open it in Excel, Google Sheets or another compatible spreadsheet app. The tick boxes and summary work in both.

Can I add my own categories?

Yes. Add the new category to the Category dropdown on the Tasks tab (Data → Data validation), then add a row for it in the Summary breakdown so its totals show.

  • #project-tracker
  • #task-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More project tracker templates

See all 5

Also in Project management

All project management templates
Get this template

Preparing your template…