Neural Project InstituteProject management certification for the AI era

Templates · Project planning

Free Gantt Chart Template (Google Sheets, Excel, PDF)

A Gantt chart template shows tasks as bars on a timeline so you can see what happens when, how long it takes and where work overlaps. This one pairs a task list with a 12-week grid you shade in.

Written byProject management editorial team
  • Published
  • Google Sheets · Excel · PDF
Gantt chart template

Free download · no sign-up

Get the Gantt chart template

Pick your level and format: Google Sheets, Excel or a print-ready PDF. Spreadsheets include dropdowns, formulas and sample rows you can overwrite.

Beginner

Essential columns only, one tab. Quick to fill in.

1 tab · 12 columns

GSheetsXExcelPPDF
AdvancedMost popular

The full template with every tab, dropdowns and formulas.

1 tab · 17 columns

GSheetsXExcelPPDF
Expert

Adds a live dashboard, instructions and revision history.

1 data tab + instructions, dashboard and revision history

GSheetsXExcelPPDF

Gantt Chart Template preview

Gantt chart
TaskOwnerStartEndDaysW1W2W3W4W5W6W7W8W9W10W11W12
PlanningPM5 Jan 202616 Jan 202612■■
DesignDesign12 Jan 202630 Jan 202619■■■
BuildDev2 Feb 20266 Mar 202633■■■■■
TestingQA23 Feb 202620 Mar 202626■■■■
LaunchPM23 Mar 202627 Mar 20265◆

Sample rows are examples: replace them with your own.

What's included

  • Task list with owners, dates and auto-calculated durations
  • A 12-week grid to shade bars and milestones
  • Printable landscape PDF
  • Gantt chart: Task, Owner, Start, End, Days, W1, W2, W3, W4, W5, W6, W7, W8, W9, W10, W11, W12

How to use the Gantt chart template

  1. List tasks in the order they happen.
  2. Enter owners and start and end dates; the day count calculates automatically.
  3. Shade the weeks each task runs: type ■ or use a fill colour.
  4. Mark milestones with ◆.
  5. Update bars as dates change and share the chart in status meetings.

Tips for getting the most from it

Learn more

Frequently asked questions

What is a Gantt chart template?

A Gantt chart template is a ready-made timeline where tasks appear as horizontal bars across weeks or days, so you can see a project schedule at a glance.

Is this Gantt chart template free?

Yes. The Gantt chart template is free in Google Sheets, Excel and PDF.

How do I use the Gantt chart template in Excel?

Enter tasks and dates, then shade the week cells for each task; you can also apply conditional formatting to colour bars automatically.

Is there a Gantt chart template for Google Sheets?

Yes. Make a copy of the Google Sheets Gantt chart template and share it with your team.

Can I print the Gantt chart template?

Yes. Download the PDF Gantt chart template for a landscape printout.

How many tasks fit in a Gantt chart template?

As many as you need, but 15 to 30 rows keeps a Gantt chart readable.

Can a Gantt chart template show dependencies?

A spreadsheet Gantt chart template shows timing; for linked dependencies use a project schedule template or Gantt chart software.

What is the difference between a Gantt chart template and a project timeline template?

Both show work over time; a Gantt chart template shows every task as a bar, while a timeline highlights key events and milestones.

Is there a simple Gantt chart template for beginners?

This simple Gantt chart template only needs tasks, dates and shaded weeks; no formulas to learn.

When should I move from a Gantt chart template to software?

Move from a spreadsheet Gantt chart template to software when you need automatic rescheduling, resource views or real-time collaboration.