Skip to content
Team Task Board cover: a sample sheet with tasks, in progress and hours planned and a bar chart, beside the Dashboard and Sprint tabs

Team Task Board

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

The Team Task Board suits product, delivery and operations teams that plan work in sprints or short projects. The Sprint tab is a gantt chart: each task row has an owner, planned hours, a start date, an end date, progress and status, with a bar on a twelve-week timeline. The Dashboard shows the task count, tasks in progress, planned hours and overall progress, plus planned hours by owner and tasks by status.

The sample sprint has ten tasks for four people, running from early November into December, with a few already in review or done. Check the owner breakdown before you add work, so no one carries far more hours than the rest of the team. Update progress as each task moves forward, and set the status to In review when someone needs a check. Keep owner names identical on every row.

Useful for

  • Planning a two-week sprint across a small team
  • Checking who has the most hours before new work starts
  • Showing progress on a release to stakeholders

What's included

  • 3 tabs: Dashboard, Sprint, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Sprint: a Gantt timeline
  • 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 Sprint 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

How does the overall progress figure work?

Each task has a progress percentage, and the overall figure weights each task by its planned hours. A large task at half progress counts for more than a small one that is finished. Set progress to 100% and status to Done when a task is complete.

Can a task have more than one owner?

The Owner column takes one name, so each hour counts once. If two people share a task, name the lead owner in that column and split the planned hours into two rows, one for each person.

How do I roll the board over into sprint two?

Copy the file, clear the task rows and enter the new tasks with their dates. The twelve-week bar chart begins on the earliest start date, so the first task sets the scale. Keep the same owners and statuses so the Dashboard still works.

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

More project tracker templates

See all 8

Also in Project management

All project management templates
Get this template

Preparing your template…