Free Gantt Chart Template (Excel & Google Sheets)

Every project manager eventually needs to answer “what happens next, and who is waiting on whom?” in a way that fits on one screen. The Gantt chart has been the standard answer for over a century — horizontal bars on a calendar showing when each task starts and ends. But commercial Gantt software can be expensive and overkill for a small project, which is why the search for a free Gantt chart template is one of the most common downloads in project management. This guide shows you what a free template contains, where to download trustworthy versions for Excel and Google Sheets, how to build your chart from the template, and exactly what free templates cannot do.

Quick Answer: What Is a Free Gantt Chart Template?

A free Gantt chart template is a pre-built spreadsheet file — usually for Excel or Google Sheets — where each row is a task, each task has a start date and a duration (or end date), and a bar chart visualizes those tasks along a calendar. You type in your own tasks and dates, and the template draws the bars for you.

The nuance: a Gantt template gives you the picture, not the logic. It will not recalculate the whole schedule when a date changes, it cannot show dependency arrows as lines, and it will not tell you which tasks are on the critical path. If your project needs that logic, you will either add formulas yourself, upgrade to a paid spreadsheet, or move to Gantt software. For a simple, stable schedule, a free template is genuinely enough.

What Does a Free Gantt Chart Template Include?

The direct answer: a usable Gantt chart template has a task worksheet with columns for WBS number, task name, start date, duration, and percent complete, plus a chart area that draws each task as a horizontal bar on a calendar with a vertical “today” line.

The best free templates add automatic WBS numbering (so inserting a row renumbers everything) and let you change the displayed date range with a scroll bar. Those two features are what separate a genuinely useful template from a glorified task list.

Where to Download a Free Gantt Chart Template

The direct answer: the most trusted free Gantt chart templates are Vertex42’s Excel Gantt chart (with a Google Sheets version), the Google Sheets template gallery, and template galleries from Smartsheet and ProjectManager.com. Each has different strengths and trade-offs.

• Vertex42 — Free Gantt Chart Template (Excel + Google Sheets). One of the oldest and most downloaded free Gantt spreadsheets. Each row is a task; you define start date and duration, copy rows to add tasks, edit the % Complete column to shade bars, and a vertical red line marks the current date. It uses automatic WBS numbering formulas. Pros: no macros, no installation, private-use free license, works in Excel 2010 or later and in Google Sheets. Cons: adding dependencies requires formulas you write yourself; the chart does not recalculate the schedule for you; for heavy use you are pushed toward its paid “Pro” version.
• Google Sheets template gallery. Includes a basic project/Gantt-style template that opens directly in your browser and supports real-time collaboration. Pros: free, no install, shareable with one link. Cons: the built-in option is minimal; you will likely adapt it (add a today line, WBS numbers, or % complete) yourself.
• Smartsheet templates. A large gallery of Gantt and project schedule templates; you can copy them free if you have a Smartsheet account (free trial available). Pros: polished, industry-specific variants, better for teams that want structured columns. Cons: built to funnel you toward a paid plan; the free tier limits how many sheets you can keep active.
• ProjectManager.com. Publishes free Gantt chart and schedule templates designed by practitioners. Pros: professional layout and clear guidance. Cons: expects sign-up; the templates are stepping stones to its paid tool.
• Microsoft Project (not a template, but relevant). The heavyweight desktop tool for Gantt schedules with full dependency and critical-path logic. Pros: the standard for complex scheduling. Cons: paid and heavy; unnecessary for a simple project that a spreadsheet handles fine.

The honest trade-off: free spreadsheet Gantt templates are static models. They are perfect when your schedule is simple and you update it weekly. The moment you need linked tasks that move together, you are doing that work in Excel with formulas — which is doable, but it is engineering, not template use.

How to Create a Gantt Chart From a Template

The direct answer: enter your tasks, start dates, and durations into the worksheet, let the template draw the bars, then keep the % Complete column honest and check the today line weekly.

1. List your tasks at the right level of detail. A Gantt chart works best with 10–40 tasks. If you have more, group them under summary tasks (phase 1, phase 2) and keep micro-tasks in a task list.
2. Enter a start date and duration for each task. The template calculates the end date. Use real dates, not week numbers.
3. Insert rows to add tasks. A good template renumbers automatically, so copy or insert rows and let the WBS formulas fix themselves.
4. Add dependencies with simple formulas. The classic three: start the next day after a predecessor (`=end_cell + 1`), start the same day (`=start_cell`), or start the next working day (`=WORKDAY(end_cell, 1)`). For a visual predecessor list, add a column that records the predecessor’s WBS number.
5. Set % Complete honestly. The bar shading should reflect reality — 50% on a task that is 20% done is how charts lie.
6. Adjust the visible date range. Use the template’s scroll bar or axis bounds so the chart shows your project window, not a year of empty space.
7. Update weekly. Block 15 minutes each week to move bars and refresh %. A chart that is two weeks stale is worse than no chart.

