Agile Sprint Tracker Spreadsheet: Scrum Backlog, Sprint Board, Burndown & Velocity (Excel + Google Sheets)

Scrum sprint tracker: backlog, auto sprint board, burndown chart, velocity, workload and retros. Excel + Google Sheets, with a setup guide and video.

Watch the setup guide & full tour

Run your sprints without another subscription.

The Agile Sprint Tracker is a ready-to-use spreadsheet for Microsoft Excel and Google Sheets. Write stories in the backlog and give them points and a sprint. The board, burndown, velocity and workload views build themselves.

What’s inside (9 connected tabs)

• Start Here: 6-step setup + colour key
• Dashboard: Current sprint, days left, % done, velocity
• Setup: Team, sprint length, start date, epics
• Backlog: 300 stories with points, priority, epic, status
• Sprints: 12 sprints with dates, goals, committed vs done
• Board: Kanban for one sprint, fills itself
• Burndown: Ideal vs actual points left, with chart
• Workload: Points per person vs capacity
• Retro: Went well · To improve · Actions

Why you’ll like it

• The sprint board fills itself from the backlog: no copying cards between tabs
• Burndown chart from real done dates, not guesses
• Velocity per sprint plus a rolling 3-sprint average for planning
• Workload check against each person’s capacity
• Retro log with action owners, so lessons don’t get lost

Also included

• Setup Guide PDF
• Video walkthrough https://youtu.be/RRe5XolBEUo
• Sample data that follows today’s date

Formulas only: no macros, no add-ons, no subscription. Works in Excel 2016+, Microsoft 365 and Google Sheets.

Part of the Project Management Spreadsheet collection. More tools at createdigitaltools.com