Gantt Chart in Google Sheets: Build a Reusable Template

Yes. You can make a reusable Gantt chart in Google Sheets by listing tasks and their start and finish dates, adding a row of calendar dates, then using conditional formatting to shade the cells that fall within each task’s schedule. Google Sheets does not require a special template: start with a blank sheet or copy a suitable template, then adapt the layout to your project.

What a Gantt chart in Google Sheets shows

A Gantt chart places project tasks alongside a time scale. Each task appears as a horizontal bar spanning its planned start and finish dates, so you can see when work happens, which tasks overlap, and where deadlines fall. In a spreadsheet, the bar can be represented by colored cells in a date grid rather than by a separate chart object.

This grid approach is often what people mean by a Google Sheets Gantt chart template. It is easy to edit, share, and extend with columns for owners, status, or notes. It is also important to understand what the colored bar means: unless you add extra logic, it shows the planned schedule, not the amount of work completed or the task’s dependency on another task.

Template options and what to look for

You can build the schedule yourself, make a copy of a template shared by someone else, or look for a project-planning template in the Google Sheets template gallery. The gallery and templates available to you can vary by account and over time. A spreadsheet labeled Gantt chart may use a cell grid, a stacked bar chart, or a different layout, so check how it represents dates before entering project information.

A useful template should make the schedule understandable without hiding important assumptions. Look for these features before adopting one:

Editable task data: task names and dates should be ordinary cells, not text baked into an image.
A clear time scale: the headings should identify days, weeks, or months, and the interval should suit the project.
Visible ownership and status: optional columns for an owner, progress, or notes help explain who is responsible and what has changed.
Room to grow: you should be able to add tasks or future dates without rebuilding the whole schedule.
Understandable formatting: colors should have a clear meaning, with a legend if more than one type of bar is used.

Before using a downloaded or shared template, review its formulas, conditional-formatting rules, and sharing settings. A template is a starting point, not a guarantee that its dates, sample tasks, or permissions suit your project.

Plan the sheet layout

For a basic daily schedule, reserve column A for the task name, column B for the start date, and column C for the finish date. Add optional columns for an owner, status, or notes if the people using the sheet need them. Put calendar dates in row 1, beginning in column D, and put the first task in row 2. The date cells must contain real date values, not date-like text, for comparisons and date calculations to work reliably.

Choose the time scale before filling in a long run of dates. A daily grid is useful for a short project with precise handoffs, but it can become very wide for a year-long plan. Weekly or monthly intervals make longer plans easier to scan, although they show less detail. If tasks have different levels of precision, use one consistent scale for the overview and put exact deadlines in the task data.

For example, a small website launch might include “Write page copy,” “Build landing page,” and “Review and publish.” Give each task a start date and finish date, then add an owner and a status such as Not started, In progress, or Done. This separates the schedule itself from the information used to manage the work.

Build the date grid

In Google Sheets in a web browser, enter a starting date in D1 and format it as a date. To create the next day’s heading, with D1 holding November 1, 2026, and E1 as the next date cell, enter =D1+1 in E1 and fill it to the right. The result in E1 is November 2, 2026. You can select the row of dates and use Format > Number to choose a date display that fits, such as a short date.

Keep the underlying values as dates even if you display only a weekday or a short label. If headings are plain text such as Mon or Nov 2, a conditional-formatting rule may compare text rather than dates and fail to shade the intended cells. You can also freeze the task headings so they stay visible while scrolling: use View > Freeze and choose the appropriate rows or columns for your layout.

To calculate the number of calendar days in a task, with its start date in B2 and finish date in C2, enter =C2-B2+1 in another column. If B2 is November 4, 2026, and C2 is November 6, 2026, the result is 3 days because the count includes both the first and last date. Label the column clearly; a calendar-day duration is not the same as a count of working days.

Color task bars with conditional formatting

Select the grid where the bars should appear, for example D2:AH20, then choose Format > Conditional formatting. Under Format cells if, choose Custom formula is. With task names in A, start dates in B, finish dates in C, and date headings in row 1, use this rule:

=AND($A2<>"",D$1>=$B2,D$1<=$C2)

