
What changed (Nov 14, 2026): Rebuilt the page as a template collection: 9 free Excel Gantt chart templates (simple, daily, weekly, monthly, multi-project, marketing, event, agile, construction) plus PowerPoint, Word and CSV versions, recalculated in LibreOffice and spot-checked in Apple Numbers; added a chooser table, Google Sheets and Mac instructions, compatibility and license notes, and 10 FAQs.
A Gantt chart template is a ready-made project schedule that lists tasks down the left side and draws each task as a horizontal bar across a date scale. A good one does more than color cells. It calculates end dates from durations, moves dependent tasks when an earlier task slips, marks milestones, and shows progress against a status date. If you're new to the format, start with what a Gantt chart is and how to read one. Below are nine free Excel and Google Sheets Gantt chart templates (simple, weekly, daily, monthly, multi-project, construction, marketing, agile, and event planning), plus an editable PowerPoint slide and a Word version.
Written and tested by Allen, AFFiNE content team. Updated November 14, 2026. Every workbook was recalculated in LibreOffice 26.8 and checked against an independent schedule calculation before publication, so the dates, statuses, and late flags in the examples and preview images are the files' actual outputs. The multi-project workbook was also opened in Apple Numbers 14.4 on a Mac. Platform claims were checked against Microsoft Support, Google Docs Editors Help, and Apple Support, following AFFiNE's editorial policy. All example projects are fictional.

| Template | Time scale | Best for | Download |
|---|---|---|---|
| Weekly (with dependencies) | Weeks | Most projects of 1–4 months | XLSX |
| Simple | Weeks | Typing your own dates, no formulas to learn | XLSX |
| Daily | Days | Sprints, events, and plans under 4 weeks | XLSX |
| Monthly (12 months) | Months | Roadmaps and annual plans | XLSX |
| Multi-project | Weeks | Several projects on one sheet | XLSX |
| Construction | Weeks | Fit-outs, renovations, permits, inspections | XLSX |
| Marketing campaign | Weeks | Launches and campaigns | XLSX |
| Agile and software | Weeks | Releases planned in sprints | XLSX |
| Event planning | Weeks | Conferences and company events | XLSX |
| PowerPoint slide | Weeks | Sponsor and client updates | PPTX |
| Word document | Weeks | Proposals and printed plans | DOCX |
All files are free, with no sign-up. Every workbook has a Start Here tab, a filled Example sheet, a Blank sheet ready for your project, and a Holidays tab. Yellow cells are inputs and blue cells are formulas.
| Part | What it does | In these templates |
|---|---|---|
| Task list | One row per task, one owner each | ID, Task, Owner |
| Date math | End date from start + duration | WORKDAY formulas |
| Dependencies | Later tasks move when earlier ones slip | Predecessor ID column |
| Milestones | Zero-length checkpoints | Duration 0 → diamond |
| Progress | Share of each task done | % complete → dark bar |
| Status date | "Where are we now?" line | Late flag + ▼ marker |
If a template makes you type start and end dates by hand for every task, it's a drawing, not a schedule. The first slipped task will leave every later date wrong. The one exception is the simple template below, which is built for people who want to type dates and still get workday counts and late flags.
Each workbook below opens in Excel and Google Sheets. The preview images are drawn from each file's recalculated Example sheet, with a status date of Nov 16, 2026.
The original template on this page and the best starting point for most projects. Durations are in workdays, each task can wait for one predecessor, and the timeline runs for 16 weeks from the project start.
For people who want to type start and end dates and see bars straight away. There are no predecessor formulas to learn: the sheet counts the workdays in each task, shades the weeks it covers, and flags anything unfinished past its end date.

One column per day for plans measured in days rather than weeks: a software sprint, an event week, a move, or a short client engagement. The timeline shows 21 days, and weekends stay visible so you can see where the work pauses.

One column per month across a full year, for product roadmaps, annual plans, and multi-quarter programs. Grey phase rows roll up the tasks below them: earliest start, latest end, and a duration-weighted % complete.

Adds a Project column to the Gantt sheet and a Projects tab that summarizes each project's start, finish, number of tasks, late tasks, and % complete. Use it when one person or team runs several small projects at once.

| Project (example) | Start | Finish | Late tasks | % complete |
|---|---|---|---|---|
| Website refresh | Oct 26, 2026 | Dec 14, 2026 | 0 | 40% |
| CRM migration | Nov 2, 2026 | Nov 25, 2026 | 1 | 39% |
| Brand guidelines | Nov 9, 2026 | Dec 21, 2026 | 1 | 13% |
Built around the phases most building projects share: preconstruction, demolition and rough-in, finishes, and closeout. Permits, inspections, and handover are milestones, so the dates that depend on an inspector are easy to see.

Plans a launch from strategy to measurement: strategy, content, channels, launch, and measure phases, with the launch day as a milestone everything else points at.

Agile teams plan work sprint by sprint, but stakeholders still ask when the release ships. This template groups the work by sprint, with a review milestone at the end of each one, so you can answer that question without pretending every story is scheduled.

