🎉 Black Friday Sale: 40% OFF everything with code BF40 · ends 1 Dec  Shop now →

Free Gantt Chart Template in Google Sheets

₹0.00
Details, requirements and demo below

Free Gantt Chart Template in Google Sheets

₹0.00

A free Gantt chart template for Google Sheets: bars colour themselves by status, a today line moves every day, one-cell SPARKLINE bars and progress cards. Make a copy in one click, no add-ons.

- +
,
Most popular paid version
Task Management Tracker in Google Sheets
Original price was: ₹1,499.00.Current price is: ₹699.00.  ·  use code FIRST10 for 10% off your first order.
See the dashboard →
Pricing country
Prices follow your selected country; checkout uses your billing country.
Google Sheets Complete Course: Beginner to Advanced courseLaunch offer
🎓 NEXTGENTEMPLATES ACADEMY
Want to build Google Sheets like this yourself?
Google Sheets Complete Course: Beginner to Advanced

Formulas, lookups, QUERY, dynamic arrays, pivot tables, charts, live data and Apps Script, ending with an interactive sales dashboard. 74 lessons by PK with a practice file for every lesson.

The Free Gantt Chart Template in Google Sheets turns a plain task list into a colour-coded project timeline. Type a start date, an end date and a % done for each task, and the bars, the status, the today line and the progress cards update on their own. If you searched for a gantt chart Google Sheets users can copy in one click and start using, this is it.

It is 100% free. It is the lighter version of our paid Google Sheets project planners, so you can see how a NextGenTemplates file works before you pay for anything. Setup takes about five minutes: make a copy, replace the sample tasks with yours and type the % done.

Join 10,000+ customers in 180+ countries who use NextGenTemplates spreadsheets to plan their projects and run their businesses.

Free download  |  Google Sheets  |  Make a copy in one click  |  No add-ons, no scripts

Key features of this free Gantt chart template

  • Bars that colour themselves by status. Green for Done, blue for In Progress, red for Late (past the end date and not 100%) and grey for Not Started. All of it is conditional formatting, so there is nothing to colour by hand.
  • Automatic status. The Status column reads the dates and the % done with one IF formula, so every task shows Done, In Progress, Late or Not Started.
  • Today line. A red column and a small marker show today on the timeline. They move by themselves every day because they use TODAY().
  • 8-week daily timeline. The timeline starts on the Monday of the first task week and shows 56 days, one column per day, with week labels on top and weekends shaded.
  • One-cell SPARKLINE bar. Next to each task, a single SPARKLINE formula draws a mini Gantt bar in one cell, coloured by status.
  • Progress KPI cards. Cards at the top count the tasks, how many are done, running and late, and the overall % complete weighted by task days.
  • How to Build tab. Every formula and conditional formatting rule is written out, so you can rebuild this Google Sheets gantt chart template from a blank sheet.

What is inside the file

TabWhat it does
How to useSix short steps to set up the template and notes on the timeline and today line
GanttTask list (task, phase, owner, start, end, days, % done, status), the one-cell timeline bar, the 8-week Gantt chart and the progress cards
How to BuildThe exact formulas and conditional formatting rules, step by step
Get the Full VersionLinks to the paid Google Sheets project planners when you need more

The sample data is fictional. It shows a small digital studio planning the launch of an online store: 16 tasks from early November to mid-December across Discovery, Design, Build, Content and Launch phases. Replace it with your own tasks.

How to use it in three steps

  1. Make a copy. Download the free PDF and click Make a copy in Google Sheets. The copy goes into your own Google Drive.
  2. Add your tasks. On the Gantt tab, type each task, its phase, owner, start date and end date. The days and the timeline fill in by themselves.
  3. Update the % done. Type the % done in the yellow column as work moves. The bars, the status, the today line and the cards update straight away.

Who this project timeline template is for

Freelancers, small agencies, team leads, students and small business owners who need a simple project timeline template in Google Sheets that the whole team can open in a browser. If you plan up to about 20 tasks over a couple of months, this free Gantt chart template is all you need.

When it makes sense to upgrade

The free template covers one project and an 8-week window. If you need more, these paid Google Sheets files go further:

Frequently asked questions

Is this Gantt chart template really free?

Yes. It costs nothing to download and you can copy it as many times as you need.

How do I get the template into my Google Drive?

The download is a short PDF with a Make a copy button. Click it while signed in to Google and Google Sheets makes your own editable copy.

Does it need add-ons or Apps Script?

No. Everything is built with normal formulas (IF, SEQUENCE, SPARKLINE, COUNTIF, SUMPRODUCT) and conditional formatting, so it works in any Google account.

Can I add more tasks?

Yes. Insert rows inside the task list, above the last task, so the colour rules and cards grow with it, then copy the Days, Status and Timeline formulas down from the row above.

Can I change the timeline start?

The timeline starts on the Monday of the first task week by formula. You can overwrite that cell with any date to move the 8-week window.

Frequently asked questions

How do I get my own copy?
After purchase you get a link to the Google Sheet. Open it while signed in to your Google account and use File > Make a copy - the copy in your Google Drive is fully yours and editable.
Do I need a paid Google account? Will it expire?
No. A free Google account is enough, and your copy lives in your own Google Drive - it never expires and there is nothing to renew.
Does it work on Mac, phone or tablet?
Yes - in any browser on Windows, Mac or Chromebook, and in the Google Sheets mobile app for viewing and quick entries.
Can I share it with my team?
Yes. Share your copy with colleagues using Google's normal sharing, with view or edit rights as you choose.
Can I change the design and formulas?
Yes, your copy is fully editable - colours, labels, logo, formulas and charts. If a range is protected, use Data > Protect sheets and ranges to remove it in your copy.
Are there macros or add-ons?
No macros or add-ons - it uses normal Google Sheets formulas and charts.
Is it a one-time payment or a subscription?
One-time payment. No subscription, no per-user fees and nothing to renew - the file is yours to keep.
How do I get the file after payment?
Instantly. The download link appears on screen after checkout, is emailed to you, and stays under My Account > Downloads on our website. If the email does not arrive within a few minutes, check your spam or promotions folder.
Is a user manual included?
Most of our newer products include a PDF user manual in the download. If yours does not have one, message us with your order number and we will send it.
Do I get free updates?
Bug fixes are always free - if something does not work as described, we fix it and send you the corrected file. New versions with new features are not included in the price, unless this product's description says otherwise.
Can you customise it for me?
Yes. Small changes to this template (your columns, categories, logo, colours, minor layout) cost the template price plus $40-80 (Rs 3,000-6,000 + GST), quoted once you send your list. A fully custom build is usually $100-200 (Rs 8,000-18,000 + GST) with two revision rounds. Email your requirements to [email protected] or message us on WhatsApp.
Can I use it for my business or my clients?
Yes, for your own personal or internal business use, for as long as you like. Reselling or redistributing the template is not allowed.
What is your refund policy?
Because these are digital downloads, they are non-refundable once delivered - except when the product does not match its description (report it within 48 hours of purchase) or there is a technical problem our team cannot fix within 72 hours. Email [email protected] with your order number.
How do I get help?
Email [email protected] (Mon-Fri, 10 AM-7 PM IST) or message us on WhatsApp +91 80770 90260 (chat only, no calls). Please include your order number.

Still have a question? Click Need help? at the bottom-left to ask our assistant, or message us on WhatsApp.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

You may also like…

Free Gantt Chart Template in Google SheetsFree Gantt Chart Template in Google Sheets
₹0.00
- +
Scroll to Top