Free Sprint Planning Template (Excel)
What's inside the free sprint planning template
The workbook has three tabs. Backlog holds up to 150 items, each with a sprint name, description, story point estimate, a Selected for sprint Y/N flag, owner, and status. Capacity holds up to 20 sprints, each with a team capacity figure in story points. Velocity holds up to 30 sprints of completed story points once a sprint wraps up.
Nothing here requires re-typing a number twice: mark a backlog item Selected = Y for a given sprint, and its story points count toward that sprint's Committed total on the Capacity sheet automatically.
Auto-calculated capacity vs committed load, with an over-capacity flag
On the Capacity sheet, you enter each sprint's name and its team capacity in story points. Committed sums every Backlog item marked Selected = Y for that exact sprint name, using SUMIFS - unselected or differently-named-sprint items never get counted.
The Status column compares Committed against Capacity on the same row and flags Over capacity the moment commitment exceeds what the team can realistically deliver, so you catch an overloaded sprint during planning instead of discovering it mid-sprint.
Velocity tracking across sprints
The Velocity sheet is where you log what actually got done: enter the sprint name and the story points completed once the sprint closes. The Rolling avg velocity column then averages every completed-points entry from your first logged sprint through the current row, using AVERAGE - a genuine cumulative average, not a static number you calculate separately.
That average is what you use to set the next sprint's capacity realistically, instead of guessing or re-using whatever number felt right last time.
How to use it
- List every backlog item on the Backlog sheet: sprint, description, story points, owner, and status.
- Mark Selected for sprint = Y once an item is pulled into a specific sprint's commitment.
- On the Capacity sheet, enter each sprint's name and team capacity - Committed and the Over capacity flag calculate automatically.
- After a sprint ends, log completed points on the Velocity sheet and use the rolling average to set the next sprint's capacity.
Download the free Free Sprint Planning Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
CRM & Sales Pipeline Tracker
If you're tracking more than sprints - deals, stages, and a sales forecast - the paid CRM & Sales Pipeline Tracker ($14) adds stage-by-stage conversion and a 3-scenario forecast dashboard.
See the full versionFrequently asked questions
How does the over-capacity flag work?
The Capacity sheet sums every Backlog item marked Selected = Y for a given sprint (using SUMIFS) into a Committed total, then flags Over capacity the moment that total exceeds the Team capacity figure you entered for that sprint.
Is the velocity average a fixed 3-sprint rolling window?
No. It's a cumulative average of every sprint you've logged completed points for, from the first row through the current one, using AVERAGE - it gets more stable the more sprints you add, rather than resetting every 3 sprints.
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. Capacity, commitment, and velocity formulas keep working.
How many backlog items and sprints can I track?
The Backlog sheet holds up to 150 items, the Capacity sheet up to 20 sprints, and the Velocity sheet up to 30 sprints of completed-points history.
What's the usage license?
Personal use or use within one business. It's not meant to be resold or redistributed as a template product.