Events have one date that can't move, so this template works back from it: plan, program, vendors, promotion, and the event itself, with the venue contract and conference day as milestones.

PowerPoint and Word can't calculate dates. Keep the live schedule in a spreadsheet and use these files to present or print it.
Slide 1 draws the website-relaunch example with native, editable shapes: blue for done, light blue for planned, coral for late, and amber diamonds for milestones, plus a status-date line. Slide 2 is a blank 10-task layout. Aim for 10–15 rows per slide, grouped by phase or milestone rather than every task, and update the slide after each weekly review so the deck never shows a different date than the workbook.
A landscape Word document for proposals, statements of work, and printed plans. Page 1 is the website-relaunch example as a shaded table, copied from the recalculated workbook. Page 2 is a blank 15-task, 10-week grid: write the week dates in the header and shade the cells each task covers.
A Gantt chart is a bar chart of a schedule: time runs left to right, and each task is a bar whose length is its duration. It is named after Henry L. Gantt, who popularized the format in the 1910s. A template is a pre-built file where the structure, formulas, and formatting are already done, so you only enter tasks, durations, and dependencies.

Every useful Gantt chart template has the same six parts:
The workbooks calculate dates the way a project scheduler does, using only standard spreadsheet functions.

WORKDAY(predecessor end, 1, Holidays). If you enter a pinned start that falls later, the pinned date wins. Use it for the first task, or to hold a task until a fixed date.WORKDAY(start, duration − 1, Holidays). Durations are in workdays, so weekends and every date on the Holidays tab are skipped. According to Microsoft's WORKDAY documentation, the function excludes weekends and any dates you list as holidays, and Google Sheets' WORKDAY function takes the same arguments.In the weekly example, "Front-end build" starts on Tue Nov 10, the workday after the design approval milestone on Nov 9. Fifteen workdays would end on Mon Nov 30, but the template skips Thanksgiving (Nov 26), so the end date is Tue Dec 1.
Limits, stated plainly: one predecessor per row (for several, enter the one that finishes last), finish-to-start links only, and the predecessor must be listed above the task. There is no resource leveling or critical-path calculation. Those limits keep the files fast and readable in any spreadsheet app. When you need more, see Gantt chart makers and dedicated project software.
The Gantt Example tab of the weekly template plans a fictional 10-week website relaunch. Its status date is Nov 4, 2026.

| Task | Start | End | Depends on | Status (Nov 4) |
|---|---|---|---|---|
| Kickoff and scope | Oct 5 | Oct 7 | Pinned | Done |
| Stakeholder interviews | Oct 8 | Oct 14 | 1 | Done |
| Content audit | Oct 8 | Oct 14 | 1 | Late (80%) |
| ◆ Requirements approved | Oct 14 | Oct 14 | 2 | Done |
| Sitemap and wireframes | Oct 15 | Oct 26 | 4 | Done |
| Visual design | Oct 27 | Nov 9 | 5 | In progress (60%) |
| ◆ Design approved | Nov 9 | Nov 9 | 6 | Milestone |
| Front-end build | Nov 10 | Dec 1 | 7 | Not started |
| Content migration | Nov 10 | Nov 23 | 7 | Not started |
| QA and accessibility testing | Dec 2 | Dec 8 | 8 | Not started |
| ◆ Launch | Dec 8 | Dec 8 | 10 | Milestone |
| Post-launch review | Dec 9 | Dec 11 | 11 | Not started |
The chart tells you three things at a glance. The content audit should have finished on Oct 14 and is flagged red. Visual design is 60% done with three workdays left. The build and content migration can run in parallel because both depend only on the design approval. If visual design slips by two days, both tasks, QA, the launch, and the review all move automatically.
If you haven't broken the work into tasks yet, our guide on how to create a project timeline walks through scoping, sequencing, and estimating before you open the template.
Excel has no built-in Gantt chart type. Microsoft's own guidance simulates one with a stacked bar chart, hiding the "start" series so only the duration bars show. That works for a static picture, but the chart doesn't know about dependencies or holidays.
These templates take the grid approach instead: dates come from WORKDAY formulas, and bars are cells colored by conditional formatting. Change a duration, and every dependent date and bar updates. Excel is the best fit when one person owns the schedule, the plan needs detail, or the file has to work offline or print cleanly. Only the multi-project Projects tab needs Excel 2019 or later, because it uses MINIFS and MAXIFS.
To use a template in Google Sheets, upload the XLSX to Drive and open it, or create a new spreadsheet and use File → Import. Google's guide to using Excel files in Sheets covers both workflows. The formulas are standard functions, and the bar colors come from conditional formatting, which Sheets supports with custom formulas.
Sheets also has a native timeline view (Insert → Timeline) that draws cards from a start-date and end-date column. According to Google Docs Editors Help, it is available on Google Workspace editions such as Business Standard, Business Plus, Enterprise, and Education, and each task's start date must be earlier than its end date. The Start and End columns in these templates are date formatted, so on a Workspace account you can point a timeline view at them for a card-style second view. Personal Google accounts can use the templates but not timeline view.
Choose Sheets when several people update the plan, when you want comments on individual tasks, or when stakeholders need a live link rather than an emailed file.
On a Mac, the templates work in Excel for Mac, Google Sheets in a browser, and LibreOffice. Apple Numbers can also open Excel files. When we opened the multi-project workbook in Numbers 14.4, every Start, End, Status, and Projects-tab value matched the Excel version, but the colored bar formatting did not carry over: the timeline showed the ▓ ▒ ◆ characters instead of solid bars. The schedule is still readable, and you can add a fill color to those cells by hand. For solid bars without Excel, use Google Sheets.
PowerPoint and Word are presentation layers, not schedulers. Keep the schedule in the spreadsheet, then update the PowerPoint slide or the Word table from it on a fixed schedule.

