Kanban Board Template in Excel: Columns, WIP Limits and Cycle Time That Update Themselves
How to build a Kanban board template in Excel: one table of cards, board columns filled automatically with FILTER, work-in-progress limits, overdue alerts and cycle time, with a customer support team example.
A Kanban board template in Excel organizes work into columns by status (To do, In progress, Waiting, Done), with each task as a card that moves left to right as it progresses. The most reliable way to build one is to keep every card in a single data table and let formulas place the cards in the right column. Changing a card’s status “moves” it, and Excel can count work in progress, flag overdue cards and measure how long work takes to finish. This guide walks through the setup for a small team.
Step 1: the card table
| Column | Example | Used for |
|---|---|---|
| Card ID | K-118 | Referring to the task |
| Task | Refund request from order 5521 | Text shown on the board |
| Owner | Jordan | Filtering by person |
| Status | To do, In progress, Waiting, Done | Which column the card appears in |
| Priority | High, Medium, Low | Order within a column |
| Started, due, finished | Dates | Overdue alerts and cycle time |
Format the range as a Table named Cards and use drop-down lists for Status, Owner and Priority.
Step 2: the board view
On a Board sheet, each column is a status. In Excel 365, the top cell of each column uses FILTER to pull the cards with that status, sorted by priority:
=SORTBY(FILTER(Cards[Task]&" – "&Cards[Owner],Cards[Status]="In progress",""),FILTER(Cards[PriorityNum],Cards[Status]="In progress",""),1)
PriorityNum is a helper column that turns High, Medium and Low into 1, 2 and 3. Google Sheets has no SORTBY: wrap FILTER in SORT instead and use normal ranges in place of table names. Widen the columns and turn on text wrapping so cards are readable. In older versions without FILTER, work directly in the table with filters and color the rows by status with conditional formatting.
Step 3: work-in-progress limits
The heart of Kanban is not the columns but the limit on how much work is in progress at once. Less work half-done means work gets finished sooner. Put a limit above the column and warn when it is exceeded:
- Cards in progress:
=COUNTIF(Cards[Status],"In progress") - Warning:
=IF(InProgress>Limit,"Over limit: finish before starting more","") - Per person:
=COUNTIFS(Cards[Owner],A2,Cards[Status],"In progress")
Step 4: overdue cards and cycle time
- Overdue:
=IF(AND([@Status]<>"Done",[@Due]<TODAY()),"Overdue",""), in red. - Cycle time for a card:
=IF([@Finished]="","",[@Finished]-[@Started]) - Average over the last 30 days:
=AVERAGEIFS(Cards[Cycle],Cards[Finished],">="&TODAY()-30) - Finished this week:
=COUNTIFS(Cards[Finished],">="&TODAY()-WEEKDAY(TODAY(),2)+1)
Example: a four-person customer support team
| Metric | Value |
|---|---|
| To do / In progress / Waiting on customer | 12 / 7 / 4 |
| Team WIP limit | 6 (over by 1) |
| Overdue cards | 3 |
| Finished this week | 21 |
| Average cycle time (30 days) | 1.6 days |
Seven cases are open with a limit of six, and three are past their due date. The morning stand-up starts with the overdue cards and the one person holding three open cases, before anyone takes a new ticket. Over a few weeks, the cycle time trend shows whether changes such as a new reply template actually speed things up.
Kanban, to-do list or Gantt?
- Kanban: a continuous flow of small tasks, such as support, marketing or maintenance requests.
- To-do list template: simple tasks sorted by date.
- Gantt chart: projects with phases, key dates and dependencies.
A larger project can use all three: a Gantt chart or the project management template for the overall plan, a Kanban board for the week, and the RACI matrix to make responsibilities clear. Status for leadership goes in the project dashboard. More guides are in Project Management.
Frequently asked questions
What columns should a Kanban board have?
At least To do, In progress and Done. Many teams add Waiting or Review to see where work gets stuck.
What WIP limit should I set?
Start with the number of people on the team or slightly more, watch for a few weeks and adjust.
Excel or a dedicated Kanban tool?
Excel is enough for a small team and makes reporting easy. If you need drag and drop, notifications and comments on each card, a dedicated tool is more convenient.
Does it work in Google Sheets?
Yes, with one change: Google Sheets has no SORTBY, so wrap FILTER in SORT and use normal ranges instead of table names. FILTER, COUNTIF and AVERAGEIFS work as in Excel, and the whole team can update statuses from their phones.