A Gantt chart template turns a project plan into a clear visual timeline, so everyone can see what needs to happen, who is doing it, and when each task starts and ends. Below you can download three free Gantt chart templates in Excel: a weekly project Gantt chart with progress tracking, a daily Gantt chart for short projects and campaigns, and a Gantt chart with milestones and phases for larger plans.
Each template is a ready-to-use .xlsx file. You type in your tasks, start dates, and durations, and the bars draw themselves automatically with conditional formatting. There are no add-ins, macros, or paid project management tools required, and the files also work in Google Sheets and LibreOffice Calc.
What Is a Gantt Chart?
A Gantt chart is a horizontal bar chart that shows a project schedule over time. Each row is a task, and each bar shows when that task starts, how long it lasts, and when it finishes. The timeline runs across the top in days, weeks, or months. Looking along a row tells you the timing of one task, while looking down a column tells you everything that is happening in a particular week.
The format is named after Henry Gantt, who popularized it in the early 1900s, and it is still the most common way to present a project schedule because it is so easy to read. Clients, managers, and team members can understand a Gantt chart at a glance, even if they have never used project management software.
Most Gantt charts also show extra details beside each bar, such as the task owner, the duration in days, and the percentage complete. More detailed charts group tasks into phases and mark key milestones, such as a contract signing, a design approval, or a launch date.
Why Use a Gantt Chart Template in Excel?
- It shows the whole project on one page. Instead of a long task list, you see the full timeline, overlaps, and gaps at once.
- Bars update automatically. Change a start date or duration and the chart redraws, so you never have to color cells by hand.
- It makes deadlines visible. Everyone can see when their work must start for the project to finish on time.
- It highlights overloaded weeks. When many bars stack up in the same column, you know a busy period is coming and can rebalance the work.
- It is easy to share. Excel is available almost everywhere, and the chart prints neatly on a single landscape page.
- It costs nothing. For small and medium projects, a spreadsheet Gantt chart does the job without paying for project management software.
What to Include in a Gantt Chart
- Project name and start date: the start date drives every other date in the template.
- Task list: break the project into tasks that each have a clear result, such as “wireframes approved” rather than “design work”.
- Task owner: one named person or role responsible for each task.
- Start date and duration: the template calculates the end date for you.
- Percent complete: shows progress inside each bar so you can spot tasks that are falling behind.
- Phases or groups: group related tasks, such as planning, design, development, and launch.
- Milestones: zero-duration markers for key events and approvals.
- Timeline: a row of dates across the top in days or weeks, matched to the length of the project.
How to Make a Gantt Chart in Excel With These Templates
- List your tasks in order. Start with the first activity and work through to project close. Add a phase heading row above each group of tasks.
- Enter the project start date. Type it in the yellow cell at the top. The weekly templates work best when this date is a Monday.
- Add start dates and durations. Enter each task’s start and how many days it will take. The end date is calculated for you.
- Check the bars. Read across each row and confirm the bars fall where you expect. Adjust start dates where tasks depend on earlier work.
- Assign owners. Put a name beside every task so responsibility is clear.
- Track progress weekly. Update the % Done or Status column every week. Completed work fills with a darker color, so slipping tasks stand out.
- Share and print. Each sheet is set to print on one landscape page, ready for a status meeting or a client update.
Download the Free Gantt Chart Templates
All three Excel Gantt chart templates are hosted on this website and are free to download and edit. Each preview image matches the download button directly below it. Open them in Microsoft Excel, Google Sheets, or LibreOffice Calc.
1. Project Gantt Chart Template (Weekly)
A 16-week project Gantt chart with phases, task owners, start and end dates, durations, and a % Done column. Bars show completed work in dark blue and remaining work in light blue, the current week is highlighted, and an overall progress percentage is calculated for you, weighted by task duration.
2. Daily Gantt Chart Template
A 31-day daily Gantt chart for short projects, marketing campaigns, events, and sprints. Every day has its own column with the date and weekday, weekends are shaded grey, one-day milestones turn red, and changing the timeline start date shifts the entire schedule.
3. Gantt Chart With Milestones and Phases
A 12-week Gantt chart with a work breakdown structure (WBS), phase summary rows that calculate their own start and end dates from their tasks, diamond milestone markers, and a Status dropdown. Completed tasks turn green, and a summary counts total and completed milestones.
Tips for Building a Realistic Project Timeline
- Break work into tasks of one to ten days. Very long tasks hide problems. If a task takes a month, split it into smaller steps that you can track.
- Add buffer time. Projects rarely go exactly to plan. A few days of contingency before major milestones protects your deadline.
- Respect dependencies. If testing can only start after development, make sure the testing bar starts after the development bar ends.
- Ask the people doing the work. Duration estimates are far more accurate when they come from the person who will do the task.
- Watch for resource overload. If one person owns three overlapping bars, either move a task or reassign it.
- Keep the chart current. A Gantt chart is only useful if it reflects reality. Update it at a fixed time every week.
- Mark external deadlines as milestones. Contract dates, board meetings, and launch events should be visible to everyone.
Gantt Chart vs. Project Timeline vs. Project Schedule
These terms are often used interchangeably, but they are slightly different tools. A project timeline is usually a simple, high-level view of major events and dates, ideal for presentations. A project schedule is the detailed list of tasks, dates, and owners. A Gantt chart combines both: it is a detailed schedule displayed as a visual timeline, which makes it the best choice for managing day-to-day work while still giving stakeholders the big picture.
Professional tools such as Microsoft Project also add features like automatic dependency links, resource leveling, and critical path analysis. For many small business, marketing, event, and construction projects, an Excel Gantt chart provides everything you need with a much shorter learning curve. If your project grows beyond a few dozen tasks, or several projects share the same people, dedicated software may be worth considering.
Which Gantt Chart Template Should You Use?
Choose the weekly project Gantt chart for projects lasting two to four months, such as website builds, product development, office moves, or training programs. Its % Done column makes it ideal for regular status reports.
Choose the daily Gantt chart when the project lasts a month or less and timing matters day by day. It suits product launches, event preparation, marketing campaigns, audits, and agile sprints.
Choose the Gantt chart with milestones for projects with clear stages and approval points. The phase rows roll up automatically, so you can present a summary to senior managers while the team works from the detailed task rows below.
How to Customize the Gantt Chart Templates
To add a task, insert a new row inside the task area. Copy the formulas from the row above, and the conditional formatting will extend automatically. To change bar colors, open Home > Conditional Formatting > Manage Rules and edit the fill color of each rule. To show more weeks or days, copy the last timeline column to the right and extend the formatting range.
You can rename the % Done column, add a column for budget or cost, or insert a Notes column for risks and dependencies. If you prefer a Monday-to-Friday schedule, filter out weekend columns or simply leave the shaded weekend columns empty. Keep one clean master copy and save a new version for each project, such as “Website-Redesign-Gantt.xlsx”.
You can also check these important templates like the project schedule template for detailed task lists, the project plan template in Excel for goals, scope and budgets, and the timeline template for simple high-level project timelines.
Frequently Asked Questions
How do I make a Gantt chart in Excel?
The easiest way is to use a template. List your tasks, enter a start date and duration for each one, and the template’s conditional formatting colors the matching cells on the timeline to draw the bars. You can also build one manually with a stacked bar chart, but a template is faster and easier to update.
Is there a free Gantt chart template in Excel?
Yes. All three Gantt chart templates on this page are free Excel files. They include a weekly project Gantt chart, a daily Gantt chart, and a Gantt chart with milestones and phases, and they work in Excel, Google Sheets, and LibreOffice Calc.
What is the difference between a Gantt chart and a timeline?
A timeline shows major events and dates in a simple, high-level view. A Gantt chart shows every task as a bar with its start date, duration, end date, and owner, so it is better for managing the detailed work of a project.
Can I show progress on an Excel Gantt chart?
Yes. In the weekly project template, enter the percentage complete for each task and the completed part of the bar turns dark blue while the remaining part stays light blue. The milestone template uses a Status column, and completed tasks turn green.
How many tasks should a Gantt chart have?
Include enough tasks to track the work clearly, usually between 10 and 50 for a small or medium project. Tasks should normally last between one and ten days. If the chart grows much larger, group tasks into phases or split the project into separate charts.