| If you… | Use | Why |
|---|---|---|
| Own the plan alone | Excel template | Detail, offline, prints well |
| Share updates with a team | Google Sheets | Live editing, comments |
| Report to sponsors | PowerPoint slide | One readable summary |
| Need it in a proposal | Word template | Static table that prints |
| Run 100+ tasks or many teams | PM software | Critical path, resources |
Many teams use two formats: the spreadsheet as the source of truth and a slide as the weekly summary. If you're still choosing what kind of plan you need, compare these with our project planning templates, timeline templates, and project planner template. For other ways to draw a schedule, see Gantt chart alternatives and PERT charts.
Most Gantt charts go stale quickly after kickoff. A 15-minute weekly routine keeps yours useful:

A spreadsheet Gantt chart stops being the right tool when one of these becomes true:
At that point, compare project planning tools for teams or online Gantt chart makers. Export the CSV first, so your task list moves with you.
| File | Opens in | Calculates dates | Notes |
|---|---|---|---|
| 9 XLSX workbooks | Excel, Google Sheets, LibreOffice, Numbers | Yes | Numbers shows bars as characters |
| PPTX slide | PowerPoint | No | Editable shapes |
| DOCX document | Word | No | Landscape, two pages |
| CSV task lists | Any spreadsheet or PM tool | No | Plain text import |
License: the files are free to use, copy, and edit for your own projects, personal or work. Please don't resell the templates or republish them as a download.
AFFiNE isn't a Gantt chart tool. Its database documentation lists Table and Kanban views as available today, with a Timeline view on the roadmap. Where it helps is the project context around the schedule: the brief, decisions, meeting notes, and a task table, all in one workspace, with a link to the Gantt workbook. You can also start from AFFiNE's project timeline template, or sketch a high-level roadmap on the whiteboard before you commit dates to the spreadsheet.
Yes. All nine XLSX workbooks, the PPTX slide, the DOCX document, and both CSV files on this page can be downloaded without payment or sign-up. You can edit and reuse them for your own personal or work projects; please don't resell the files.
Yes. Upload the XLSX to Google Drive and open it, or import it with File → Import. The date formulas and conditional-formatting bars carry over, and Workspace accounts can add a native timeline view from the Start and End columns.
Yes. They work in Excel for Mac, Google Sheets, and LibreOffice. Apple Numbers opens them and calculates the dates and statuses, but it doesn't keep the colored bar formatting, so the timeline shows block characters instead of solid bars.
Yes. The Word template has a filled example table on page 1 and a blank 15-task, 10-week grid on page 2. Word has no scheduling formulas, so keep the live dates in a spreadsheet and update the Word table from it.
Yes. The monthly template has one column per month for 12 months, with phase rows that roll up their tasks. Its example is a product roadmap from November 2026 to July 2027.
Yes. The multi-project template adds a Project column and a Projects tab that shows each project's start, finish, number of tasks, late tasks, and % complete. Keep the total under about 60 rows so the chart stays readable.
The Gantt chart is named after Henry L. Gantt, an American engineer who popularized the format in the 1910s for scheduling production work. Today the same bar-chart idea is used in spreadsheets and project management software.
A Gantt chart shows when work happens and how tasks depend on each other over time. A Kanban board shows what stage each work item is in (such as to do, doing, done) without dates. Use a Gantt chart for projects with deadlines and dependencies, and Kanban for continuous flow work.
A project timeline usually shows key dates and milestones along a single line. A Gantt chart shows every task as a bar with a start, an end, an owner, and dependencies, so you can see overlap and knock-on effects.
For a readable spreadsheet Gantt chart, stay under about 60 rows; for a slide, 10–15 rows. Beyond that, split the plan by phase or use dedicated project management software.
This guide and the downloadable files were checked on November 14, 2026.
Every workbook's Start, End, Status, phase roll-up, and timeline outputs were recalculated in LibreOffice and compared with a separate schedule calculation; the preview images, the Projects table above, the Word example, and the CSV were generated from those verified values. All example projects are fictional teaching examples.