Gantt Chart Excel Free Template XLS: How to Use One

Charts & pivot tables · Updated November 20, 2026

Yes: you can use a free Gantt chart template in Excel, but many current downloads are in the newer .xlsx format rather than the legacy .xls format. If you specifically need .xls, open a compatible workbook in desktop Excel and choose File > Save As > Excel 97-2003 Workbook (*.xls); for a new schedule, a date grid with conditional formatting is a straightforward option.

What an Excel Gantt chart shows

A Gantt chart places project tasks in rows and time along a horizontal timeline. Each task has a start date and an end date, shown as a bar spanning the relevant dates. This makes it easier to see when work overlaps, which tasks are long, and whether a milestone or deadline is approaching. It is a visual schedule, not a project plan that automatically determines every dependency or predicts completion.

Excel does not have a dedicated Gantt chart button. A typical workbook represents the schedule either as a calendar-like grid whose cells are colored for task dates, or as a stacked bar chart with a hidden series to position the visible task bars. The grid is easy to customize and print; a chart can look more polished when the schedule has many tasks or needs to be presented to others.

Finding a free template in XLS format

Search results for a “free Gantt chart Excel template XLS” can point to downloadable spreadsheets, but check the actual file type before downloading. A template may be offered as .xlsx, while “Excel template” describes its purpose rather than its extension. Microsoft’s current template options and many third-party downloads use .xlsx. A file ending in .xls is the older Excel 97–2003 workbook format.

Before opening a file from an unfamiliar site, look for a clear publisher, a description of the workbook, and a direct explanation of what the download contains. Avoid installers or downloads that ask you to enable macros when the schedule only needs dates and formatting. A basic Gantt chart should not require a macro. If a file arrives as a compressed archive, inspect its contents and do not run an executable just to access a spreadsheet.

Also distinguish a workbook from a reusable template. An .xls file is a workbook; the older Excel template extension is .xlt. Newer template files commonly use .xltx. You can still use an ordinary workbook as a starting point by keeping a clean copy and saving a separate copy for each project.

How to choose a template

Choose a template that matches the amount of detail you actually need. A one-page schedule for a small event does not need the same controls as a multi-team project plan. Before entering real tasks, inspect the workbook’s formulas, date scale, and instructions. A useful template makes assumptions visible rather than hiding them in unfamiliar formulas.

  • Timeline scale: Daily columns suit short projects; weekly or monthly columns keep a long plan readable.
  • Task fields: Check whether it has places for an owner, status, priority, milestone, or dependency, and remove fields you will not maintain.
  • Dates and duration: Confirm whether end dates are inclusive and whether duration counts calendar days or working days.
  • Compatibility: If the file must remain .xls, avoid relying on newer Excel features and check the result after saving.
  • Readability: Make sure task names and date labels remain legible when you print or share the sheet.

Build a simple Gantt grid in Excel

A basic grid gives you control without requiring a downloaded file. In Excel for Microsoft 365 on Windows, start a blank workbook and place task names in column A, start dates in column B, and end dates in column C. You can add an owner or status in columns D and E. Put the first timeline date in F1, then fill later dates across the row. Format the task dates and timeline headers as dates so Excel displays them consistently.

  1. Enter one task per row, beginning in row 2. Use real Excel dates in the start and end date columns, not text that merely looks like a date.
  2. With the start date in B2 and the end date in C2, put this in D2 to calculate an inclusive calendar-day duration: =C2-B2+1. For a task from June 3 through June 5, the result is 3 days. Copy the formula down for other tasks.
  3. Enter the first timeline date in F1. With the starting date in F1, put this in G1 and fill it to the right to advance one calendar day per column: =F1+1. Format the row as a date, and make the columns wide enough for the labels you want.
  4. Select the schedule area, such as F2:AZ20, and choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. With start dates in B2:B20, end dates in C2:C20, and timeline dates in F1:AZ1, enter =AND(F$1>=$B2,F$1<=$C2). Choose a fill color and apply the rule.

The conditional-formatting rule colors a cell when the date at the top of its column falls on or between that row’s start and end dates. The dollar signs keep the header row and date columns aligned as the rule evaluates different cells. If the schedule needs more than 20 tasks or more than the dates shown through column AZ, expand the rule’s “Applies to” range and copy the timeline as needed. Leave the start and end dates blank until they are known; otherwise, blank cells can produce confusing bars in some layouts.

Make the schedule useful to read

Formatting should reveal the schedule, not compete with it. Freeze the task-name columns or top row when the sheet is wide, use a consistent date format, and distinguish weekends or nonworking days if that matters to the project. In Microsoft 365 for Windows, use View > Freeze Panes to keep selected rows or columns visible while scrolling. Keep task labels concise and consider alternating row shading so a reader can track a bar to its task name.

