How to Make a Kanban Board in Excel (Step-by-Step)

If you already know a spreadsheet is the right starting point, this is the exact build. Grab ten real tasks before you start — it is much easier to design fields around actual work than around guesses, and it exposes gaps a blank template hides.

Where this fits in the kanban cluster

This guide covers the build only. For a wider comparison of free, DIY, and paid options, plus sprint velocity and a retrospective record book, read the Agile Kanban Board Excel guide first.

Step 1: List your columns before opening Excel

Decide your lane names on paper first: To-Do, In Progress, and Done is the smallest set that still functions. A more granular set — Backlog, Ready, In Progress, In Review, Done — suits a team that already separates coding from review. Whichever you pick, write it down once so nobody invents a sixth status later.

Naming conventions that scale beyond one board

If you expect to run more than one board eventually — one per project, or one per client — agree on the naming pattern before you build the first one. A short prefix in the file name or a Project column inside a single shared workbook both work; what matters is picking one approach on purpose instead of ending up with three slightly different layouts because each board was built by a different person on a different day.

Step 2: Turn your range into a real Excel Table

Select your data and use Insert > Table (or Ctrl+T). A real Table gives you structured references, rows that expand automatically as you add cards, and filtering that stays reliable as the sheet grows — a plain range loses all of that the moment someone inserts a row in the wrong place.

[TABLE: Minimum card fields to include]

Step 3: Add a Status dropdown with Data Validation

Open the Data tab, choose Data Validation, and set the Status column to a List sourced from a short lookup range on a hidden sheet, or type your lane names directly separated by commas. This prevents "in progress," "In-Progress," and "doing" from splitting one lane into three different filter results.

Step 4: Simulate lanes with filters or conditional formatting

Excel does not move cards between physical columns on its own, so a workable board usually takes one of two shapes: a filtered or grouped table sorted by status, or a single sheet where conditional formatting colors each row by its Status value so the lanes are obvious at a glance even in one long list. Either approach beats a static, screenshot-style board that nobody actually updates.

Step 5: Add a WIP limit check

Use a COUNTIFS formula to count cards where Owner equals a person and Status equals "In Progress," then add a conditional formatting rule that turns the count red once it passes your limit — two or three per person is a common starting point.

Step 6: Test it with ten real cards before rolling it out

Enter real backlog items, not placeholder text, and watch for missing fields or awkward status names. Ask two teammates to update one card each without instructions and see whether your naming convention holds up without you explaining it.

Skip the build with a ready-made workbook

The PlanoNest Agile Kanban Board Excel template already has these lanes, a Sprint Velocity sheet, and a Sprint Record Book wired together, so you start from a working system instead of a blank grid. It works in Excel and Google Sheets and is a one-time purchase with instant digital download. For more manual formatting tricks if you prefer to build your own, MakeUseOf's Excel kanban walkthrough is a useful reference.

A build checklist

1. Write your lane names on paper before opening Excel.
2. Convert the range into a Table (Ctrl+T).
3. Add Task, Owner, Status, Story points, and Due date columns.
4. Set Data Validation on Status so only your lane names are selectable.
5. Apply conditional formatting rules keyed to each status value.
6. Add a WIP count formula and a rule that flags it when it is exceeded.
7. Test with ten real cards, not placeholders, before rolling it out to the team.

Fix these before day one

The same mistakes show up in almost every first attempt: too many lanes that duplicate each other's meaning, no owner field so accountability is unclear, no WIP limit so "In Progress" absorbs everything, and personal notes typed into the task name instead of a separate notes column. Fixing these before the first real sprint is far easier than untangling them after twenty cards are already in the sheet.

Handle swimlanes and priority without adding lanes

If you need to separate work by project, priority, or workstream, resist adding a second set of status values to do it. Add a plain "Priority" or "Track" column instead, then group or sort by that column on top of Status, or add a second conditional formatting rule keyed to priority so urgent cards stand out with their own color without duplicating the status logic. A quick filter by Owner gives anyone a personal "my board" view of only their own cards, which is often all an individual contributor needs during a busy week.

Make it easy to read in a stand-up

Freeze the header row (View > Freeze Panes) so column labels stay visible while scrolling, hide columns you rarely reference during a quick check, and sort by Status then Owner before the meeting starts. If some attendees do not have direct access to the file, a printed view or PDF export of the current board works for a single meeting — just remember a printout loses live status the moment someone updates a card afterward, so pair it with the shared file, not in place of it.

Save versions so a bad edit doesn't cost you a sprint

A shared spreadsheet has no built-in undo across sessions the way dedicated software keeps a full edit history automatically. Keep a dated backup copy weekly, or rely on File > Version History if you are working in Excel Online or Google Sheets. That small habit is what saves you when someone sorts a range without selecting every column and scrambles the relationship between Task, Owner, and Status across dozens of rows.

FAQ

Can Excel actually do drag-and-drop kanban cards?

Not natively. Moving a card between lanes means changing its Status value, which then re-sorts or re-colors automatically once you have filters or conditional formatting set up. It behaves like a kanban board without physical drag-and-drop.

What formula tracks WIP limits automatically?

A COUNTIFS formula that counts rows matching an owner (or the whole board) and a specific status value works well; pair it with a conditional formatting rule that highlights the count once it passes your limit.

Should I use one sheet or multiple tabs for a kanban board?

One sheet is usually enough for a single board. Use a second tab only for a status lookup list, or for a Sprint Velocity and Sprint Record Book if you are running formal sprints.

How many columns does a basic kanban board need?

Five is a workable minimum: task, owner, status, size, and due date or target sprint. Add more only once you know a specific question those extra fields will answer.

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.