Choose a fill color and select Done. The dollar signs keep the task and date references aligned as the rule evaluates each cell: the task row changes as the rule moves down, while the date heading changes as it moves across. The rule shades a cell when its heading date is on or after the task’s start and on or before its finish. For a task beginning November 4 and ending November 6, the three corresponding daily cells are colored, including both endpoints.

If the selected range starts in a different column or row, adjust the formula’s relative references to match the first cell of that range. Check that start and finish dates are valid and that the finish is not earlier than the start. If no cells shade, verify the applied range, the date values, and the row and column references in the rule before changing the color.

Add status, progress, and dependencies

A colored schedule bar alone does not show whether a task is complete. Add a Status column and update it as work proceeds, or add a Percent complete column if the team can maintain a consistent estimate. Use distinct colors only when they communicate a defined distinction, such as planned work versus completed work. Add a small legend so readers do not have to guess what each color means.

Dependencies need extra care. If “Review and publish” cannot begin until “Build landing page” is finished, record that relationship in a dependency or predecessor column, or write it in a notes field. A basic conditional-formatting Gantt grid will not automatically reschedule later tasks when an earlier finish date changes. Anyone maintaining the plan must update affected dates, unless the template contains additional formulas or automation designed to calculate them.

For a shared project sheet, agree on who can edit the schedule and how often it will be updated. Use Google Sheets’ sharing controls to give collaborators the access they need, and avoid treating an old copy as the current plan. Clear ownership and update habits matter as much as the color scheme.

Common problems and practical fixes

The bars are missing or misplaced: confirm the date headings and task dates are date values, then check the conditional-formatting range and formula references.
A one-day task looks blank: check that the start and finish dates are equal and that the rule includes both boundaries with greater-than-or-equal and less-than-or-equal comparisons.
Dates move when copied: review the dollar signs in the custom formula. They keep selected row or column references fixed while the rule fills across the grid.
The sheet is too wide: use weekly or monthly headings, split a long project into phases, or show a shorter planning window and extend it when needed.
Colors are hard to interpret: reduce the number of colors, add a legend, and use status text so meaning does not depend on color alone.

A common misconception is that every Gantt chart must be made with Google Sheets’ Insert > Chart command. A date grid with conditional formatting is a practical Gantt-style schedule even though it is not a chart object. Google Sheets also has a Timeline view that may be available through Insert > Timeline for eligible accounts and suitable data. Its availability can depend on the account or plan, so check whether that option appears in your sheet. Timeline view is separate from the manually formatted grid described here.

Google Sheets compared with Excel and other tools

The cell-grid method is useful when several people need to edit task details together and the plan is modest in size. Google Sheets runs in a browser and supports sharing and collaboration through Google accounts. Excel can create a similar conditional-formatting grid, but the steps differ: in Excel for Microsoft 365 on Windows, the comparable rule is set through Home > Conditional Formatting > New Rule, then the option to use a formula to determine which cells to format. The Google Sheets menu paths above are not Excel menu paths.

For projects with many linked tasks, frequent changes, workload balancing, or formal reporting, dedicated project-management software may be a better fit. Such tools may provide dependency handling, notifications, or resource views, but the available features and costs vary. Choose based on the work you need to manage rather than assuming that a more elaborate tool will automatically keep the plan accurate.

Frequently Asked Questions

Does Google Sheets have a built-in Gantt chart template?
There may be project templates in the Sheets template gallery, but availability and names can vary. You can also make a Gantt-style schedule from a blank sheet with task dates, a date grid, and conditional formatting.

Can I make a Gantt chart in Google Sheets for free?
A basic grid can be made with standard spreadsheet features. Whether a particular account, sharing option, or Timeline view is available depends on the Google account and its current plan or settings; check the options shown in your account.

How do I show weekends in a Google Sheets Gantt chart?
Include weekend dates in the header row as usual. You can leave them in the same color as weekdays or apply a separate visual treatment to the header, while keeping the task-bar rule based on the actual dates.

Can a Google Sheets Gantt chart update task dates automatically?
A basic conditional-formatting grid updates its bars when you edit the dates, but it does not automatically shift dependent tasks. Automatic scheduling requires additional formulas or automation and careful testing of the project’s dependency rules.

Should I use a chart or conditional formatting?
Use conditional formatting when you want an editable calendar grid that lines up directly with task rows. Consider a chart or Timeline view when its presentation suits your data and is available, but confirm that it supports the level of scheduling detail you need.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.