The Kanban Method’s creator, David J. Anderson, built the whole system around one rule: a column should only exist where work actually waits. A spreadsheet can respect that rule, right up until it can’t.
Most people reach for Google Sheets because it’s free and already open in another tab, then slowly start spending more time cutting, pasting, and re-fixing broken formatting than moving work forward.
For a solo content calendar or a 20-card project, that trade is worth it. Past that, it isn’t.
This guide shows you how to build a Google Sheets Kanban board in about 20 minutes, and the exact point where it starts costing you more than it saves.
TL;DR
Google Sheets can handle a simple Kanban board if you need a lightweight workflow without extra software.
- Setup: ~15-20 min using status columns, formatted card slots, and reusable templates.
- Two ways to move cards: Manual cut-paste (keeps formatting, breaks easily) or a FILTER formula (auto-updates, shows plain text).
- Use Sheets when: Solo or small team, under ~20 cards, 3-6 columns, low automation.
- Switch tools when: Multiple editors, status-based automation, or you’re tracking cycle time/throughput/WIP.
For small teams or temporary workflows, Sheets works fine. For anything more complex, dedicated Kanban tools save time fast.
Kanban Board in Google Sheets
- Should You Use Google Sheets for Kanban?
- How to Create a Kanban Board in Google Sheets
- Common Google Sheets Kanban Mistakes (And How to Avoid Them)
- Free Kanban Board Templates for Google Sheets
- Pros and Cons of Google Sheets Kanban Boards
- When to Use a Dedicated Kanban Tool Instead of Google Sheets
- How We Run Kanban Boards in ClickUp
- Build a Google Sheet Kanban Only For Simple Workflows
- Frequently Asked Questions About Kanban Boards in Google Sheets
Summarize this article for me pleaseShould You Use Google Sheets for Kanban?
Before building one, it helps to know where spreadsheet Kanban fits best.
| If your workflow looks like this… | Typical board size | Team size | Automation needs | Best fit |
|---|---|---|---|---|
| Personal task tracking or a solo content calendar | Under 20 active cards | 1 person | None | Google Sheets |
| Small internal project tracking with occasional updates | 20–40 cards | 2–5 people | Low | Google Sheets (short-term) |
| Cross-functional workflows with recurring handoffs | 40+ cards | 5–10 people | Moderate | Dedicated Kanban tool |
| Workflows requiring status-based triggers, reporting, or dependencies | Any size | Multiple teams | High | Dedicated Kanban tool |
| High-volume operational pipelines | 50+ cards | 10+ people | High | Dedicated Kanban tool |
Summarize this article for me pleaseHow to Create a Kanban Board in Google Sheets
The whole setup is pretty quick: you create status columns like To Do, In Progress, and Done, format the sheet to resemble a board, and then add reusable task cards to move between stages. Let’s walk through the fastest way here:
Step #1: Set the column headings
Your column headings define the workflow stages every task card passes through. Getting these right upfront saves you from restructuring the Kanban board later:
- Open a new Google Sheets file and rename the first sheet tab ‘Board’
- In Row 1, type your workflow stages across columns B through F. Common defaults are Backlog, To Do, In Progress, Review, and Done
- Leave Column A narrow (about 30px wide) as a visual spacer between the sheet edge and your first status column
- Select each heading cell, then go to Format > Merge cells to merge two cells horizontally per heading; this gives each column a wider label area
- Apply bold text, a darker background color, and white font to Row 1 so headings stand out from card rows below
Three columns is the minimum for a useful board. More than six creates horizontal scrolling problems on most screens, which defeats the purpose of a visual overview.
Fill your Google Sheet with meaningful data
Step #2: Format the board layout
Formatting turns a plain spreadsheet into something that reads like a board. Every choice here serves scannability, which means that you want to spot a card’s location in under two seconds.
- Set uniform column widths for columns B through F at around 200-250px each, so cards have consistent sizing across all status columns
- Select the entire sheet and apply a light gray background (like #F0F0F0) to make it the ‘board surface’
- Starting in Row 2, apply white fills to individual cells or small cell blocks in each column. These white areas become your card slots, creating contrast against the gray background
- Adjust row heights to 60-80px so each slot has enough vertical space for a task title and one line of detail
- Freeze Row 1 by clicking View > Freeze > 1 row so your headings stay visible when scrolling through a long board
Add thin light-gray borders around each card slot to reinforce the visual separation. This way, it’ll look like a physical Kanban board with sticky-note-sized spaces arranged under each column heading.
Format the Google Sheet to make it visually appealing
Quick hacks:
| Action | Windows Shortcut | Mac Shortcut |
|---|---|---|
| Bold text for headings | Ctrl + B | Cmd + B |
| Open format menu | Alt + O | Ctrl + Option + O |
| Insert new row | Alt + I, then R | Ctrl + Option + I, then R |
| Copy cell formatting | Ctrl + Alt + C | Cmd + Option + C |
| Paste formatting only | Ctrl + Alt + V | Cmd + Option + V |
| Freeze top row quickly | Alt + W, then F, then R | View → Freeze → 1 row |
| Resize columns faster | Double-click column border | Double-click column border |
| Duplicate sheet tab | Right-click tab → Duplicate | Right-click tab → Duplicat |
Step #3: Build a reusable task card template
Creating a card template on a separate sheet saves you from formatting every new task from scratch:
- Add a new sheet tab and name it ‘Card Template’
- In a small cell block (roughly four rows by one column), format these fields top to bottom:
- Task name (bold, top line)
- Assignee (regular weight)
- Due date (regular weight)
- Priority (dropdown)
- For the Priority field, select the cell and go to Data > Data Validation > Add rule, then choose ‘Dropdown’ and enter High, Medium, and Low as options
- Apply conditional formatting to the Priority cell. For this, you’ll have to select the cell, go to Format > Conditional formatting, and create three rules. It can be something like turning the cell red when text is ‘High,’ yellow for ‘Medium,’ and green for ‘Low’
- To add a new card to your board, select the entire card template block, copy it (Ctrl/Cmd+C), click the target card slot on the Board sheet, and paste
Every new card requires this copy-paste action. There’s no drag-and-drop creation keyboard shortcut to spawn a card in a column.
Customize the Priority dropdown in your Google Sheet
Pro Tip: If you’re building your first board, start here:
| Team size | Suggested In Progress limit |
|---|---|
| Solo | 2–3 tasks |
| 2–4 people | 4–6 tasks |
| 5–8 people | 8–12 tasks |
Rule of thumb: If a column consistently exceeds its limit, your bottleneck is process design, not team speed.
Step #4: Move cards between columns
Moving a card means changing its status. In Google Sheets, you have two approaches, each with trade-offs.
1. Manual cut-and-paste method
- Select the card’s cells in the current column
- Cut them (Ctrl/Cmd+X)
- Click the target cell in the new status column, and paste
- Watch for formatting loss. Pasting can break merged cells or conditional formatting
- Use Edit > Paste special > Values only to preserve data without carrying over broken formatting, then reapply styles manually
2. FILTER formula method
- Create a separate sheet tab called ‘Task Database’ with columns for Task Name, Assignee, Status, Due Date, and Priority
- Add Data Validation dropdowns to the Status column with your workflow stages
- On the Board sheet, place this formula under each column heading:
=FILTER(Tasks!A:A, Tasks!C:C=’In Progress’)
- Replace ‘In Progress’ with the matching status for each column. When you change a task’s status dropdown in the database, it automatically appears under the correct heading on the Board sheet
Add Data Validation to the Status dropdown in your Google Sheet
| Criteria | Manual method | Formula method |
|---|---|---|
| How it works | Cut and paste card cells between columns | Change a dropdown on a database sheet |
| Pros | Cards keep visual formatting | Cards move automatically |
| Cons | Every move is manual; formatting can break | Output is plain text rows, not visual cards |
Summarize this article for me pleaseCommon Google Sheets Kanban Mistakes (And How to Avoid Them)
Most spreadsheet Kanban problems come from setup shortcuts that seem harmless early on. Here are the common ones.
| Problem | What causes it | How to fix it |
|---|---|---|
| Cards lose formatting when moved | Cut-and-paste breaks merged cell styling | Use template blocks or paste values separately |
| The board becomes hard to scan | Too many columns or inconsistent row heights | Keep workflows to 3–6 columns and standardize spacing |
| FILTER formulas stop working | Someone edits the database structure | Lock formula ranges or protect the database sheet |
| Horizontal scrolling kills visibility | Overbuilt workflows with too many stages | Merge low-value stages into broader statuses |
| Cards feel cluttered | Too much detail inside one cell | Keep cards lightweight and move supporting details to a database tab |
Summarize this article for me pleaseFree Kanban Board Templates for Google Sheets
If building from scratch feels like overkill, start with a template. The three below cover the most common use cases: a fully automated personal task tracker, a simple team workflow, and an agile sprint board. Each opens in Google Sheets and is ready to copy.
Indzara Kanban board task tracker
The Kanban template from Indzara is the most automated of the three. You enter tasks on a settings sheet (assignee, priority, due date, up to six stages) and the board builds itself, with color-coded priority cards and warning flags that turn orange as a due date nears and red once it’s passed.
It’s best for individuals or small teams who want a polished, low-maintenance board without wiring up formulas themselves.
Something to note: The automation runs on a fixed structure. You customize through the settings sheet, not by dragging cards, so if you want to move work by hand, this isn’t that kind of board.
Weekdone Kanban board template
Weekdone’s Kanban board template keeps things deliberately simple, with four columns: Plans, Progress, Problems, and Future Ideas. It comes pre-filled with an example scenario you can clear and replace. It’s best for small teams that want a lightweight status snapshot rather than a detailed task system, like a weekly check-in board.
Something to note: There are no assignee, priority, or due-date fields built in, and the four-column setup doesn’t map to a typical To Do / In Progress / Done flow. You’ll adapt it manually if you need stage-based tracking.
Kanban board template by Vertex42
Vertex42’s Kanban template is built for sprint-based work and runs in both Google Sheets and Excel. It uses horizontal lanes (each row is a card you drag between To Do, In Progress, and Done), plus a backlog you can hide between sprints and a sprint progress chart that tracks completion against time. It’s best for small dev teams or solo developers running one or two-week sprints.
Something to note: The row-based layout reads less like a visual board than column-style templates, and the sprint chart relies on manual hour estimates per task. If you skip the estimating step, you lose the progress tracking that’s the template’s main draw.
Summarize this article for me pleasePros and Cons of Google Sheets Kanban Boards
Google Sheets Kanban boards are free, familiar, and require zero onboarding. But the trade-offs compound as your team or project grows. Let’s compare them:
| Pros | Cons |
|---|---|
| Included with any Google account; no add-ons needed for basic boards. | Moving cards requires cut‑paste or formula updates; core kanban interaction is missing. |
| Anyone who’s used a spreadsheet can start immediately with no tool‑specific training. | Adding cards, updating statuses, and fixing formatting require hands-on work. |
| Up to 100 people can edit simultaneously with Google Sheets’ native sharing. | No built‑in rules for auto‑assigning, notifications, or trigger‑based moves (Apps Script requires coding). |
| Control every cell, formula, and formatting rule with no feature gates or plan restrictions. | Boards over ~20–30 cards become hard to scan; horizontal scrolling and long columns degrade usability. |
| Lives alongside Docs, Slides, and Drive without switching ecosystems. | No built‑in tracking for cycle time, throughput, or WIP limits. |
Summarize this article for me pleaseWhen to Use a Dedicated Kanban Tool Instead of Google Sheets
A Google Sheets Kanban board is a workaround, rather than a workflow tool. That distinction matters once you hit specific thresholds, regardless of which tool you pick. Here are some signs that you need an upgrade:
- Your board has more than one team editing it: Spreadsheet conflicts, accidental overwrites, and unclear ownership become daily friction when multiple teams share a single sheet
- Automation rules are required: If you want cards to auto-move when a subtask completes, you’ve outgrown Sheets. The same applies if you need notifications when a card enters ‘Review’; custom scripting is required
- You’re tracking metrics: Cycle time, lead time, throughput, and WIP limit enforcement require either complex formulas you’ll maintain forever or a tool that calculates them natively
- Cards need rich context: When tasks require attachments, comment threads, subtask checklists, or linked dependencies, a single spreadsheet cell can’t hold that information usefully
- Copy-pasting wastes your time: If most of your board time goes to formatting and moving cells, the tool is slowing you down
Some Kanban tool recommendations for you:
- Trello: For teams that want pure kanban simplicity with minimal setup
- Jira: If your team is already deep in Atlassian’s ecosystem, Jira’s Kanban boards connect directly to your existing backlog and sprint infrastructure
- Smartsheet: It offers a middle ground for teams that want spreadsheet familiarity with built-in kanban views
If you are already using ClickUp, you can simply use the ClickUp Board View to see tasks in Kanban style.
This video shares more information about the top kanban board software:
Summarize this article for me pleaseHow We Run Kanban Boards in ClickUp
ClickUp brings boards, tasks, and automation into one workspace for teams that want Kanban to manage work, not just display it.
Here’s how our marketing team runs it.
Every workflow starts with a ClickUp List built around the process it tracks. Our editorial pipeline lives in one List, campaign production in another, and each uses its own set of ClickUp Custom Statuses to reflect how work moves.
The ClickUp Board View mirrors the workflow instead of forcing it to fit a spreadsheet structure. Columns come straight from your task statuses, so moving a card actually changes its status. No cut-paste, no broken formatting, no FILTER formula to babysit. Each card also carries its full context: the brief, subtasks, due dates, attachments, and comments all travel with it, so an editor opening a card for review has everything in one place.
Drag and drop your team’s tasks in a Kanban format with the ClickUp Board View
ClickUp Automations handle repetitive handoffs. When a task moves into Review, it automatically assigns the right editor and posts a handoff comment with next-step instructions. When it reaches Approved, it updates priority and pushes the task into the publishing queue.
Automate repetitive tasks like status changes with ClickUp Automations
We also use work-in-progress limits to keep columns from turning into parking lots. If Review starts stacking up, the board shows it immediately. Some of our teams also use ClickUp Brain or dedicated Super Agents to flag overdue tasks to the relevant owners.
Reporting happens in the same place using ClickUp Dashboards. They pull status distribution and throughput from live board activity, so you see where work is slowing down without rebuilding formulas or refreshing charts.
Honest limitations
The workflow we described above works because the board, the task, and the workflow rules all live in one workspace. Moving a card updates its status, triggers the right automation, and keeps reporting current without anyone touching a second tool.
If your team already tracks work in ClickUp, Board View becomes the natural operating layer. If not, moving from Sheets usually means shifting the workflow itself.
ClickUp also comes with a setup curve that spreadsheets don’t. Teams used to the flexibility of dragging rows around a sheet need a little time to adjust to Lists, statuses, automations, and task structure.
ClickUp fits best when: Your Kanban board manages active work across multiple people, you need task ownership and automation, and your workflow has enough moving parts that manual spreadsheet updates are starting to break down.
Skip it if: The board is lightweight (a few cards across basic stages), the workflow rarely changes, or your team only needs a simple visual tracker. In those cases, a Google Sheets Kanban board will usually be faster to build and easier to maintain.
Summarize this article for me pleaseBuild a Google Sheet Kanban Only For Simple Workflows
A Google Sheets Kanban board works well when the workflow is simple, the task volume is manageable, and the goal is quick visibility without adding another tool.
Use only the columns where work actually waits and set realistic work-in-progress limits. We’d suggest archiving completed work before your Done column turns into clutter. And if maintaining the board starts taking more effort than completing the tasks on it, that’s your signal to rethink the system.
If your workflow includes recurring handoffs, multiple contributors, status-based automation, or reporting needs, a dedicated board becomes worth it. ClickUp is a good option if your team needs drag-and-drop boards, built-in automations, live reporting, and tasks that carry their full context with them.
Sign up to ClickUp for free today!
Summarize this article for me pleaseFrequently Asked Questions About Kanban Boards in Google Sheets
What’s the difference between a Kanban board and a to-do list?
A to-do list tracks what to do; a Kanban board tracks where work is across stages and caps how much runs at once (via WIP limits). The board surfaces bottlenecks a flat list hides.
Can multiple people use a Google Sheets Kanban board at once?
Yes, up to 100 people can edit a Sheet simultaneously. But concurrent edits on a Kanban layout cause overwrites and broken merged cells fast, so it’s reliable only for 2-3 light collaborators.
Does a Google Sheets Kanban board work on mobile?
Poorly. The Sheets mobile app doesn’t support drag-and-drop, and cut-paste across columns is painful on a small screen, so a Sheets board is effectively desktop-only.
What is the difference between a Kanban board and a Trello board?
A Kanban board is a methodology that visualizes work in progress and enforces flow limits. Trello is a specific software product that implements kanban principles with drag-and-drop cards, attachments, and automation.
Can you make a Kanban board in Excel?
Yes, the same build pattern works in Excel: column headings as status stages, formatted cells as card slots, and cut-paste to move cards between columns. Excel adds two capabilities Sheets lacks: VBA macros for limited automation, and PivotTables for basic throughput tracking. Excel still has no drag-and-drop card movement, so the core Kanban interaction is missing in both spreadsheet tools.
How many columns should a Kanban board have?
Three columns is the functional minimum (To Do, In Progress, Done), and six is the practical maximum for most teams. The Kanban Method’s creator, David J. Anderson, recommends mapping columns to actual workflow stages, not arbitrary categories, and adding a column only when work genuinely waits there for a meaningful amount of time. More than six columns creates horizontal scrolling problems on most screens and dilutes the visual signal the board is supposed to provide.
How do I enforce a WIP limit in Google Sheets?
Sheets has no native WIP enforcement. Use a COUNTA formula on each column with conditional formatting that flags the cell red when the count exceeds your limit. It warns you; it won’t block new cards.
Everything you need to stay organized and get work done.
Recent Articles
How to Add Tasks to Google Calendar in 6 Easy Steps 
How to Add Tasks to Google Calendar in 6 Easy Steps
