What’s inside the Excel file
- Tasks sheet: one row per card, with the task, the owner, the due date and a status picked from a drop-down list.
- Board sheet: four columns, To do, In progress, Review and Done. Each card appears in its column automatically, through INDEX and MATCH formulas.
- WIP counts at the top of each column, and a WIP limit cell for In progress: the count turns red when the limit is exceeded.
- How to use: a short guide on a third sheet.
No macro and no add-in, so it opens anywhere, including Excel for Mac and Google Sheets.
How to use the template
- Type your tasks in the Tasks sheet, one per row, with an owner if you work in a team.
- Pick a status for each task. The card jumps to the right column on the Board sheet.
- Set your WIP limit for In progress. One or two cards per person is a good start.
- Review the board together for five minutes a few times a week, and move cards by changing their status.
Why a Kanban board in Excel?
A spreadsheet is fine when the board lives on a shared drive, when your company blocks new tools, or when you need to report on tasks with filters and formulas. Its limit is that you can’t drag cards: you change a status instead. If you want drag and drop, sharing by link and a timeline of the same tasks, use the free online Kanban board and export to Excel when someone asks for the file.
| Excel template | Ganttmint online | |
|---|---|---|
| Move a card | Change its status | Drag it |
| WIP count | Yes, with formulas | Visible per column |
| Dates and dependencies | Due date only | Full Gantt chart view |
| Share | Send the file | Read-only link, or export to Excel, PNG, PDF |
New to Kanban?
Read what Kanban is and how it works, with the six core practices and WIP limits explained. If your project also has deadlines, pair the board with one of our Excel Gantt chart templates.
Questions
Is the Kanban board Excel template free?
Yes. Download it and use it for personal or commercial projects.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets: the drop-downs and formulas keep working.
How many cards can the board show?
Up to 30 cards per column. Add rows to the Board sheet and copy the formulas down for more.
Can I rename the columns?
Yes. Change the status names in the Lists column of the Tasks sheet: the board headers and the drop-downs follow.
Can I drag cards in Excel?
No. In Excel you change the status. For drag and drop, use the free online Kanban board.