How to make a Kanban board in Excel that actually works
A useful Kanban board is not three decorated lists that you drag tasks between. It is one clean task table feeding a board, a calendar, filters, and a project overview—all from the same data.
Written by Joshua Cottrell-Schloemer, 2× Microsoft Excel MVP and designer of the formula-driven Big Excel Energy Kanban Board. Updated July 16, 2026.To make a Kanban board in Excel, keep every task in one structured table and treat the board columns as views of that data. Use a controlled Stage field to place each task in Backlog, To Do, Doing, Review, or Done; then build the visible columns with formulas, add filters for board and owner, and reuse that same table for the calendar and summary.
The task list is the product. The board is a view.
The fastest way to make a fragile Kanban board is to type tasks directly into visual columns. It looks right for a week. Then someone needs to filter by owner, see what is overdue, build a calendar, or calculate how much work is stuck in progress—and the board has no underlying structure to answer any of it.
I build these the other way around. One row represents one task. The row carries the task's stage, owner, dates, priority, and project. The board simply asks, “Which rows belong in this column right now?” That separation between the data and the view is what makes the workbook maintainable.
One task table
Task, board, stage, owner, priority, dates, and notes live in one clean source of truth.
Many useful views
Kanban columns, a calendar, owner filters, and project metrics all read from the same rows.
The columns worth keeping
The goal is not to document every possible detail. It is to store the few fields that change where a task appears or what someone decides next.
Start with a clean sample task list
Download a small fictional CSV with the recommended fields and realistic task data. Open it in Excel, convert it to a Table, and use it to test your formulas before connecting real work.
Seven steps from table to working board
Make one Excel Table
Put one task on each row and convert the range to a Table. Tables expand with new work, carry formulas down, and give your formulas names instead of mystery coordinates.
Control the settings
Store valid stages, boards, owners, and priorities on a Settings sheet. Use Data Validation dropdowns so “Doing,” “In progress,” and “WIP” do not become three accidental stages.
Return tasks by stage
In Microsoft 365, FILTER is the cleanest way to return rows for the stage above each column. For older Excel, INDEX/MATCH with AGGREGATE can build the same filtered result without macros.
Design the card hierarchy
Make the task name the first read. Owner, due date, and priority are supporting information. If every field is equally loud, the card stops helping.
Add filters and signals
Filter by board or person, then use restrained conditional formatting for overdue dates, blocked work, and priority. Color should answer a question, not fill empty space.
Reuse the same table
Build the calendar and overview from the task table—not copied versions of the board. Count work by stage, owner, and due date so the summary stays honest.
Test the awkward cases
Empty stages, long names, blank owners, overdue tasks, and too many cards are not edge cases for long. A good board has a deliberate answer for all of them.
Modern Excel and older Excel can both do it
In Microsoft 365, the basic pattern is simple: return the tasks where the Stage column equals the heading above the Kanban column. A small version looks like this:
That is enough for a proof of concept. A polished board usually needs several fields per card, sorting, blank handling, and space for more tasks. In older Excel, the same logic can be built with AGGREGATE to find matching row numbers and INDEX/MATCH to return the card fields. It is less elegant, but it is durable—and it avoids requiring every person who opens the file to have the newest Excel.
A Kanban board should be fast to scan
The board is an interface. The visual design should reduce the time it takes to answer “What is happening?”
Keep the stages boring
Four or five clear stages usually beat eleven precise ones. More columns feel sophisticated until nobody can agree where a task belongs.
Use color as a signal
Reserve strong color for overdue, blocked, or genuinely important work. A different bright color on every card destroys the hierarchy.
Show the next decision
Task, owner, due date, and priority are often enough. Move the rest to the source row or a detail area.
Leave room for reality
Columns need whitespace and a plan for overflow. If ten cards make the entire sheet collapse, the layout was a mockup, not a system.
Excel versus Trello or a project-management app
| Need | Excel is a good fit | A dedicated app is a good fit |
|---|---|---|
| Ownership | You want one self-contained file with no additional account or subscription. | You want a shared workspace managed centrally. |
| Customization | You need full control over fields, formulas, calculations, and presentation. | You prefer a supported workflow with less workbook maintenance. |
| Collaboration | A small group updates the file in a controlled way. | Many people need live comments, notifications, permissions, and simultaneous updates. |
| Reporting | The tasks need to connect to other spreadsheet analysis or a custom dashboard. | You need built-in automation, integrations, and team activity history. |
Excel is not automatically the clever choice just because the work can fit in cells. Use it when ownership, familiarity, analysis, and design control matter more than live collaboration. If the team needs alerts, comments, complex permissions, and constant simultaneous editing, use the project-management tool built for that job.
Common Excel Kanban mistakes
The work-ready version
Excel Kanban Board
This is the polished version I built: a fully functioning formula-driven board with an overview dashboard, calendar page, filters, and editable settings. No macros, no add-ins, and no subscription. It works back to Excel 2013 on Windows and Excel 2016 on Mac.
See the template →Kanban in Excel, answered
Can you make a Kanban board in Excel?
Yes. The reliable structure is one task table feeding formula-driven stage views. That keeps the board, calendar, filters, and summary tied to the same source instead of turning each column into a separate list.
What columns should the task list have?
Start with task, board or project, stage, owner, priority, start date, due date, and notes. Add fields only when they change a decision or support a view you actually use.
Do I need macros?
No. FILTER is the simplest approach in Microsoft 365. INDEX, MATCH, and AGGREGATE can support older versions. The Big Excel Energy Kanban template uses formulas and does not require macros or add-ins.
Is Excel better than Trello?
Excel is useful when the work already lives in spreadsheets and you want a self-contained file with full control. Trello or another project-management app is better for live collaboration, notifications, comments, automations, and many simultaneous users.
How many stages should a Kanban board have?
Use the fewest stages that describe meaningful changes in the work. Backlog, To Do, Doing, Review, and Done is a practical starting point. If two stages do not change ownership, expectations, or the next action, they may not need to be separate.
Related Excel project-management resources
Project-management templates
Kanban, dynamic reporting, dashboard, and progress templates for work that still needs to live in Excel.
Browse the collection →Dashboard design principles
Hierarchy, restrained color, honest charts, and the systems that keep a report readable.
Read the guide →Excel dashboard layout
Build the page on a grid with real margins, consistent gutters, and intentional whitespace.
Learn the layout →