Free Excel Project Gantt Chart Template: How to Use It

Yes—free Excel project Gantt chart templates are available, including templates listed through Microsoft Create and downloadable spreadsheets from other providers. Choose a template that suits your project, or make a simple one in Excel by listing tasks and dates, then using conditional formatting to show each task as a bar across a calendar.

Where to find a free Excel Gantt chart template

Start with Microsoft Create and search for terms such as “Gantt chart” or “project timeline.” Template names and availability can change, so check the preview and description before downloading. You can also search reputable spreadsheet and project-management sites, but read the license: “free download” does not always mean free for commercial use, redistribution, or use without creating an account.

Before opening a downloaded workbook, check its file type. A basic template should usually work as an .xlsx file and does not need macros. Be cautious with .xlsm files if you do not know why they contain macros; do not enable macros just to view a schedule. If a site asks for payment details, a subscription, or extensive personal information for a supposedly free file, review those terms before continuing.

Excel itself is not the same thing as a free template. Microsoft 365 desktop Excel requires an appropriate license, while Excel for the web may be available at no charge with a Microsoft account and has a different feature set. Check Microsoft’s current account and product terms if access to Excel is part of your decision.

What a project Gantt chart shows

A Gantt chart is a schedule displayed as a timeline. Tasks appear in rows, dates run across the top, and horizontal bars show when each task is planned to start and finish. It helps readers see the order and overlap of work more quickly than they can from a plain task list.

A useful starter workbook commonly has columns for task name, owner, start date, finish date, duration, and status or percent complete. The date grid sits beside those columns. For example, a small website project might list “Confirm content” from April 1 to April 3, “Build page layouts” from April 4 to April 10, and “Review” from April 11 to April 12. The bars make it easy to spot that these tasks happen in sequence.

A Gantt chart is a visual schedule, not necessarily a full project-management system. A colored bar does not automatically mean a task is on track, and it does not prove that the person assigned has capacity. A chart may show dependencies or progress, but only if the workbook has been designed and maintained to represent them.

How an Excel Gantt chart works

Many Excel templates use conditional formatting to color cells in a date grid. Excel checks each grid cell against the task’s start and finish dates. If the date above a cell falls within that task’s range, the cell receives a fill color; otherwise, it remains unfilled. This creates the appearance of a continuous bar without drawing a separate shape for every task.

In Microsoft 365 Excel for Windows, select the calendar grid and choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. The rule’s formula must use references that adjust across the grid while continuing to refer to the correct task row. For a grid beginning at F2, with dates in row 1, start dates in column C, and finish dates in column D, use:

=AND(F$1>=$C2,F$1<=$D2)

Set a fill color for the rule and apply it to the full grid, for example F2:AZ20. In this layout, F$1 keeps the date-header row fixed while the column changes across the calendar; $C2 and $D2 keep the date columns fixed while the row changes for each task. The result is a bar on every date from the start date through the finish date, inclusive. The menu labels are broadly similar in Excel for Mac and Excel for the web, although the rule dialog and available options can vary slightly.

Build a basic chart from a blank workbook

A template can save setup time, but a small chart is straightforward to create yourself. First, decide whether your schedule should use calendar days or working days. A daily grid is simple to read, but it includes weekends unless you deliberately omit or visually distinguish them.

Enter task names in A2:A20, owners in B2:B20, start dates in C2:C20, and finish dates in D2:D20. Use actual Excel dates, not date-looking text.
Put a duration heading in E1. With the start date in C2 and finish date in D2, enter =D2-C2+1 in E2 and fill it down. For a task running April 1 through April 3, the result is 3 days because both endpoint dates count.
Enter the first calendar date in F1. With F1 containing a real date and G1 as the next date column, enter =F1+1 in G1, then fill right for as many dates as the schedule needs. Format the header cells as dates using Home > Number Format.
Select the date grid, create the conditional-formatting rule shown above, and choose a fill color. Adjust the example cell references and applied range if your task table starts in different columns or has more rows.
Make the chart easier to scan: freeze the task headings if needed, widen the task-name column, apply borders or alternating row formatting, and use a clear date format. Keep the key for colors visible near the chart.

For a one-day milestone, set the start and finish to the same date. The inclusive duration formula returns 1, so the chart shows a one-cell bar. You can label the task “Launch” or “Approval” and format that row differently if the milestone should stand out.

Choose a template that fits the project

