You need a CRM the moment you can no longer answer "who am I supposed to follow up with today" without checking your inbox, your calendar, and a spreadsheet tab at the same time. Before that point, a CRM is overhead. After it, a spreadsheet is actively costing you deals.
Most founders get this backwards. They buy a CRM at 5 deals because an advisor told them to look professional, then abandon it by week three because updating two systems is worse than updating one. Or they stay on a spreadsheet at 40 open deals because switching feels like a distraction from selling. Both mistakes come from tracking deal count instead of the thing that actually breaks: follow-up reliability.
The real signal isn't deal count, it's the tabs you have to check
A spreadsheet fails silently. Nothing crashes. You just stop seeing the prospect who went quiet 11 days ago, because their row sits below the fold and nothing about the sheet tells you they've gone cold.
Capterra's research on small-business CRM adoption puts a number on the fallout: teams that move off manual tracking recover 5 to 10 hours a week that were going into re-finding context, not selling. That time wasn't spent on the deal. It was spent reconstructing what already happened, because the conversation history lived in four different places: notes in one tab, the proposal in an email thread, the last call in your calendar, and the follow-up you meant to send in your head.
That fragmentation, not the row count, is the actual failure mode. A founder with 60 simple, similar deals (self-serve trials converting on a single call) can run that on a spreadsheet longer than a founder with 12 complex enterprise deals, each with five stakeholders and a different objection.
What a spreadsheet does better than people admit
Before switching, it's worth being honest about what you'd give up. A spreadsheet has zero setup cost, no seat fees, and no workflow to learn. You can restructure it in thirty seconds when your sales process changes, which it will, repeatedly, in the first year. A CRM's schema fights you back once you've committed to it.
If you're closing your first 10 to 20 customers yourself, a spreadsheet with five columns (company, stage, next action, next action date, last touch) usually beats a half-configured CRM nobody on your two-person team fully understands. The mistake isn't using a spreadsheet early. It's not knowing when that stops being true.
The three-signal test
Run this instead of guessing at a deal-count threshold:
1. You've missed a follow-up in the last two weeks that cost you a live conversation.
Not a hypothetical risk, an actual dropped thread you can name.
2. You're spending more than 20 minutes a day reconstructing context.
Rereading email chains, checking Slack, scrolling your calendar, instead of writing new outreach or working a deal forward.
3. A second person now touches sales, even part-time.
A cofounder taking calls or a contractor doing outbound, and you can't hand them a prospect without a 15-minute verbal briefing first.
One signal alone is a warning. Two or more, and the spreadsheet is already costing you more than a CRM subscription would.
What breaks first when you wait too long
The first casualty is never the newest lead. It's the warm deal from three weeks ago that went quiet and never got a nudge, because nothing surfaced it. Founders running sales solo consistently underestimate how many deals die from silence rather than rejection. A prospect who says no is a closed loss you can learn from. A prospect who never hears from you again is a loss you never even log, so it doesn't show up in your numbers and you don't notice the pattern.
The second casualty is onboarding a second seller. Every week you delay past that point, you're building tribal knowledge that only exists in your head, and every new hire's ramp time gets longer because there's no system to hand them.
Picking a CRM without regretting it
When the three-signal test says switch, resist the instinct to pick the CRM with the most features. Pick the one that costs the least time to keep updated, because an unused CRM is worse than a spreadsheet: it gives you false confidence that tracking is happening when it isn't.
For a solo or two-person sales motion, a lightweight pipeline tool that mirrors your spreadsheet's simplicity (stage, next action, last touch, all visible on one board) will get used. A heavier platform built for a 10-person sales org, with custom fields and approval workflows, usually gets abandoned within a month because the setup tax is higher than the value it returns at your current deal volume. Match the tool to the team size you have today, not the one you're planning to have in a year. You can migrate later. A spreadsheet export makes that painless.
The 30-day move
Don't run a full migration project. Pick one lightweight CRM, import your current spreadsheet as-is (most tools accept a CSV with your existing columns), and run both systems in parallel for one week only. If you're still opening the spreadsheet out of habit after day seven, the tool you picked is asking for more setup than your process needs. Simplify it or pick a different one. The goal isn't a perfect system. It's one you'll actually open every morning.
Frequently asked questions
How many deals do I need before switching from a spreadsheet to a CRM?
There's no fixed number. Watch for a missed follow-up that cost you a live conversation, more than 20 minutes a day spent reconstructing context, or a second person joining sales. Any one of these matters more than raw deal count.
Is a free CRM good enough for an early-stage startup?
Yes, for the first sales motion. Free tiers from lightweight pipeline tools cover a solo founder or two-person team easily. Upgrade when you need automation, reporting, or more than a handful of seats, not before.
Will switching to a CRM slow down my selling in the short term?
For about a week, yes, while you import data and adjust habits. Run the old spreadsheet and new CRM in parallel for that first week so nothing falls through during the transition.
Should I pick a CRM built for enterprise sales teams if I plan to scale?
No. Buy for the team you have now. Heavier platforms built for 10-person sales orgs carry setup and maintenance overhead that isn't worth it at low deal volume, and migrating later from a simple tool is straightforward.
What's the biggest risk of staying on a spreadsheet too long?
Silent follow-up failures. Deals don't show up as losses, they just go quiet and disappear from view, which means you don't even see the pattern forming until months of pipeline have leaked out unnoticed.
Track the three signals, not the row count. The spreadsheet isn't the problem until it starts hiding deals from you, and by then you'll already know.