A kanban board beats a spreadsheet for tracking web design clients once you're managing more than roughly 10-15 active leads at once, because a board shows stage at a glance while a spreadsheet requires reading rows to reconstruct the same information. Below that volume, either works — the real question is which one you'll actually keep updated.
Here's a genuine comparison, not a "kanban wins, obviously" pitch — spreadsheets have real advantages a board doesn't.
What Each One Is Actually Good At
| | Spreadsheet | Kanban Board | |---|---|---| | Setup time | Fastest — open a blank sheet, add columns | Slightly more setup — define columns/stages first | | Visual read of pipeline | Requires scanning rows | Instant — stage is visually obvious | | Filtering and sorting | Best-in-class if you know formulas | Usually weaker unless the tool supports it | | Bulk analysis (close rate, totals) | Native, flexible with formulas | Depends on the tool — some don't support it well | | Drag-and-drop stage updates | Not native | Core interaction, low friction | | Automatic stale-lead flags | None, unless you build one | Depends on tool — most basic kanban tools still lack this | | Multi-device / mobile use | Often clunky | Generally better mobile experience |
Neither format wins across the board. Spreadsheets are better for anything analytical — pivot tables, custom formulas, exporting data. Kanban boards are better for anything operational — knowing at a glance what needs attention today.
The Real Difference Is Update Friction
The deciding factor in practice isn't features — it's which format you'll actually keep current. A spreadsheet requires you to locate the right row, click into the right cell, and type a new value. A kanban board requires dragging a card one column over. That difference sounds trivial, but it's the entire reason kanban tracking systems have higher real-world compliance than spreadsheet ones for people managing more than a handful of leads.
This matters because a tracking system that isn't updated in real time is actively misleading — it shows you last week's pipeline, not today's. Given that leads sitting in "Interested" for more than 3 days without action need to surface as stale, a system with high update friction is a system where that flag either doesn't exist or quietly goes wrong because nobody moved the card.
Where Spreadsheets Genuinely Win
Don't let the kanban framing above oversell boards — spreadsheets have real strengths:
- Custom calculations. Close rate, weighted pipeline value, average deal size by month — a spreadsheet with formulas does this natively. Most basic kanban tools require exporting data elsewhere to run the same analysis.
- No stage rigidity. If your process genuinely doesn't fit six clean stages, a spreadsheet's free-form columns adapt more easily than a fixed board.
- Zero tool lock-in. Spreadsheets export cleanly to any other format. Some kanban tools make it harder to get your data out.
If you're the kind of freelancer who actually builds and maintains formulas, and your lead volume is low enough that scanning rows isn't a real burden, a well-built spreadsheet can outperform a generic kanban board — see how to track lead sources without a CRM for the exact five-column spreadsheet system that works at that volume.
Where Kanban Wins Decisively
Once your active pipeline crosses into double digits, or once "Interested" starts splitting into meaningfully different sub-states you need to act on differently, a spreadsheet's flat-row format stops matching how you actually think about the pipeline. A board where "Interested" is a column containing cards labeled by sub-state (asked price, requested a call, said "I'll think about it") gives you a genuinely faster read than scrolling a spreadsheet filtering by a status column.
Kanban also wins clearly on the follow-up problem specifically. A card sitting in "Contacted" for several days visually stands out on a board far more than a row buried among forty others in a spreadsheet — though neither format solves staleness automatically unless the tool has a built-in flag for it. See the pipeline stages every web designer should track for the full stage breakdown a board should mirror.
The Hybrid Most Freelancers Actually Need
In practice, the strongest setup isn't "pick one" — it's a kanban-style board for day-to-day operation (what needs my attention today) paired with periodic exports or reporting for the analytical side (close rate, forecasting, monthly totals). Some purpose-built pipeline tools do both natively — a board view for daily use, with running totals for pipeline value and won value calculated automatically rather than requiring a separate spreadsheet pass. That removes the false choice between "easy to update" and "easy to analyze."
For a broader look at free options across both categories, see free CRM alternatives for freelance web designers.
What Actually Determines the Right Choice
Use this quick test: if you can honestly say you'll update a spreadsheet row the moment a lead's status changes — not at the end of the day, not during a weekly batch review — a spreadsheet will serve you fine. If you know from experience that spreadsheets you've started in the past quietly stopped being updated within a few weeks, a kanban board's lower-friction interaction is worth the switch, even with fewer analytical features out of the box.
Whichever format you choose, the underlying discipline matters more than the tool — logging every lead, updating stage in real time, and reviewing regularly. That discipline is also what feeds accurate revenue forecasting; see how to forecast monthly revenue from your pipeline for how tracked pipeline data (from either format) turns into a real number.
Getting this system right is foundational to everything downstream in your lead generation efforts — see the complete guide to lead generation for small business for how tracking fits into the bigger picture.
A Board That Updates Itself as Leads Move
The best version of a kanban board is one where leads land on it already staged and don't require you to build the columns yourself. Runvax pairs a six-stage pipeline board (Found, Contacted, Interested, Proposal, Won, Lost) with automatic follow-up flags and running pipeline value totals — the analytical side of a spreadsheet and the low-friction side of a kanban board in one place. Free to start, no credit card required.