What’s inside the Excel file
Each template is a normal .xlsx workbook with two parts: a task list (task, start date, duration) and a Gantt sheet where the bars are drawn with formulas and conditional formatting. There is no macro and no add-in: change a start date or a duration and the bars move on their own. The file opens in Microsoft Excel (Windows and Mac), Google Sheets and LibreOffice Calc.
How to customise the template in Excel
- Set the project start. Change the start date of the first task; the following tasks are dated from it.
- Rename the tasks and adjust the durations in days. The bars update as you type.
- Add a task by inserting a row inside the table and copying the formulas from the row above.
- Print or share the Gantt sheet. Set the print area to landscape so the timeline fits on one page.
Want to build one from a blank sheet? Our step-by-step guide to making a Gantt chart in Excel covers the stacked bar method and the conditional formatting method.
Excel template or online Gantt chart?
| Excel template | Ganttmint online | |
|---|---|---|
| Price | Free | Free, no account |
| Change a date | Type it in a cell | Drag the bar |
| Dependencies | Through formulas | Drag from one bar to another; linked tasks follow |
| Share with a client | Send the file | Read-only link, or export to Excel, PNG, PDF |
| Kanban view | No | Yes, same tasks |
You don’t have to choose: plan online, then export to Excel when someone asks for “the spreadsheet”. You can also import your own Excel or CSV file into Ganttmint and get a Gantt chart instantly.
Questions
Is the Excel Gantt chart template free?
Yes. All four templates are free to download and use, for personal or commercial projects.
Does it work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets: the formulas and the bars work the same way.
Does it work on a Mac?
Yes. The file works in Excel for Mac, Numbers can open it, and LibreOffice works on every system.
Can I turn my own Excel file into a Gantt chart?
Yes. Import an .xlsx or .csv file with a task, start and end column into Ganttmint and it draws the Gantt chart for you.
Is there a template with hours instead of days?
The Excel templates count in days. For hour-by-hour planning, zoom the online editor to days and split tasks into shorter steps.