Skip to content
The title slide and first slides of the Gantt Chart template

Gantt Chart

Spreadsheet template for Google Sheets and Excel

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

Every slide (3)

Overview

This Gantt chart template plans a project as a list of tasks, each with a phase, owner, dates, progress and status. The Plan tab draws a weekly timeline from the start dates, so you can see what runs when and where the work overlaps. The Dashboard counts tasks by status and by owner, with charts that update as the plan changes.

It comes with sample data for a software project. Make a copy, replace the sample rows with your own tasks, and the timeline, working-day counts and dashboard update on their own.

Useful for

  • Planning a software or product launch week by week
  • Showing a client when each phase of a job starts and finishes
  • Spotting tasks at risk before a deadline

What's included

  • 3 tabs: Dashboard, Plan, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Plan: 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 Plan 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 Gantt Chart template free?

Yes. The Gantt Chart 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 timeline and dashboard work in both.

How does the timeline know which weeks to show?

The timeline starts from the earliest start date on the Plan tab and runs for 20 weeks. Each bar fills the weeks between its start and end dates, and the darker part shows progress.

  • #gantt-chart
  • #gantt-chart
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More gantt chart templates

See all 4

Also in Project management

All project management templates
Get this template

Preparing your template…