A kanban board template in Excel is a five-stage workflow (Backlog, To Do, In Progress, Review, Done) where every task is a row and moving a task means changing one cell. You do not need a download to get one. Build it as a single table with a Status column, add a COUNTIF that counts each stage, and the sheet will tell you when you have taken on too much. This post gives the layout, the two formulas that do the real work, and the point where a spreadsheet stops being the right place for the board.
Why most kanban board template Excel downloads disappoint
The free templates on offer are almost all the same file. Five labelled blocks across the top of a sheet, a handful of coloured rectangles underneath, and each rectangle holding a task name, a short description, an owner and a due date. The instruction for moving a task forward is to copy the rectangle and paste it under the next heading.
That works for a screenshot and falls apart in week two. Copy and paste is a manual operation with no record of what moved or when. The coloured blocks are usually merged cells, and merged cells break sorting, filtering and every formula you might later want to point at them. You end up with a picture of a board rather than a board.
The version below avoids all of that by inverting the layout. The board is one table, and the columns you see across the top of a kanban board become values in a single Status field.
What columns should the board have?
Five stages covers most work, and each one needs a rule for when a task is allowed to leave it. A stage without an exit condition turns into a parking space.
| Stage | What sits here | A task leaves when |
|---|---|---|
| Backlog | Everything agreed but not scheduled | You have decided to work on it this week |
| To Do | This week's work, already prioritised | You actually start it |
| In Progress | Open on your desk right now | The work itself is finished |
| Review | Waiting on a check, a reply or an approval | The check comes back |
| Done | Finished this week | The week ends and you archive it |
Review is the stage people delete first and the one worth keeping. Work waiting on somebody else looks identical to work in progress on a three-column board, so the two get counted together and the reason for a stalled week stays invisible. Splitting them is what makes the count in the next section mean something.
Add Blocked only if you genuinely track blockers, and add Testing only if there is a separate person or step doing it. Every extra stage costs a filter click. If you want the reasoning behind the stages themselves rather than the spreadsheet, what kanban actually is covers the method, and seven kanban board examples sets out the column layouts other workflows settle on.
How do you build a kanban board template in Excel?
Six steps, about twenty minutes. Start on a blank sheet.
1. Make one table, not five blocks. Put these headers in row 1:Title, Status, Owner, Due, Tags, Notes. Select them, press Ctrl+T, and confirm that the range has headers. Name the table Board in the Table Design tab. Every formula below refers to that name, which is why they keep working when rows are added.
2. Turn Status into a drop-down. Select the Status column, open Data > Data Validation, choose Allow: List, and type the stages separated by commas: Backlog,To Do,In Progress,Review,Done. A task now moves by picking a value from a list, and a typo cannot create a sixth stage that quietly hides work.
3. Count each stage. On a second sheet, or in a clear block to the right, list the five stage names in a column and put this next to the first one, then fill down:
=COUNTIF(Board[Status], H2)
COUNTIF takes a range and a criterion and returns how many cells match (Microsoft documents the syntax here). Because it points at the table column rather than a fixed range, the count updates the moment you add a row.
4. Make the WIP limit real. Next to the In Progress count, type your limit in its own cell. Say the count is inI4 and the limit in J4. Select I4, open Conditional Formatting > New Rule, choose "Use a formula to determine which cells to format", and enter:
=$I$4>$J$4
Give it a red fill. The cell now turns red the moment you take on more than you decided to. Formula-based rules have to return TRUE or FALSE, and they are the only kind that can compare two cells like this, which is the rule type Microsoft calls out separately.
5. Flag what is overdue. Select the whole table body, add another formula rule, and enter=AND($D2"", $B2<>"Done") with an amber fill. Anchoring the column with a dollar sign and leaving the row free is what makes the rule apply across the row. The empty check stops every task without a date from lighting up.
6. Get a board view. Click the filter arrow on Status and tick one stage to see it alone. On a formatted table you can also add a slicer from the Insert tab, which gives you five buttons that switch stages in one click. That is as close to a board as a spreadsheet gets, and for a solo backlog it is close enough.
The result is a file that counts its own work in progress. None of the downloadable templates do that, which is odd, because counting is the only thing a spreadsheet can do that a wall of sticky notes cannot.
What should your WIP limit be?
Start at two per person for In Progress and leave Review uncapped for the first fortnight. Two is low enough to be uncomfortable, and the discomfort is the mechanism: when the cell goes red you have to finish something before starting the next thing. A limit you never hit is not teaching you anything.
Watch the Review count instead of guessing. If it climbs week after week while In Progress stays flat, your problem is not capacity, it is that nothing is coming back from whoever reviews. That is a conversation rather than a scheduling change. WIP limits explained goes into the numbers and how to raise them without losing the effect.
When does a spreadsheet stop working?
Sooner than the template vendors suggest, and the failure is always the same one: a second person.
Two people in one file means either a shared drive with a lock, or a cloud copy where both of you edit the same cell and one of you loses. The sheet also has no per-task history, so nobody can answer when a task moved to Review or how long it sat there. There is no place for a screenshot or a contract PDF next to the task it belongs to, and on a phone a wide table is close to unusable. Notifications do not exist, so the person waiting on the review has to remember to look.
For a solo backlog under a hundred tasks, none of that matters and the sheet is genuinely the right tool. Past that, or past one person, you are maintaining the board instead of using it. If you are weighing the move, kanban vs Trello compares what the alternatives cost you in setup.
How do you move an Excel board into a kanban app?
The layout above is already the export format, which is the other reason to build it as one table. Use File > Save As and pick CSV UTF-8. Keep the headers as Title, Status, Owner, Due, Tags and Notes, because those are the names importers recognise without you mapping anything by hand.
Two things to check on the way out. Excel in a German or other European locale writes semicolons instead of commas as the separator, so a good importer has to detect that, and it also writes a byte-order mark at the start of the file that a naive parser reads as part of your first header. If an import produces one giant column or a header called ?Title, that is which of the two went wrong.
The same route out exists from a note app, with more friction: kanban in OneNote covers the three ways to build a board there and why only one of them leaves you with a table you can export.
EasyKanban reads that CSV directly and lets you map each source column to a role before anything is written, up to 500 tasks and 20 stages per board. You can open a board without signing up and see the result before deciding anything. The free plan covers 3 boards with unlimited cards and 3 team members per board, which is past the point where the spreadsheet was fighting you.
Frequently asked questions
Is there a free kanban board template for Excel?
Plenty of them, and most are a picture of a board rather than a working one. Building your own takes about twenty minutes and gives you something a download cannot: a table that sorts and filters, a COUNTIF that tracks work in progress, and a file you can export cleanly when you outgrow it.
Can Excel enforce a WIP limit?
Not enforce, but flag, which in practice does the same job. A COUNTIF over the Status column gives you a live count per stage, and a conditional formatting rule comparing that count against a limit cell turns it red when you go over. Excel will not stop you starting a sixth task. It will make the sixth one obvious.
How many columns should a kanban board have?
Five is a good default: Backlog, To Do, In Progress, Review and Done. Three works for personal work with no handoffs. Go past five only when a stage has its own owner or its own waiting time, because every extra stage is another decision each time a task moves and another filter to click.
Does the same approach work in Google Sheets?
Yes, with two renames. Data Validation sits under Data > Data validation and behaves the same, and conditional formatting by formula lives under Format > Conditional formatting with the "Custom formula is" option. COUNTIF is identical. Sheets handles two people editing at once far better, so it buys you more time before the ceiling.
Can I import an Excel kanban board into a kanban tool?
Yes. Save the sheet as CSV UTF-8 and import it. Most tools ask you to map your columns to theirs, so the header names matter less than having one row per task and a single Status column. A board built as five separate blocks of merged cells is the version that cannot be imported.