What’s in the template
| Phase | Days | Tasks | Milestone |
|---|---|---|---|
| Planning | 1 | Sprint planning meeting | Sprint goal agreed |
| Build | 2–8 | Three user stories, code review | — |
| Test and release | 7–10 | QA testing, bug fixes | Release |
| Close | 10 | Sprint review, retrospective | — |
Replace the three stories with the items from your backlog. The template uses working days, so a two-week sprint is ten columns and weekends are skipped.
What to bring to sprint planning
- A sprint goal: one sentence that says why this sprint matters.
- Capacity: who is available, and how many days, once holidays and meetings are counted.
- A ready backlog: stories small enough to finish inside the sprint, with acceptance criteria.
- Dependencies: what one story needs from another, or from another team. That is where the Gantt view helps.
The Excel version
The workbook has a Sprint sheet and a short How to use sheet. Dates come from one sprint start cell and skip weekends with the WORKDAY function. Each task has an owner, a start day and a number of days; the bars are drawn by conditional formatting, with no macro. It opens in Excel, Google Sheets and LibreOffice.
Why a Gantt chart for a sprint?
Most teams track a sprint on a board, and that works for the daily stand-up. A short Gantt view adds what a board hides: QA can’t start before the stories are built, and the release depends on the bug fixes. In Ganttmint the two are the same tasks: open the Kanban board for the stand-up, switch to the Gantt chart when you plan or when something slips. For more on combining both, read how to use a Gantt chart in agile.
Tips
- Keep stories under three days where you can. Long bars hide problems until it is too late.
- Plan QA and review time as tasks, not as leftovers on the last afternoon.
- Leave a little slack. Plan for around 80% of your capacity; support requests and meetings always come.
- Copy the sheet for each sprint and keep the old ones: they show how much you really finish.
Working in Jira? See what the Jira timeline does and how to export it. For a longer roadmap, start from the project timeline template.
Planning the whole release? Start from the IT project plan template.
Planning several sprints and releases? Use the agile project plan template.
Questions
Is the sprint planning template free?
Yes, online and in Excel, for personal or commercial use.
Does it work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets: the formulas, including WORKDAY, keep working.
Can I use it for one-week or three-week sprints?
Yes. Change the durations and add or remove columns in the grid; the online version adapts on its own.
Does it skip weekends?
Yes. The Excel file counts working days with the WORKDAY function, so weekends are left out.
Can I see the sprint as a Kanban board?
Yes, in the online version: the same tasks open as a Kanban board with To do, In progress, Review and Done.