Free Google Sheets Gantt Chart Template

Each task has an owner, start date and end date; the duration is calculated. Add a row of week dates and one conditional-formatting rule to turn it into a visual gantt chart.

What it looks like

ABCDEF
1TaskOwnerStartEndDaysStatus
2Kickoff & scopePriya2026-11-022026-11-043Done
3RequirementsSam2026-11-052026-11-117Done
4DesignLee2026-11-122026-11-2514In progress
5BuildSam2026-11-262026-12-1621Not started
6TestingPriya2026-12-172026-12-237Not started
7LaunchLee2026-12-282026-12-281Not started
Tab: Timeline. Teal cells are live formulas; hover one to see it.

What's included

  • Duration in days calculated from start and end
  • Owner and status columns for weekly check-ins
  • Turns into a bar timeline with one conditional-formatting rule

How to set up the gantt chart template

  1. 1.Download the CSV and import it into Google Sheets.
  2. 2.In H1 enter the first Monday of the project, then in I1 enter =H1+7 and drag right for as many weeks as you need.
  3. 3.In H2 enter =AND(H$1<=$D2, H$1+6>=$C2) and fill it across and down.
  4. 4.Select the week grid, open Format → Conditional formatting, choose "Custom formula is" =H2 and pick a fill colour.
  5. 5.Hide the TRUE/FALSE text by setting the grid's text colour to match the fill.

Questions

Does Google Sheets have a built-in gantt chart?
Google Sheets has a Timeline view for tables, but a formula-based grid like this one works in every account and prints well.
Can I track dependencies?
Add a "Depends on" column and set each Start to =MAX(end of dependency)+1 so later tasks shift automatically.

More templates