Easy Ways to Create a Gantt Chart with Google Sheets (Plus Templates)


Gantt charts are the glue that holds projects together. They’re probably the most referred to document when managing a project. Project managers use them, teams are directed by them and stakeholders stay updated when they’re shared.

Since it’s such a staple of project management, there is no shortage of options out there to help you build a Gantt chart, such as an Excel sheet or a project management software tool.

Another option is using Google Sheets to create Gantt chart, seeing as Google’s free office software has become so ubiquitous in our workflows. But is making a Google Sheet Gantt Chart the right move, and are the features worth it to make up for the difficulty? Let’s find out!

A screenshot of a gantt chart in ProjectManager.com

ProjectManager.com’s Gantt charts are perfect for managing your projects from start to finish. Try it free today!

Gantt Chart in Google Sheets

A Gantt chart is a visual tool that helps plan and schedule projects. It’s basically a bar chart that breaks down the project’s tasks and places them on a timeline in chronological order. Gantt charts are used by project managers to see the entire project in one place.

The advantage of a Gantt chart is that every task is identified and shown at the point it will start and then its due date. This creates a step-by-step view of how the project will proceed. It’s the tool that builds the plan, and then schedules the activities needed to successfully complete the project.

Google Sheets is Google’s version of a spreadsheet; its direct competitor is Microsoft Excel. The major difference between the two is that Google’s software is a cloud-based free tool. Another difference is that Google Sheets is built for collaboration.

Why Make a Gantt Chart in Google Sheets?

Unlike an Excel spreadsheet that is stored locally on your computer, a Google Sheet is instead stored in the cloud. Therefore, you can easily share it with anyone by sending them a link. You can then decide if the document is view-only or if the person has editing privileges.

If you’re working on a project and require that team members have access to the Gantt chart to update it as their task statuses change, then Google Sheets is a better option for making a Gantt chart than an Excel spreadsheet. The last thing you want is to have many versions of your Gantt chart floating around. The potential confusion that can arise from this can cost you time and money when managing a project.

The fact that Google Sheets seamlessly integrates with all the other Google products, such as Docs, Gmail and more, makes it a popular choice for people who are already using Google’s suite of tools and want to collaborate in real-time.

A Google Sheet is just another spreadsheet, and a Gantt chart is made up of a spreadsheet on its left side with the timeline occupying the right side. Most Gantt chart makers are going to cost you money to use, but Google is free, which is in and of itself an advantage to using it. That doesn’t mean a Google Sheet Gantt chart is perfect, though.

Google Sheet Gantt Chart: Pros & Cons

Making a Gantt chart in Google Sheets is a great free alternative to Excel or more robust project management software. There are some downsides however, which can possibly make Google Sheets a less than ideal solution for your needs.

Here are some of the advantages and disadvantages to creating a Gantt chart in Google sheets:

Reasons to Make a Gantt Chart in Google Sheets

  • It’s a free offering.
  • The software is easy to use and can learn quickly.
  • Your work is easily shareable through links.
  • A Google Sheet Gantt chart is fully integrated with other Google products.

Reasons Not to Make a Gantt Chart in Google Sheets

  • It’s not great with complex projects.
  • You can’t set milestones on a Gantt chart in Google sheets.
  • You’re not able to link dependent tasks on your Gantt chart.
  • A Google sheet won’t let you manage resources and costs.
  • You won’t be able to assign tasks in a central platform.
  • You have to manually update your sheet to show progress.

Making a Gantt chart on Google Sheets is fine if you’re managing a simple project and already using other Google tools. However, if you’re managing a more complicated project or just want to have integrated features to track, monitor and report on your progress and performance, you’ll have to use a real Gantt chart.

Making a Gantt Chart with ProjectManager.com

If you’re looking for a Gantt chart that’s easy to make, update and works with all the features you need to manage your project, you need project management software. ProjectManager.com is an award-winning project management software that has interactive Gantt charts to help you plan and schedule your project.

Creating a Gantt chart in our tool is simple and free for 30 days, and far more dynamic than what Google offers. To follow along, try ProjectManager.com for free by clicking here, and if you like it, there are three tiers to subscribe to after your 30-day trial is over.

1. Import Your Google Sheet Gantt Chart

Export your Google Sheet Gantt chart as an Excel spreadsheet, and import it into our tool. You can also use one of our industry-specific templates, or just add tasks to the Gantt manually. These features make it easy to make a Gantt chart in minutes.

Import a Google Sheet Gantt chart after exporting it as an Excel doc

2. Add Task Duration to the Gantt Chart

Set the start and end dates for each of the tasks and they’ll populate the Gantt timeline. The start and end dates are connected by a duration bar, which indicated progress by its shading.

adding start and end dates to your tasks on the Gantt chart

3. Link Dependencies & Set Milestones on the Timeline

Connect tasks that are dependent on other tasks to start or end to avoid bottlenecks. Then break the project into more manageable phases, or note important dates by setting milestones.

linking task dependencies on a Gantt chart

4. Assign Work and Share With Stakeholders

Start assigning tasks to your team so they know exactly what they need to work on. Plus, as they complete their tasks, progress is updated in real time so you can track your schedule. Save your Gantt as a PDF and email it to project stakeholders to keep them in the loop or you can print out a copy to use in presentations. You now have a fully functioning Gantt Chart!

Use a Gantt Chart to Assign Work and Loop In Stakeholders

Tutorials: How to Make a Google Sheet Gantt Chart

There are a lot of reasons to create a Google Sheet Gantt Chart, if you’re not ready to make the leap to a project management software. The following are some of the better tutorials online that can walk you through the steps of making a Google Sheet Gantt chart.

Gantt Chart Templates for Google Sheets

Maybe you’re still on the fence about project management software and you also don’t have the time to learn the complex steps to building your own Google Sheet Gantt chart. That’s understandable. It makes sense to explore all your options before making a decision.

While a template will only get you so far, it might be as much as you need. It also could be a good way to dip your toe into using a Gantt chart. Here are a couple of templates to download and play with or use for a project. See if they’re right for you:

  • Max Makhrov has a blog with a couple of templates to copy.
  • At Vertex42, a guide to Excel, there are templates for Gantt charts in Excel and Google Sheets

ProjectManager.com Has the Best Gantt Chart

Google Sheets will only get you so far. You can’t link dependencies, set milestones, assign your team from the Gantt, monitor their progress, easily share and collaborate to the extent that you can with ProjectManager.com.

If you find that you’ve run into a wall, it’s time to try ProjectManager.com and see what a Gantt chart can do without giving you a headache. Our award-winning project management software organizes all your tasks, your team and your project for greater efficiencies.

Gantt chart for scheduling projects

Join the tens of thousands of teams that already succeed with our tool. See why NASA, Bank of America and Ralph Lauren have chosen to use us when managing their projects. Don’t bother with Google or Excel, upload that file and get productive. Take our free 30-day trial today.

Related Posts

Deliver Your Projects
On Time and Under Budget

Start planning your projects.

Start 30-Day Free Trial