What’s in the template
| Phase | Tasks | Milestone |
|---|---|---|
| Discovery (weeks 1–3) | Kickoff, stakeholder interviews, requirements | Scope approved |
| Design (weeks 4–7) | Concept, detailed design, review | Design signed off |
| Delivery (weeks 8–12) | Build, testing, fixes | Ready for launch |
| Launch (weeks 13–14) | Training, go-live, follow-up | Project closed |
Rename the phases and it fits most projects: a website, an office move, a product release or a research project.
The Excel version
The workbook has a Timeline sheet and a short How to use sheet. Each task has a start week and a duration in weeks; the dates are calculated from one project start cell, and the bars are drawn by conditional formatting. No macro, no add-in: it opens in Excel on Windows and Mac, in Google Sheets and in LibreOffice. The current week is highlighted so you can see where you stand.
How to build your project timeline
- Set the start date and, if there is one, the deadline. Work backwards from it if it is fixed.
- List the phases, then three to six tasks per phase. Tasks of one to three weeks are easy to follow.
- Add milestones at the end of each phase: they are what your client or manager will look at.
- Leave a buffer before the final milestone. Reviews and approvals always take longer than planned.
- Share and update it every week. A timeline nobody updates stops being useful within a month.
Excel or online?
In Excel, moving one task means moving the ones after it by hand. Online, you drag a bar and the linked tasks follow, and the same tasks open as a Kanban board for the day-to-day. When someone asks for the spreadsheet, export to .xlsx from the ⋯ menu. If you just need a quick visual, the online timeline maker starts from this same template. For day-by-day plans, see our Excel Gantt chart templates.
Running a campaign? The marketing timeline template plans a quarter of content, channels and reporting week by week.
Building it yourself? Follow how to make a timeline in Excel.
Questions
Is the project timeline template free?
Yes, online and in Excel, 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 keep working.
Can I show months instead of weeks?
The Excel file uses weeks. Online, zoom out to months to see the whole project as a timeline.
How many tasks should a project timeline have?
Enough to make decisions: 10 to 30 rows grouped into phases stay readable on one page.
Can I put the timeline in PowerPoint?
Yes. Export it as a PNG from Ganttmint and paste it into your slide.