Agile Kanban Board Excel: Choose, Set Up, and Run Sprints
Compare free, DIY, and structured agile kanban board Excel options. Learn the lanes, WIP limits, and sprint fields that make a workbook worth using.
Agile teams do not always need a subscription to run sprints well. A workable agile kanban board excel setup gives a small team the same visibility a paid tool provides — what is queued, what is active, what is finished — without a monthly seat fee or a new tool everyone has to learn. The trick is treating the workbook as a real kanban system, not a colored table. That means clear lanes, a limit on active work, and a way to see whether the team's pace is improving from one sprint to the next. Start with the decision below, then build only the structure that decision requires.
Key takeaway: A kanban board only works if it shows three things at a glance: what is next, what is in progress right now, and what shipped. Add sprint velocity and a record book once that core view is reliable.
Explore the agile kanban cluster [CLUSTER_NAV]
Use this guide to pick your starting point, then jump to the specific job you need:
- How to Make a Kanban Board in Excel (Step-by-Step)
- Kanban Board Excel Template: What to Look For
- Excel Kanban Board: Keep Work Moving Without Jira
- Scrum Board Excel Template: Sprint Columns That Work
- Kanban Board Excel Template Free: When Free Is Enough
Decide what this board needs to do
Before picking a layout, write down why the team needs a board at all. Some teams only want a shared to-do list that shows status. Others are running real sprints with a backlog, a sprint goal, and a demo at the end. A flat list with a status column is enough for the first case. A dedicated Kanban Board sheet with lanes, work-in-progress limits, and story points is worth the extra setup for the second. Choosing the wrong scope early is the most common reason an Excel board gets abandoned by week three.
[TABLE: Recommended approach by team situation]
| Situation | Board choice | Why |
|---|---|---|
| One project, no formal sprints | Flat list with a status column | Fastest to build, easy to filter |
| Small dev or freelance team running sprints | DIY column board | Full control over fields and WIP limits |
| Recurring sprint cadence, want a history | Structured workbook | Velocity and a record book already built |
Build lanes that behave like a real kanban board
A kanban board is only useful if the lanes mean something specific. To-Do, In Progress, and Done is the smallest set that still functions: anything more granular (Backlog, Ready, In Progress, In Review, Done) is fine for a mature team, but it multiplies the columns everyone must keep updated. Whichever lane set you choose, give every card the same core fields: task name, owner, story points or size, and a due date or target sprint. In Excel, "lanes" are usually a status column filtered or grouped visually with conditional formatting rather than literal drag-and-drop columns — that trade-off is worth understanding before you build.
Warning: Do not create a new lane for every edge case. A card stuck between two statuses usually needs a note field, not a seventh lane that nobody remembers the meaning of by the next sprint.
Work-in-progress limits are what separate a kanban board from a plain checklist. Decide how many cards can sit in "In Progress" for one person at a time — two or three is typical for an individual contributor — and treat exceeding it as a signal to stop starting and start finishing. A simple conditional formatting rule that highlights the In Progress count when it crosses the limit does this without a single formula most people would call "advanced."
Track sprint velocity without extra software
Sprint velocity is just the total story points (or the number of tasks, if you are not sizing work) that the team completed in a sprint. Once cards carry a size and a "Done in sprint" date, a single SUMIFS formula can total completed points per sprint. Plot three or four sprints side by side and the trend tells you more than any single number does: a team that finishes 18, 20, and 19 points per sprint has a dependable planning number; a team that swings between 8 and 30 has a scoping or capacity problem worth discussing before the next planning meeting.
Product highlight: A three-sprint rolling average is usually a more honest planning number than the most recent sprint alone, because it smooths out one unusually good or bad week.
Keep a sprint record book for retrospectives
A sprint record book is a second sheet, separate from the live board, where you log each finished sprint: the sprint goal, the velocity, what carried over, and a short retro note. This is the piece most DIY boards skip, and it is the piece that makes the next planning conversation faster. Without it, "did we actually get faster this quarter" becomes a guess. With it, you can filter by sprint number and see the pattern in minutes.
The PlanoNest Agile Kanban Board Excel template bundles this structure so you are not building it from a blank sheet. It includes a Start Here onboarding tab, a Kanban Board sheet with To-Do, In Progress, and Done lanes, a Sprint Velocity sheet, and a Sprint Record Book for retrospective notes. It works in both Excel and Google Sheets and is available as a one-time purchase with instant digital download — no subscription, no seat limit.
Know when Excel is enough
Excel or Google Sheets is a solid choice for a team of two to eight people running sprints without needing real-time simultaneous card dragging, automated notifications, or integrations with a code repository. It is also a sensible bridge tool when you are testing whether an agile process fits your team before paying for dedicated software. Guidance on tables, filters, and data validation from Microsoft Support covers the mechanics; comparisons of dedicated boards from Atlassian or Monday are useful once your team outgrows a spreadsheet.
Move to dedicated software when multiple people need to edit the same card simultaneously, when you need automatic notifications or approval workflows, or when the board needs to connect directly to a code repository or ticketing system. That is not a failure of the spreadsheet — it is a sign the team's process has grown past what a shared file can safely coordinate.
A short setup checklist
- Decide your lane set: the simple three-lane version or a more granular one your team already understands.
- Give every card an owner, a size, and a target sprint.
- Set a WIP limit per person and make it visible with conditional formatting.
- Add a Sprint Velocity sheet that totals completed points per sprint automatically.
- Keep a Sprint Record Book for goals, carryover, and retro notes.
- Review the board at the start and end of every sprint, not only when something goes wrong.
Review before your next sprint starts
The most useful review happens before planning, not after a problem shows up. Check for cards with no owner, no size, or a status that has not changed in over a week — those are the ones worth discussing out loud rather than letting them roll forward silently. Compare the last two or three sprints' velocity and ask whether the team is planning to a number that matches reality.
Keep the conversation practical: can anyone on the team look at the board and know what is next, what is active, and what shipped? If not, the fix is almost always a clearer lane definition or a missing field, not a bigger spreadsheet. A dependable board with an honest velocity number will do more for a small team's planning than a feature-heavy tool nobody updates consistently.
FAQ
Does Excel have a Kanban board?
Excel does not have a native drag-and-drop kanban view, but you can build one using a status column, filters or grouping, and conditional formatting to represent lanes. A ready-made template speeds this up considerably.
How do I create a Kanban board in Excel?
Set up a table with task, owner, status, story points, and sprint fields, then use Data Validation to control the status values and conditional formatting to visually separate To-Do, In Progress, and Done.
What are the 4 rules of Kanban?
Common summaries include: visualize the workflow, limit work in progress, manage flow, and continuously improve based on what the board shows you. A simple Excel board can support all four if the fields and WIP limits are set up deliberately.
Does Microsoft have a Kanban tool built in?
Microsoft offers kanban-style views inside Planner and some Project templates, but plain Excel requires you to build the lane behavior yourself with status columns and formatting, which this guide and template are designed to shortcut.
Disclosure
PlanoNest sells this template. Links to PlanoNest products and collections point to our own digital template shop.
About the author
Robin is the independent maker behind PlanoNest, creating practical Excel, Google Sheets, and Notion templates for clearer day-to-day operations.
