Gantt Chart Excel Template Free Online: What to Know

Charts & pivot tables · Updated November 20, 2026

Yes. You can find free Gantt chart Excel templates online through Microsoft Create, Excel’s template gallery, and other spreadsheet-template sites. Download a workbook or open a browser-based copy, then replace the sample tasks and dates; before using a third-party file, check its source, license, and compatibility with your version of Excel.

What a Gantt chart template does

A Gantt chart is a schedule that shows tasks as horizontal bars positioned along a timeline. A typical Excel template lists task names in rows, places start and end dates or durations in nearby columns, and displays colored cells or bars across date columns. The chart makes it easier to see when work is planned, how long it may take, and which tasks overlap.

Unlike dedicated project-management software, an Excel template is usually a workbook rather than a live project system. It can be a practical choice for a small project, a class assignment, a home renovation, or a team that already uses Excel. Features depend on the workbook: some templates show only dates and bars, while others include progress, owners, milestones, or a task-dependency column.

A bar is a visual schedule, not proof that work is on track. Someone still needs to update dates and progress as circumstances change. A static screenshot or printed chart will not update when the underlying schedule changes.

Where to find a free template online

Start with Microsoft’s own template options. Microsoft Create lists templates for Microsoft applications, and Excel may also show templates from its start screen when you create a workbook. The selection and presentation can change over time, so search for terms such as “Gantt chart,” “project timeline,” or “project schedule.” A project timeline template may be useful, but check that it actually includes a task-by-task Gantt view.

Other sites offer downloadable Excel workbooks. Search results may include files in .xlsx or .xltx format, as well as templates designed for Google Sheets or another program. A file described as “free” may be free to download but subject to conditions on commercial use, redistribution, or attribution. Read the site’s license or terms rather than assuming every free download can be reused in any way.

  • Prefer a recognizable publisher or a source that clearly identifies the file format, features, and license.
  • Check the file extension. An Excel workbook is commonly .xlsx; an Excel template is commonly .xltx. A Sheets-only link may not preserve all features when converted.
  • Be cautious if a download requires an unexpected installer, asks you to enable macros without explaining why, or leads through unrelated download buttons.
  • Save the file locally or to a trusted cloud location, then open it in Excel. Do not enable macros simply to view a basic schedule.

How to choose a template that fits

Choose the simplest layout that covers the work you need to manage. A short personal schedule may need only task, start date, duration, and a timeline. A team plan may also need an owner, status, percentage complete, milestone marker, and notes. Extra columns can help, but they add maintenance and can make a compact chart harder to read.

  • Timeline scale: Daily columns suit a short plan with tightly scheduled work. Weekly or monthly columns are easier to read for longer projects.
  • Date and duration inputs: Look for clearly labeled cells and instructions about whether durations mean calendar days or working days.
  • Progress tracking: If you need to report completion, check whether the template distinguishes planned bars from progress. A colored bar alone may only show the scheduled period.
  • Milestones and dependencies: Some templates can mark a milestone or record a predecessor task, but that does not necessarily mean Excel will automatically reschedule linked tasks.
  • Capacity and printing: Check how many task rows and timeline columns are provided. A chart that looks good onscreen may need landscape orientation or scaling to print legibly.
  • Compatibility: If coworkers use Excel for the web, Mac, or older desktop versions, avoid relying on unsupported features or unfamiliar add-ins.

Before committing, open the template and try a small change: edit a task name, enter a date, and see whether the bar updates. This quick check helps reveal whether the chart is formula-driven, manually colored, or dependent on a feature that may not work in your setup.

How the Excel timeline works

Many Gantt templates use ordinary date values and conditional formatting. The task table stores a start date and a duration. Across the chart, each column represents a date. A formatting rule colors a cell when the date in its column falls within a task’s scheduled interval. Because the bars are generated from the inputs, changing a start date or duration can move or resize them.

For example, suppose the task list starts on row 5, with task start dates in column B and durations in calendar days in column C. Suppose the timeline dates begin in E4 and the chart area begins in E5. Select the chart area, then choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Use this rule:

With start dates in B5:B50, durations in C5:C50, and timeline dates in row 4 beginning at E4, the conditional-formatting formula for the selected range starting at E5 is =AND(E$4>=$B5,E$4<$B5+$C5). Choose a fill color for the rule. For a task beginning on March 3 with a duration of 4 calendar days, the bar covers March 3 through March 6; the end comparison is exclusive, which is why the formula uses start date plus duration.

The dollar signs matter: the row number for the timeline header stays fixed as the rule is applied down the task list, and the start and duration columns stay fixed as it is applied across the chart. If the selected chart range begins in a different cell, adjust the references to match. Excel for Mac has conditional formatting as well, though ribbon placement and dialog appearance can vary slightly by release. Excel for the web supports many common formatting tasks, but some workbook features and controls differ from desktop Excel.

Set up and customize a downloaded workbook

