Skip to content
Construction Gantt Chart cover: a sample sheet with phases, inspections passed and crew working days and a bar chart, beside the Dashboard and Schedule tabs

Construction Gantt Chart

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

This Gantt chart is for builders, renovators and owners who manage a build phase by phase. The Schedule tab gives every phase a trade, a crew, a first and last day, working days, percent complete, an Inspected tick box and a status, and draws a 24-week timeline with progress shading. The Dashboard totals the phases, inspections passed and crew working days, with charts of working days by trade and phases by status.

The sample schedule covers a small house addition, from site clearance through roofing, rough-in and drywall to final fixtures. Swap in your own phases, then update the Complete column and tick Inspected as each sign-off comes through. Phases waiting on an inspector show up on the dashboard, so the hold-ups are easy to spot.

Useful for

  • Scheduling a home addition across several crews
  • Showing a client when each build phase starts
  • Spotting phases stuck waiting on an inspection

What's included

  • 3 tabs: Dashboard, Schedule, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Schedule: 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 Schedule 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 do I show an inspection as passed?

Tick the Inspected box on that phase's row. The Inspections passed figure on the dashboard counts each ticked row, so keep the tick for phases that have a signed-off inspection.

Does the timeline include weekends?

The bars run across the calendar weeks between each phase's first and last day. Working days in the table count Monday to Friday only, which is the figure to use for crew planning.

Does the chart scale up to a commercial build?

Yes, the layout works for larger jobs too. Add more rows for each phase and split very large projects into one tab per building or floor.

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

More gantt chart templates

See all 7

Also in Project management

All project management templates
Get this template

Preparing your template…