How to Build a Timeline in Google Sheets

Google Sheets gives you two ways to turn a list of dates into a timeline: the built-in timeline view, and a stacked bar chart that you format to look like one. Which one you can use depends on your Google account. This guide walks through both, then shows how to bring the same spreadsheet into Preceden when you need a timeline that is easier to read and share.

Set up your data

Whichever method you choose, start with one row per task or event and a column for each date. Here is a small website launch plan we'll use as the example:

Task	Start	End
Research	3/2/2026	3/13/2026
Design	3/16/2026	4/3/2026
Build	4/6/2026	5/15/2026
Testing	5/11/2026	5/22/2026
Launch	5/26/2026	5/27/2026

Make sure Sheets recognizes the dates as dates and not as text. Select the Start and End columns, then click Format, Number, Date. A date that stays left-aligned after that is usually being treated as text, so retype it before you go on.

Option 1: Use the timeline view

The timeline view is a feature Google added to Sheets in 2022. It shows each row as a card on a scrollable calendar, which works well for project plans and schedules.

To create one:

1. Select the cells with your data, including the header row.
2. Click Insert, then Timeline.
3. Confirm the data range and click OK.

Sheets adds the timeline on its own tab. In its settings, choose which column holds the card title, the start date and the end date. You can also color the cards and group them by another column, such as the person responsible for each task.

A few things to know:

• You need at least one column of dates, and each row's start date has to come before its end date. A row with the same start and end date gets a card with no length, which is why our Launch row ends a day later.
• You can switch the scale between days, weeks, months, quarters, years and a five-year view, and print the timeline from its tab with File, Print.
• The timeline view is only available on certain Google Workspace plans, including Business Starter, Business Standard, Business Plus, the Enterprise plans and the Education plans. If you use a free personal Google account, you won't see Timeline in the Insert menu, so use Option 2 instead.

Option 2: Build a stacked bar chart

This method works in any Google account. The trick is to stack two bars for each task: an invisible one that pushes the visible bar out to the task's start date, and a visible one as long as the task.

1. Add a fourth column called Duration with the formula =C2-B2 in the first row, and fill it down. Format the column as a plain number so it shows days rather than a date.
2. Select the Task, Start and Duration columns (hold Ctrl, or Cmd on a Mac, to skip the End column).
3. Click Insert, then Chart. In the Chart editor, set the chart type to Stacked bar chart.
4. In the Chart editor, open Customize, then Series. Choose the Start series and set its fill opacity to 0%. The bars that remain begin on each task's start date.

Sheets stores dates as numbers, so you may need to adjust the horizontal axis before its labels read as dates. You can also give the chart a title and change the bar color under Customize.

The chart is a reasonable fit for a short project plan, but it has limits. A one-day event like a launch or a deadline shows up as a sliver or not at all, there is no simple way to mark a single date as a point, and labels get crowded as the list grows. If what you are after is a schedule of tasks, see our guide to making a Gantt chart in Google Sheets.

Option 3: Import your sheet into Preceden

If your timeline needs to hold milestones next to long tasks, span years or centuries, or look good on a slide, it can be quicker to build it in a dedicated tool. Preceden can import a spreadsheet you've already made in Google Sheets.

Preceden imports files rather than links, so first click File, Download in Google Sheets and choose Microsoft Excel (.xlsx) or Comma-separated values (.csv). The file needs eight columns with these headings, in this order: layer_name, event_id, event_name, notes, start_date, end_date, icon and color.

Only layername, eventname and startdate need values. For the example plan, you could put "Website" in every layername cell, copy the Task column into eventname and the dates into startdate and enddate, and leave the other columns empty. Leave enddate blank for a one-day event like the launch and Preceden shows it as a single icon instead of a bar. Layers are rows on the timeline, so you could also give each team or each phase its own layer.

Then, in Preceden, click Share above your timeline, choose Spreadsheet, expand Spreadsheet Import and click Import a Spreadsheet. Our CSV and Excel import guide covers the format in detail, including which date formats work. Importing is part of our paid plans. On the free plan you can still add events by hand or with the Bulk Editor, which works like a spreadsheet.

Once the events are in, you can zoom out to see the whole timeline or in on a single stretch of it, add notes and images to events, and export the timeline as a PDF, an image, a PowerPoint file or a spreadsheet, or share it with a link.

Which one should you use?

• If you have a Google Workspace plan and want to manage a schedule inside your spreadsheet, use the timeline view.
• If you have a personal Google account and a short list of tasks, a stacked bar chart will do.
• If you need milestones, many events, or a timeline to present or share, import your sheet into [Preceden](/).