A kanban board shows work as cards that move across columns such as To Do, Doing and Done. It makes the state of a project visible at a glance, limits how much work is in progress and helps a small team stay focused. Many people use online tools for this, but you can build a simple, free board in Excel. The best approach keeps all tasks in one table with a Status column, and then uses formulas to show each status in its own column on a board sheet. When you change a status, the card moves by itself. This guide shows how to build the task table, the board, the counts and the work-in-progress limit, with a small example you can check by hand.
Updated November 2026
In this guide
- How the Excel board works
- Example data
- Step 1: create the task table
- Step 2: add the status drop-down
- Step 3: set up the board sheet
- Step 4: fill the columns with FILTER
- Step 5: show the owner and due date on each card
- Step 6: count the cards
- Step 7: add a work-in-progress limit
- Step 8: color the cards
- If you do not have FILTER
- Use the board with a team
- Common mistakes
- Practice problems
- Quick recap
How the Excel board works
There are two ways to build a board. The manual way is to put cards in cells and cut and paste them between columns, which is fast to start but easy to break. The better way, used in this guide, is to keep one table of tasks, where each row is a task with a status, and to build the board from it with formulas. You change the status with a drop-down in the table, and the board updates. This also keeps the data clean, so you can count, sort and filter the tasks as well.
Example data
Use eight tasks for a small marketing project. Write blog post, Design banner and Plan email are To Do. Record video, Edit photos and Update website are Doing. Set up analytics and Buy domain are Done. So the board starts with 3 tasks in To Do, 3 in Doing and 2 in Done, and the total is 8. These counts will help you check the formulas. Each task also has an owner and a due date, so the table has four columns: Task, Owner, Due and Status.
Step 1: create the task table
On a sheet called Tasks, type the headers Task, Owner, Due and Status in A1:D1, enter the eight tasks and press Ctrl+T to make a table. Name it TaskList in Table Design. The table grows when you add a task, and the board formulas include the new row automatically. Format the Due column as a date. If you have never used tables, read our table guide first.
Step 2: add the status drop-down
Select the Status column cells, go to Data, Data Validation, choose List and type To Do,Doing,Done. Now each task has a drop-down with exactly three values. Spelling matters, because the board formulas compare the text. Set the error alert to Stop so that no other value can be typed. Our drop-down list guide explains how to do this step by step and how to use a named range as the source.
Step 3: set up the board sheet
Add a new sheet called Board. In A1 type To Do, in C1 type Doing and in E1 type Done, with empty columns between them for spacing. Make the headers bold with a fill color, and widen the columns so the task names fit. Under each header, the formulas will list the tasks with that status. You can add a count in row 2 under each header, which shows how many cards are in the column. The board is now ready for the formulas.
Step 4: fill the columns with FILTER
In Excel 365 and Excel 2021, use FILTER. In A3 type =FILTER(TaskList[Task],TaskList[Status]="To Do",""). Excel spills the matching tasks down the column. In C3 use the same formula with Doing, and in E3 with Done. The empty string at the end shows blank instead of an error when no task matches. For our example, To Do lists three tasks, Doing lists three and Done lists two. Our FILTER guide explains the function in detail.
Step 5: show the owner and due date on each card
A card is more useful with the owner. Filter a combined text instead of the task name, so each card reads like Write blog post – Sara. Use =FILTER(TaskList[Task]&" - "&TaskList[Owner],TaskList[Status]="To Do",""). You can also add the due date with TEXT, such as TEXT(TaskList[Due],"d mmm"). Keep the card text short, so it fits the column. The board then shows who does what and by when, which is exactly what a team needs in a quick meeting.
Step 6: count the cards
Under each header, count the tasks with COUNTIF. For the To Do column, use =COUNTIF(TaskList[Status],"To Do"), which returns 3. For Doing it returns 3 and for Done it returns 2. A total of =ROWS(TaskList[Task]) gives 8. A completion percentage is the Done count divided by the total, which is 2 divided by 8, or 25 percent. Show it at the top of the board, with a percent format. These numbers tell the team how far the project has come.
Step 7: add a work-in-progress limit
A key idea of kanban is to limit the work in progress, so people finish tasks before starting new ones. Put a limit, for example 3, in a cell beside the Doing header. Then use conditional formatting on the Doing count so that it turns red when the count is above the limit. With 3 tasks in Doing and a limit of 3, the cell is normal. If someone moves a fourth task to Doing, the count becomes 4 and turns red, and the team knows to finish something first.
Step 8: color the cards
Use conditional formatting on the board cells to show urgency. A rule that colors a card red when its due date is in the past needs the date, so add a hidden helper table or use the table sheet for this. Simpler is to color the three columns differently: light red for To Do, light yellow for Doing and light green for Done. The color of the column tells the status at a glance. You can also add a data bar to the count under each column. Keep it simple, since a busy board is hard to read.
If you do not have FILTER
Older versions of Excel do not have FILTER. In that case, add a helper column in the task table that numbers the tasks in each status, for example =COUNTIF(D$2:D2,D2), which gives 1 for the first To Do task, 2 for the second and so on. Then on the board, use INDEX and MATCH to find the first, second and third task of each status. It is longer to set up, but it works in all versions. A PivotTable with Status in the columns and Task in the rows is another quick option, which you can refresh after changes.
Use the board with a team
Save the file in a shared place where the team can edit it at the same time, such as OneDrive or SharePoint. Agree on rules: each person updates their own status, the board is reviewed in a short weekly meeting, and no one deletes tasks without a note. Add a Notes column for blockers. Keep a copy of the done tasks on an Archive sheet at the end of each month, so the board stays short and fast. Our project tracker guide shows a longer version with dates and costs.
Common mistakes
The most common mistake is to type statuses by hand with different spellings, so some tasks vanish from the board. Another is to have too many tasks in Doing, which defeats the purpose. A third is to forget the empty string in FILTER, which shows errors in empty columns. A fourth is to place something under the spill range, which causes a spill error. A fifth is to build the board but never update the table. A sixth is to use too many columns. Three or four columns are enough for most teams.
Practice problems
Try these. Problem 1: with 3 To Do, 3 Doing and 2 Done, the total is 8. Problem 2: the completion percentage is 2 divided by 8, which is 25 percent. Problem 3: move Record video to Done and check that the Doing count becomes 2 and the Done count becomes 3, so completion becomes 37.5 percent. Problem 4: add a ninth task with the status To Do and check that the board shows it. Problem 5: set the limit for Doing to 2 and check that the cell turns red when there are 3 tasks.
Quick recap
Keep all tasks in one table with Task, Owner, Due and Status columns. Add a drop-down for the status, and build a Board sheet with a FILTER formula under each column header. Count the cards with COUNTIF, show the completion percentage, and set a work-in-progress limit for the Doing column with a color rule. Use a helper column with INDEX and MATCH if your Excel has no FILTER. Update the status in the table, and the board follows.
Frequently asked questions
How do I make a kanban board in Excel?
Keep tasks in a table with a status drop-down and show each status in a column with FILTER.
What columns does a kanban board have?
Usually To Do, Doing and Done.
What is a work-in-progress limit?
It is the maximum number of tasks allowed in the Doing column at one time.
Does this work without FILTER?
Yes, with a helper column and INDEX and MATCH.
How do I move a card?
Change its status in the task table, and the board updates.


