This Automatic Weekly Gantt Chart is a powerful and easy-to-use Google Sheets Template to manage a Project Timeline or Task Tracker.
Find out more on YouTube
The Weekly Gantt Chart will automatically display the duration of tasks based on the start and end dates in your chosen colour by week number so that you can track tasks over weeks.
If you're looking for a Gantt Chart visualised by day, check out this template: Automatic Gantt Chart Template
As you mark tasks as complete, the Gantt Chart will automatically update to hide past dates and show new dates at the end of the chart. You’ll never need to add new columns at the end, as the chart will constantly update as you progress through your tasks.
You can also visualise your progress on each task with the mini progress bar chart and filter the tasks to drill down to view essential information.
This Google Sheets template includes only two tabs: the main Gantt Chart and a settings tab to make everything work. It's effortless to use; just add your tasks and dates to see the timeline come to life, then update your progress to visualise task completion.
Instructions on how to use this template are included with the download link, which will be emailed to you following a purchase.
The language of this Google Sheets template is English.
Please note: This Google Sheet is not compatible with Microsoft Excel since it uses Google Apps Script to run the automation; plus, it also contains functions only found in Google Sheets, such as the QUERY function.
Automatic Weekly Gantt Chart Template
Easter 2026
Reviews
I was looking for a Gantt chart to help me project manage myself, and several activities I'm coordinating. I am hesitant to pay for a SAAS solution for such a simple tool. (Monday.com, etc.) Especially when I read that some do not allow you to export the chart via PDF. I loved the experience of buying this product and customizing it for my needs. Then, when I wanted an extra column, I submitted the form on this website and someone responded within 12 hours. Spectacular customer service!!
I needed to present a project timeline to colleagues, and I needed to do so on short notice. I was making my own Google Sheet with the help of Spreadsheetwise's tutorial on YouTube, and I was admiring the cleverness of the build instructions; but then realized my time was better spent filling out the Gantt chart and not recreating what was $8 and a click away...Super grateful people make such things, and make them available for cheap!
This template has been a lifesaver. This is the best weekly template I found. We were bringing new personnel into our organization and this has helped us to organize our onboarding project quickly and efficiently. The automation is simply perfect.
Thank you so much!
I’d watched several tutorials on how to make a Gantt chart, then came upon this one. I’m a newbie so I felt like trying to build it from scratch was too steep a learning curve, so I decided to buy the template. It was so worth it! It’s super easy to use, and when I needed to add extra rows the customer service was impeccable. Highly recommended. Thank you for making my life easier!
I was looking for something simple and visually compelling. This template does the trick in spades! Easy to populate and manage. I had a couple of questions for the developer along the way and received feedback within 24 hours both time.
I wouldn't hesitate to recommend!