How to Make a Gantt Chart in Google Sheets (Timeline View)

A Gantt chart is simply a project plan drawn as bars across a calendar: each task has a start, an end and a place in the order. For a website build, a product launch or a client onboarding, it's the quickest way to see what overlaps and what's late.

Here's the honest bit before the steps. When I searched Google's help pages, I couldn't find an article or a chart type called Gantt chart in Sheets. What Google does document is timeline view, which draws tasks as bars between a start and an end date. That's the closest official route, so it's the one I'll walk through.

What Google Sheets gives you for a Gantt-style plan

There are two similar-sounding features, and mixing them up wastes an afternoon.

Feature	What Google's help says it does
Timeline view	Shows rows of data as cards across a time scale, using start and end dates
Timeline chart	Plots events in date order, with dates in the first column and numbers in the second

For a task plan with durations, timeline view is the one that behaves like a Gantt chart. A timeline chart is for values over time, such as a series of readings, rather than tasks that start and finish.

Setting up your task list before you build the Gantt view

Timeline view reads whatever sits in your sheet, so tidy columns matter more than any button. Google's help recommends these columns:

• Card title: the task name.
• Start date: the day the task begins.
• End date: the day it finishes.
• Card detail: any note you want to see when you open the card.
• Duration: an alternative to the end date, entered as a number of days or in hh:mm:ss format.

You need at least one column in date format. If your dates come from formulas, Google says the result has to be a real date value. It also mentions that DATEVALUE can help make sure start and end dates are the right type.

One rule catches people out. The start date for each task must be earlier than the end date, otherwise the card shows no length. A card also shows as a single day when the dates are identical or when Sheets doesn't recognise the date format.

Creating the timeline view for your Gantt chart on a computer

1. Open the spreadsheet that holds your task list in Google Sheets on a computer.
2. Click Insert at the top of the Sheets menu, then click Timeline.
3. Select your data range, or choose the range Sheets suggests.
4. Click Ok. Sheets adds a timeline view tab with your tasks as cards.

If you can't see Timeline under Insert, remember that Google lists it as available in particular Google Workspace editions, including Essentials, Business Starter, Business Standard, Business Plus, the Enterprise editions, Education editions and Frontline. A personal Google account isn't on that list, so check with your admin if you use a work or school account.

Choosing which columns drive your Gantt chart

After the tab appears, click Settings in the timeline view. Google splits the options into required and optional ones.

• Required: Card title, Data range, Start date and End date.
• Optional: Card color, Card detail and Card group.

To change one task, select its card, click Edit Data at the bottom right of the card details window and edit that row in your source tab. The timeline follows the data, so the sheet stays your single source of truth.

Card color can come from a preset list, from the colour spectrum via Customize, or from the cell background colours in a column of your source data. Google adds one warning: don't apply conditional formatting to the source data or you won't be able to change card colours.

Reading and adjusting your Google Sheets Gantt timeline

Google's customisation page lists the ways you can change how the plan looks:

• Intervals: Days, Weeks, Months, Quarters, Years and Multiyear.
• View modes: Comfortable (the default, with more space between cards) and Condensed, plus a collapsed option that shows one row per card group.
• Zoom: pick a percentage from the dropdown at the top right.
• Today: a button that jumps back to the current date.

For a long client project I'd start in Weeks to see the sequence, then flip to Months to check the big picture before showing anyone else.

Sharing and printing a Gantt chart made in Google Sheets

Timeline view can be printed from the File menu, and Google's help also mentions downloading it as a web page or PDF and publishing it to the web through File, then Share, then Publish to web. Be careful with that last one. Published means visible to people outside your team, so only use it for plans you're happy to show.

If the plan is for colleagues or a client, it's usually safer to share the sheet itself. Google also says mobile support for timeline view is for viewing it on Android and iOS, so build and edit it on a computer.

Gantt chart habits that save small business owners time

• Keep one row per task and avoid merged cells in the data range. If you want to tidy a heading row, my page on merging cells in Google Sheets covers it, but do it away from the data.
• Put owners in Card detail so the person responsible shows when you open a card.
• Use Card group for phases such as Plan, Build and Launch.
• Review it weekly. A plan nobody updates is worse than none.

If you want a simple chart of numbers next to your plan, such as tasks finished each week, my guide to making a graph in Google Sheets is the one to use.

If your Google Sheets Gantt chart won't work

1. No Timeline option under Insert: check your Workspace edition with your admin, because Google lists specific editions.
2. Tasks show as one day: make sure the start and end dates are in a date format Sheets recognises and aren't the same date.
3. A card has no length: the start date is later than or equal to the end date, so swap them.
4. Colours won't change: remove any conditional formatting from the source data.
5. Still stuck: read the error message, because Google says to follow its instructions to fix your data.

Frequently asked questions

Does Google Sheets have a Gantt chart?

I couldn't find a Gantt chart type in Google's help pages. What Google documents is timeline view, which shows tasks as cards between start and end dates and works as a Gantt-style plan.

How do I make a timeline in Google Sheets?

On a computer, click Insert, then Timeline, select your data range and click Ok. Your data needs a card title, a start date and an end date, with at least one column in date format.

Why does my timeline card show no length?

Google says the start date for each task must be earlier than the end date. If they match or the format isn't recognised, the card shows as a single day or no length at all.

Can I make a Gantt chart in the Google Sheets app?

Not in the app. Google says mobile support for timeline view is for viewing it on Android and iOS, so build and edit it on a computer.

Can I change the colours of my tasks?

Yes. Select a card and choose Card color or Customize, or set the colours in a source data column. Google warns not to use conditional formatting on the source data.