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

Project Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (3)

Overview

This project tracker keeps every task in one list, with its owner, priority, status and due date. A row turns red when its due date has passed and the task is not done. The Dashboard counts open and done tasks by owner and by status, so you can see where the work is piling up.

It comes with sample data for a small software team. Make a copy, replace the sample rows with your own tasks, and the highlights, counts and charts update on their own. Use the Status dropdown to move tasks along.

Useful for

  • Running a small team's project list each week
  • Spotting overdue and blocked tasks before a review
  • Balancing work between owners

What's included

  • 3 tabs: Dashboard, Tasks, How to use
  • Dashboard: a dashboard with 5 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 Project Tracker template free?

Yes. The Project 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 highlights and dashboard work in both.

Why does a row turn red?

A row turns red when its due date is earlier than today and its status is not Done. Set the status to Done and the highlight goes away.

  • #project-tracker
  • #project-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…