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
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Task | Owner | Start | End | Days | Status |
| 2 | Kickoff & scope | Priya | 2026-11-02 | 2026-11-04 | 3 | Done |
| 3 | Requirements | Sam | 2026-11-05 | 2026-11-11 | 7 | Done |
| 4 | Design | Lee | 2026-11-12 | 2026-11-25 | 14 | In progress |
| 5 | Build | Sam | 2026-11-26 | 2026-12-16 | 21 | Not started |
| 6 | Testing | Priya | 2026-12-17 | 2026-12-23 | 7 | Not started |
| 7 | Launch | Lee | 2026-12-28 | 2026-12-28 | 1 | Not started |
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.Download the CSV and import it into Google Sheets.
- 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.In H2 enter =AND(H$1<=$D2, H$1+6>=$C2) and fill it across and down.
- 4.Select the week grid, open Format → Conditional formatting, choose "Custom formula is" =H2 and pick a fill colour.
- 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
Project Management Template
A lightweight task tracker for Google Sheets with owners, priorities, due dates and overall progress.
Get the templateCalendar Template 2026
A Monday-first monthly calendar for Google Sheets that rebuilds itself when you change the month.
Get the templateWeekly Schedule Template
An hour-by-hour weekly schedule for Google Sheets that counts how many hours you've booked each day.
Get the template