1. Home
  2. Templates
  3. Kanban board Excel template

Free Kanban board Excel template

List your tasks once, pick a status from a drop-down, and the board fills itself: To do, In progress, Review, Done, with a card count per column. Built with formulas only, so it works in Excel, Google Sheets and LibreOffice.

4 columns · WIP counts · Excel, Google Sheets, LibreOffice · free

The online version of the same board: drag a card to the next column, then go full screen to keep it.

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

  1. Type your tasks in the Tasks sheet, one per row, with an owner if you work in a team.
  2. Pick a status for each task. The card jumps to the right column on the Board sheet.
  3. Set your WIP limit for In progress. One or two cards per person is a good start.
  4. 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 templateGanttmint online
Move a cardChange its statusDrag it
WIP countYes, with formulasVisible per column
Dates and dependenciesDue date onlyFull Gantt chart view
ShareSend the fileRead-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.