For status, add a separate column such as “Not started,” “In progress,” or “Complete,” rather than assuming a colored bar proves work is finished. A planned Gantt bar shows intended timing; it does not update itself when work slips unless you enter actual dates or build additional tracking logic. A useful meeting view may include a status date and a separate actual-progress indicator, but keep those distinct from the planned start and finish.

For milestones, use a zero-day duration only if your template has a clear way to display them. In a simple inclusive grid, a start date equal to an end date colors one day; you can label that row as a milestone or use a special formatting rule. Do not treat a milestone as a task that occupies a full work period.

Dependencies, working days, and planning limits

A Gantt chart can display tasks that depend on other tasks, but a colored grid does not automatically enforce those relationships. For example, if “Test the website” cannot begin until “Build the website” is finished, record the dependency in a separate column or use project-planning software that can link tasks. If the first task moves, a manually maintained spreadsheet will not necessarily move the second task with it.

Decide whether the schedule is based on calendar days or working days. The simple duration formula above counts every date, including weekends. That is suitable for a delivery window or a continuous event, but not always for staff work. A working-day schedule needs a different calculation and a way to account for holidays; do not label calendar-day bars as workdays without explaining the distinction. If a project spans months, weekly columns can be easier to scan than hundreds of daily columns, but they show less exact timing.

Keep the workbook proportionate to the project. Excel works well for a small, mostly static schedule that one person or a small group can maintain. It becomes harder to coordinate when many people edit task dates, dependencies are complex, or the plan needs automatic resource and critical-path calculations. In those cases, a spreadsheet can still be useful for a summary, but it should not be mistaken for a full project-control system.

Saving as XLS and compatibility cautions

In Excel for Microsoft 365 on Windows, use File > Save As > Browse, select Excel 97-2003 Workbook (*.xls) in the file-type list, and save a copy. Excel may show a compatibility warning because the older format cannot preserve every capability of modern workbooks. Review the warning and then reopen the saved .xls copy to check the dates, formatting, formulas, and print layout before sharing it.

The .xls format has older worksheet limits: up to 65,536 rows and 256 columns. That is ample for many small schedules, but it is a meaningful restriction for large or very wide workbooks. Newer Excel features may be removed, changed, or unavailable after conversion. Keep the .xlsx original if you may need newer capabilities later, and use the .xls copy only where legacy compatibility is required. Excel for the web is primarily designed around modern workbook formats; use desktop Excel for a dependable legacy-format save. On Mac, use File > Save As and select the Excel 97–2004 Workbook (.xls) format if it is available in your version.

Free template, custom grid, or chart?

A downloaded template is quickest when its fields and timeline already fit the job. A custom conditional-formatting grid is often better when you want a compact, transparent schedule and need to understand exactly how the bars are produced. A stacked bar chart is worth considering when the result is for a presentation: it can show task bars against a date axis, but it takes more setup and may need adjustment when tasks or dates change.

Whichever option you choose, try a few sample tasks before entering the whole plan. Include overlapping dates, a one-day task, and a task that crosses a month boundary. Those examples reveal common errors such as reversed start and end dates, date values stored as text, a conditional-formatting rule applied to the wrong range, or a timeline that stops before the final task. Once the sample behaves as expected, replace it with the real schedule and retain a clean backup.

Frequently Asked Questions

Can I download a Gantt chart Excel template for free?
Yes. Free templates are available from different publishers, and Excel also lets you build a simple schedule without buying a separate tool. Check the publisher, file extension, and workbook contents before using a download; a free template is not automatically an .xls file.

Is XLS the same as XLSX?
No. XLS is the older Excel 97–2003 workbook format, while XLSX is the newer format used by current Excel workbooks. Saving as .xls can help with older software, but may remove or change newer workbook features. Keep an .xlsx copy if you need to preserve the modern version.

How do I make Gantt bars change when I edit dates?
Use a conditional-formatting rule that compares each timeline date with the start and end dates in the same task row. When you change either date, Excel recalculates which cells meet the rule and updates the bar. Check that the rule’s applied range includes all task rows and timeline columns.

Can I make a Gantt chart without formulas?
Yes. You can manually color cells across a date grid, or create a stacked bar chart by entering task start dates and durations. Manual coloring is simple but must be updated by hand when dates move; formulas and conditional formatting reduce that maintenance.

Why does my Gantt bar appear on the wrong dates?
Common causes include dates entered as text, a start date later than the end date, a timeline header that contains the wrong year, or a conditional-formatting formula whose row or column references are misaligned. Confirm that the cells contain real dates, then inspect the rule and its “Applies to” range.

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.