Yes. You can get a free Gantt chart timeline template by searching Excel’s template gallery or Microsoft Create, or build a simple one directly in Excel for Microsoft 365. In Excel on Windows, start with File > New and search for “Gantt”; template availability can change, so check the template details and terms before downloading.
What a Gantt chart timeline template includes
A Gantt chart lays out project tasks against dates. Tasks appear as rows, while a calendar runs across the columns or chart axis. A colored bar shows when each task starts and finishes. A template usually supplies the layout and some formatting, but you still enter your own project names, dates, and task details.
Common fields include a task name, owner, start date, finish date, duration, and status. More detailed workbooks may also include milestones, dependencies, percent complete, or a summary of the project schedule. A basic template is often enough for a small event, home renovation, class assignment, or product launch. For a larger project, it helps to have clear instructions and a layout that can show links between tasks.
A Gantt chart is related to a timeline, but the terms are not always interchangeable. A timeline may show only major dates or milestones. A Gantt chart normally shows the span of individual tasks, making it easier to see overlaps and gaps in a schedule.
Where to find a free Excel template
The quickest place to look is Excel’s built-in template search. Open Excel, select File > New, and search for “Gantt” or “project timeline.” Choose a result to preview it before opening. Microsoft’s template selection can vary by region, account, and time, and some results may open in a browser or require an internet connection.
You can also search Microsoft Create for Excel project-planning templates. Third-party spreadsheet sites publish free downloads too, but “free” can refer only to a basic version or personal use. Read the download page and workbook notes to check whether commercial use, redistribution, or removing a credit notice is allowed. Avoid files that ask you to enable macros when a plain schedule template should be sufficient.
- Check that the file is an Excel workbook, such as an .xlsx file, rather than a PDF preview.
- Preview the date range and columns to make sure they suit your project.
- Look for a clear instructions sheet and editable example data.
- Confirm whether the template uses formulas, conditional formatting, or macros.
- Save a copy before replacing sample tasks with real project information.
How a Gantt chart works in Excel
Excel does not have a dedicated chart type named “Gantt chart.” Most Excel Gantt templates create the effect in one of two ways. A worksheet grid uses conditional formatting to color date cells that fall between a task’s start and finish. A chart-based version uses a stacked bar chart: one series positions each task on the date axis, and another series displays its duration. The first approach is straightforward to edit; the chart approach can be easier to present as a graphic.
In a grid, each task has a start and finish date, and the columns represent days, weeks, or months. The formatting rule compares each column’s date with the task’s dates. In a stacked bar chart, Excel draws a hidden starting offset followed by a visible duration bar. Neither method automatically knows the order in which work must happen unless the template also records and uses task dependencies.
Dates must be real Excel date values, not text that merely looks like a date. If a date is stored as text, comparisons and sorting can behave unexpectedly. Use a consistent calendar scale, and decide whether duration means calendar days or working days. A basic inclusive calendar-day calculation counts both the start and finish dates.
Build a basic timeline grid yourself
If a downloaded template is too complicated, a small grid gives you control over the schedule. In a blank worksheet, use these columns: A for Task, B for Start, C for Finish, and D for Duration. Put the timeline dates along row 4, beginning in E4, and put the first task in row 5. Format the date columns as dates and leave enough columns to cover the project.
- Enter a short task name in A5, and enter its start and finish dates in B5 and C5.
- With the task dates in B5 and C5, enter this formula in D5 to calculate inclusive calendar days:
=C5-B5+1. For a task starting January 6, 2026 and finishing January 8, 2026, the result is 3. - Enter actual dates across row 4, one per column, starting in E4. You can fill the dates across the row using Excel’s fill handle, then extend the row to cover the schedule.
- Select the date grid, for example E5:AI20, and choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format.
- With dates in E4:AI4, task starts in column B, finishes in column C, and task rows beginning at 5, use this conditional-formatting formula:
=AND(E$4>=$B5,E$4<=$C5). Choose a fill color, confirm the rule, and apply it to the full date grid.
The formula makes a cell’s fill appear when the date at the top of that column falls on or between the task’s start and finish. The dollar signs keep the header row and start/finish columns fixed as Excel applies the rule across the grid, while the task row changes. Add more task rows inside the applied range, or edit the range through Home > Conditional Formatting > Manage Rules. This simple example shows calendar days; it does not skip weekends or holidays.
Choose a template that fits the project
Before choosing a workbook, think about who will update it and what decisions it needs to support. A one-person plan may need only tasks and dates. A team schedule may need owners and status fields, while a client-facing plan may benefit from a clean print layout and a separate milestone summary. More columns are not automatically better: every field creates another detail someone must maintain.
- Time scale: Daily columns work for short, detailed schedules. Weekly or monthly periods keep a longer plan compact.
- Project size: A few dozen tasks are easy to scan in a simple grid. If the workbook becomes crowded, group tasks or show summary phases.
- Dependencies: If one task cannot start until another finishes, make sure the template can record and communicate that relationship.
- Updates: Consider whether progress is entered manually or calculated from a status or completion field.
- Printing and sharing: Check whether the schedule remains readable when printed or opened by colleagues using a different version of Excel.
For example, a two-week marketing launch could use daily columns for drafting, review, design, and publication. A six-month facilities project might be easier to read with weekly or monthly columns, plus a short milestone list. The right scale is the one that shows useful scheduling detail without making the whole project too wide to navigate.
Common template problems and fixes
A bar that appears one day too short is often caused by a mismatch between inclusive and exclusive duration. The example formula counts both endpoints; a duration measured as the difference between dates does not. Decide which convention you need and use it consistently. Likewise, a task that ends on a Sunday will still occupy a weekend in a calendar-day grid. A workday schedule needs different logic and should account for weekends and any relevant holidays.
If bars do not appear, check that the start and finish cells contain valid dates, that the conditional-formatting rule covers the task rows, and that its references match the first cell in the selected range. A rule written for E5 should refer to E$4 and row 5; if the selected range begins elsewhere, adjust the references. If every bar is the same color or dates look misaligned, check for overlapping conditional-formatting rules and inconsistent date scales.
Another common misconception is that a colored bar proves the project is on track. In a basic template, it usually shows only the planned date span. To show progress, the workbook needs a separate progress field or actual dates, and that information must be updated. A static schedule will not automatically recalculate realistic task dates when another task slips unless its formulas or project-management features explicitly model dependencies.
Grid template or bar chart?
A conditional-formatting grid is useful when people need to edit task dates directly in cells, inspect a calendar day by day, or add notes beside the schedule. It is also easy to extend with columns such as owner and status. Its main drawback is width: a daily schedule covering several months can require many columns, and printing it on one page may make text very small.
A stacked bar chart can be a better visual for a presentation or a compact overview. It is less convenient for entering detailed notes, and changing its source data or axis settings may take more work than editing a grid. A chart also does not create task dependencies by itself. Choose a grid for hands-on tracking and a chart when the primary need is a visual summary; some workbooks provide both views.
Costs, sharing, and practical limits
A free template can be sufficient for a small project, but it is not the same as dedicated project-management software. A spreadsheet may not provide automatic dependency scheduling, notifications, reliable multi-user controls, or an audit trail. If several people edit the file, agree on who owns updates, how status is recorded, and where the current copy lives. Excel workbooks can be shared through supported Microsoft 365 storage and collaboration features, but access depends on the account, permissions, and organization settings.
Keep the original workbook unchanged and make a working copy before adding project data. Review formulas and conditional-formatting rules before relying on a template: downloaded files can contain assumptions about date ranges, workdays, or sample tasks that do not fit your plan. For sensitive or business-critical schedules, follow your organization’s file-sharing and data-handling rules.
Frequently Asked Questions
Does Excel have a free Gantt chart template?
Excel’s File > New template search may show free Gantt or project-planning workbooks, and Microsoft Create offers templates to browse. Available results can change. You can also make a basic Gantt grid with dates and conditional formatting.
Is there a Gantt chart option in Excel?
Excel does not include a chart type specifically called Gantt. Templates typically simulate one with a conditional-formatting grid or a stacked bar chart. Both can show task dates, but they do not automatically manage dependencies unless additional logic is provided.
Can I make a Gantt chart in Excel without downloading a template?
Yes. Set up task, start, and finish columns, add dates across the top, and use a conditional-formatting formula to color cells between each task’s start and finish. The steps above make a simple calendar-day version without macros.
Can I use an Excel Gantt template on a Mac or in Excel for the web?
Many ordinary .xlsx templates and worksheet formulas work across Excel for Windows, Mac, and the web, but some controls and template options can differ. The instructions here use Microsoft 365 on Windows. On Mac or the web, look for the equivalent Conditional Formatting controls if ribbon labels or placement differ.
How do I show weekends or milestones?
A calendar-day grid includes weekends unless you design it to exclude them. You can make milestones separate rows or mark their dates distinctly, but confirm that the template’s formulas and formatting support those choices. A one-day task can be shown with the same start and finish date in the basic grid.
Related
- Excel Yellow Color Code: RGB, Hex, and Theme Values
- Excel Worksheet vs CSV: Key Differences and When to Use Each
- Excel Wrap Text Shortcut: Keys, Ribbon, and Fixes
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table Mode: Find the Most Common ValueTo find a mode with an Excel PivotTable, put the field you want to analyze in both Rows…
- Excel Donut Chart Progress: Build a Progress RingTo make an Excel donut chart show progress, give it two values: the amount complete and the amount…
- Excel Line Chart: Hide Zero Values Without Losing DataTo hide zero values in an Excel line chart without changing your original data, create a helper column…
- Excel Dashboard Software Templates: How to Choose and UseExcel dashboard software templates are ready-made workbooks that turn spreadsheet data into a visual summary, usually with charts,…
- Balance Chart in Excel: Track an Account Over TimeTo create a balance chart in Excel, list transaction dates and signed amounts, calculate a running balance beside…
- Gantt Chart for Google Sheets: Setup, Uses, and LimitsYes. You can make a Gantt chart in Google Sheets by putting tasks and dates in a table,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.