Begin by making a copy of the downloaded template so the original remains available. In Excel for Microsoft 365 on Windows, open the workbook, use File > Save As to save a working copy, and inspect the sheet for sample data, notes, and hidden assumptions. In Excel for the web, save or copy the workbook to your OneDrive before editing if you want a separate working version.

  1. Replace example task names with clear actions, such as “Approve layout” rather than a broad label such as “Design.”
  2. Enter real Excel dates in the start-date cells. A date that is stored as text may not drive formulas or sorting correctly.
  3. Set durations using the template’s stated convention. If it expects calendar days, weekends count; if it expects workdays, check whether holidays are considered.
  4. Review the timeline’s first and last dates. Extend the chart if the project falls outside the displayed window, while preserving any formulas or formatting rules.
  5. Update owners, status, and progress fields only if the workbook provides them, and agree on what those labels mean before sharing.

Keep the data table and chart connected. Deleting formula cells or pasting over the timeline can remove the conditional-formatting rule or calculated dates. If you need more task rows, copy a complete existing row, including its formulas and formatting, then confirm that the references adjust as expected.

Common problems and practical fixes

The bars do not appear. Check that start dates are valid dates, duration cells contain numbers, and the conditional-formatting rule covers the intended chart range. A text date can look plausible while failing date comparisons. Also inspect whether the rule’s references match the first cell of the selected range.

The bar is one day too long or short. Confirm whether the duration counts the start date. In the example above, a four-day task includes its starting date and ends after four calendar dates. Some templates instead ask for a start and finish date, so do not apply a duration-based assumption to a different layout.

Weekends make the schedule confusing. A simple calendar-day chart includes Saturdays and Sundays. A working-day schedule needs a different design, potentially with weekends omitted from the timeline or dates calculated using workday logic. Check whether the template accounts for public holidays; many basic templates do not.

Dates display as numbers. Excel stores dates as serial numbers. Apply a date format to the cells rather than replacing the values with typed text. In Windows Excel, use Home > Number Format to select a date format.

The chart looks different after conversion. Imported files can lose or alter formatting, formulas, or features, especially if they were made for another spreadsheet application. Compare the converted chart with the original if possible, and keep a copy of the source file until the important schedule elements have been checked.

Free templates versus paid project tools

A free Excel template can be enough when one person maintains a straightforward schedule and collaborators mainly need to view or edit a workbook. Excel for the web can be used at no charge with a Microsoft account, although its feature set differs from desktop Excel and account or service availability can vary. A free template does not automatically include an Excel license, cloud storage beyond applicable limits, technical support, or access to premium tools.

Dedicated project-management services may offer features Excel templates generally lack, such as automated dependency scheduling, reminders, shared task assignments, change history, or workload views. Those products may have free tiers, paid plans, or feature restrictions; check current plan details directly with the provider. For a one-off project, adopting a new service can be more work than maintaining a spreadsheet. For a project with frequent changes and many collaborators, shared task-management software may reduce manual coordination.

Google Sheets is another browser-based option, but a template built specifically for Excel may not behave identically after conversion. If a team needs live co-editing, choose a format and platform everyone can access, and test the important formulas and formatting before relying on it.

Sharing, printing, and keeping the schedule usable

Before sharing, remove example tasks and any private notes that should not be distributed. Give the workbook a descriptive filename and explain who is responsible for updating it. If several people edit the same schedule, agree on a source of truth; multiple emailed copies can quickly become inconsistent.

For a status meeting, filter or group tasks where the template allows it, and set a useful print area. A long daily timeline may span many pages, so switching to a weekly view or printing only the relevant date range can produce a more readable handout. In Excel for Windows, review Page Layout > Orientation and File > Print before printing. Check the print preview rather than assuming all timeline columns will fit on one page.

Record a status date if the chart is used for progress discussions. Without a clear “as of” date, readers may mistake old progress information for current information. Keep planned dates and actual completion dates distinct when the distinction matters; overwriting the plan with actual dates can hide schedule changes.

Frequently Asked Questions

Where can I download a free Gantt chart Excel template?

Look at Microsoft Create, the templates shown in Excel, and reputable spreadsheet-template publishers. Confirm that the download is an Excel workbook or template and review any license terms. Template availability and exact designs can change, so search by both “Gantt chart” and “project timeline.”

Is there a free Gantt chart template in Excel?

Excel’s template options may include project schedules or timeline layouts, and Microsoft Create provides templates for its products. The available selection can vary. If you do not find a suitable chart, an Excel workbook can also be adapted with task dates and conditional formatting.

Can I use an Excel Gantt chart online?

Yes. You can work in Excel for the web by opening a workbook through Microsoft’s online services, subject to account and feature availability. Common workbook editing is possible, but check the file in the browser first if it relies on advanced desktop features, add-ins, or macros.

Does a free Gantt chart template calculate task dependencies?

Not necessarily. Many templates display task dates as bars but do not automatically move later tasks when a predecessor changes. Check the workbook’s instructions and test a date change. A dependency column may be informational rather than an automated scheduling feature.

Can I convert a Google Sheets Gantt template to Excel?

You can often download or convert a spreadsheet, but formatting, formulas, and conditional rules may not transfer perfectly. Open the converted workbook in Excel and verify dates, bars, and any progress calculations before using it as the authoritative schedule.

Related

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.