Before selecting a workbook, consider how much scheduling detail your team actually needs. A compact chart can be clearer than a feature-heavy file that nobody updates. Check whether the template is designed for a short project, a long calendar, or a repeated planning process, and whether it has enough task rows and date columns.

Time scale: Daily columns help with short, detailed work. Weekly or monthly views are easier to read for long projects, but may hide exact start and finish days.
Dependencies: If tasks must occur in a specific order, look for fields that record predecessors. A visual connection alone may not recalculate dates when a predecessor slips.
Progress tracking: Check whether progress is entered as a percentage, a status, or a separate completed-versus-planned bar. Make sure the meaning is documented.
Ownership: An owner column helps teams assign responsibility, but it does not replace workload planning or agreement about who is accountable.
Compatibility: Look for .xlsx if you want a macro-free workbook. If a file relies on newer Excel functions or macros, confirm that everyone who needs it can use those features.

Common problems and practical fixes

The bars do not appear. Check that start, finish, and header values are real dates, that the conditional-formatting rule covers the date grid, and that its cell references match the layout. A date stored as text may look correct but fail a date comparison. Also check whether another conditional-formatting rule is overriding the bar color.

The bar is one day too long or short. Decide whether the finish date is inclusive. The formula =D2-C2+1 counts both the start and finish dates; a subtraction without +1 counts the difference between dates instead. For most task schedules where both dates are worked or occupied days, inclusive counting is easier to interpret.

The chart becomes too wide. A daily grid across a year can require hundreds of columns. Use a weekly or monthly view for a high-level plan, split the project into phases or separate sheets, or show a rolling window around the current work. Avoid shrinking the text until the dates are unreadable.

Weekends make the schedule misleading. The basic rule colors every date in the range, including Saturdays and Sundays. You can leave them visible but shade weekend columns separately, or use a workday-based design. Do not assume a template excludes weekends just because it is called a project Gantt chart; inspect its calendar logic.

Progress does not move the schedule. A percent-complete value is only a report of progress unless the workbook has additional logic. Updating it will not necessarily change dates, recalculate dependent tasks, or flag a late task. Keep planned dates and actual status distinct so readers do not mistake a completed portion of a bar for a revised forecast.

Excel templates versus project-management tools

Excel is a sensible option when a project has a manageable number of tasks, one person can maintain the schedule, and the team mainly needs a shareable visual. It is flexible, familiar, and easy to tailor. A workbook can also be exported or printed for a meeting without requiring every reader to learn a new system.

Dedicated project-management software is generally more suitable when many people need to update one live plan, tasks have complex dependencies, schedules must be recalculated after changes, or managers need dashboards and notifications. Some tools have free plans, but their limits and pricing vary. Excel templates do not automatically provide those shared workflows: emailed copies can diverge, and simultaneous edits or version history depend on how the file is stored and shared.

A practical middle ground is to plan in Excel and store the workbook in a shared location where collaborators can access the same file. Agree on who can edit dates, how often the plan is updated, and which version is authoritative. If a schedule becomes difficult to maintain, that is a useful signal to compare dedicated tools rather than continually adding formulas to an unwieldy sheet.

Frequently Asked Questions

Is there a free Gantt chart template in Excel?

Free Excel Gantt chart templates are available from Microsoft’s template listings and other providers. Availability and terms can change, so check the current download details, license, file type, and required Excel features before using one.

Does Excel have a built-in Gantt chart button?

Excel does not offer a dedicated, one-click Gantt chart chart type in the way some project tools do. Templates commonly create the visual with cells, formulas, and conditional formatting, or use stacked bar charts for a different style of display.

Can I use an Excel Gantt chart template in the browser?

Many .xlsx workbooks can be opened and edited in Excel for the web, including basic task tables and conditional formatting. If a template depends on macros, advanced features, or behavior that differs in the browser, it may require desktop Excel; check the workbook in the version your collaborators will use.

How do I show weekends in an Excel Gantt chart?

The simple date-grid approach includes weekends unless you customize it. You can shade weekend columns for context, use a weekly view, or choose a template built around working days. Confirm the calendar convention with the people reading the plan.

Will a Gantt chart automatically update when a task is delayed?

Not necessarily. A basic template draws bars from entered dates; changing one task’s finish date will not automatically move later tasks unless the workbook has dependency formulas or scheduling logic. Review dependent dates after a delay, or use a project tool with automatic rescheduling if that behavior is essential.

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.