1. Home
  2. Templates
  3. Project timeline template

Free project timeline template

A project timeline on one page: four phases, the tasks inside them and the milestones that matter. Edit it online by dragging, or download the Excel file and change the start date: every step moves with it.

26 weeks · 4 phases · Excel, Google Sheets, LibreOffice · free

This is the same timeline as in the Excel file. Drag a bar to try it, then export it back to Excel from the ⋯ menu.

What’s in the template

PhaseTasksMilestone
Discovery (weeks 1–3)Kickoff, stakeholder interviews, requirementsScope approved
Design (weeks 4–7)Concept, detailed design, reviewDesign signed off
Delivery (weeks 8–12)Build, testing, fixesReady for launch
Launch (weeks 13–14)Training, go-live, follow-upProject 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

  1. Set the start date and, if there is one, the deadline. Work backwards from it if it is fixed.
  2. List the phases, then three to six tasks per phase. Tasks of one to three weeks are easy to follow.
  3. Add milestones at the end of each phase: they are what your client or manager will look at.
  4. Leave a buffer before the final milestone. Reviews and approvals always take longer than planned.
  5. 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.