A worked example: 10-week marketing campaign

Here is a realistic mini-Gantt for a product launch campaign, in template terms:

At review on Sep 29, the today line sits between “Channel booking” (50%) and “Paid ads setup” (0%). Content production is 80% on a 15-day task with 2 days left — a flag to check before it slips. That is exactly the conversation a good Gantt chart forces you to have.

Free Gantt Chart Template vs Gantt Software

The direct answer: free templates cost time in manual upkeep and cannot model dependencies or the critical path; Gantt software recalculates the schedule from live task data but costs money and setup.

Use the free template when the project is small (under ~20 tasks), the dates are fairly stable, and one person owns the upkeep. Move to software when teams overlap, dates move weekly, or stakeholders keep asking “what would happen if X slipped?” — because a free template cannot answer that question, and answering it by hand takes longer than the tool costs.

Three Real Scenarios With Numbers

Scenario 1: A 5-person internal project (free template is ideal). A small ops team runs an 8-week process-improvement project: 12 tasks, mostly sequential, one coordinator. They use a free Excel Gantt template, update it for 10 minutes every Friday, and present it in the Monday stand-up. Total cost: about 2 hours across the project. Buying Gantt software for this would be pure waste.

Scenario 2: A 14-week software rollout with linked tasks (free template strains). A team of 8 delivers a customer portal where development, integration, and testing overlap and depend on each other. The coordinator writes predecessor formulas for the 5 critical hand-offs, and it works — until the API task slips a week, and the coordinator manually shifts three downstream tasks and re-checks every bar. That takes an hour and is repeated every time anything moves. A tool that recalculates the chain instantly would save roughly 3–4 hours per slip.

Scenario 3: A 6-month construction-style schedule (need real software). A contractor sequences design, permits, demolition, structural work, MEP, and finishing, where float and the critical path decide whether the deadline holds. A free template cannot show float, and the manual rework of a 45-row schedule is weeks of effort. This is the clear case for CPM-based or dedicated Gantt software.

Common Mistakes

• Never updating the chart. A Gantt chart is a control instrument, not a document. If the % Complete column is untouched for two weeks, the chart is fiction.
• Skipping dependencies. Bars with no order are a list, not a schedule. At minimum record predecessors so a delay has an owner.
• Overloading the chart. 80 tasks with 40 dependency links become an unreadable tangle. Keep micro-tasks out of the Gantt.
• Believing the dates. The chart is a plan, not a promise. Uncertain estimates deserve buffers, especially before the critical path.
• Using a Gantt for work with no schedule. A support queue or ideation phase on a Gantt chart is theater. Use a Kanban board for flexible flow.
• Ignoring the today line. The red line is the whole point: everything left of it should be done. If unshaded bars sit to the left of the line, explain them now, not at the deadline.
• Forgetting who owns the chart. No single owner means it gets updated by nobody.

Know This Before You Choose

• Do my tasks have real durations and a meaningful order, or is the work flexible and changing daily?
• Can I name the critical hand-offs — what must finish before what starts?
• Will one person commit to updating the chart weekly, or will it go stale?
• Do I need to answer “what if X slips?” — if yes, a free template cannot do it alone.
• Is my project under ~20 tasks, or do I need a CPM-based tool?
• Do my stakeholders read spreadsheets, or do they need the visual in a shared app?

Run Your Gantt Chart Inside a Project Management Tool

The moment your schedule lives as real tasks with owners and due dates, the Gantt chart stops being something you maintain and becomes a view the tool generates — move a task’s due date, and its bar, its dependencies, and its downstream dates update in one action, which is precisely what a free spreadsheet cannot do. To be transparent: Doitify is our product, which is why we know its capabilities from the inside. It builds Gantt chart views from your projects, tasks, sub-tasks, WBS-based dependencies, milestones, and schedules in one workspace, alongside calendars, Kanban boards, roadmaps, and workload management. Whatever you choose, apply the same test: is the chart generated from live task data, or is someone redrawing it by hand every week?

Conclusion

A free Gantt chart template is the fastest way to turn a task list into a schedule your team and stakeholders can read: enter tasks, start dates, and durations, and the bars draw themselves — including percent complete and the today line that tells you whether the plan is alive. Start free, keep the chart simple, and respect the weekly update. The instant your project grows dependencies that move together, or someone asks “what if this slips?”, graduate to a tool that generates the chart from live task data so the schedule never lies again. Download a trusted template, type in your first ten tasks, and you will have a working Gantt chart before lunch. Explore our project management templates to see how the same schedule runs in a unified workspace with Gantt views, dependencies, and milestones.