Insights — Sales Problems & Founder-Led Growth — 5 min read
When Does an SME Need CRM and When Is a Spreadsheet Enough?
A spreadsheet is enough for longer than most software vendors would have you believe. CRM earns its cost once one person can no longer hold the whole pipeline in their head.
In short
A spreadsheet is genuinely enough while one person can accurately hold the whole pipeline in their head and update it without help. CRM becomes worth the cost once there is more than one salesperson working live opportunities, deals routinely involve several contacts or a long cycle, or the business needs to know what happens to a lead when the person who owns it is away. Below that point, CRM usually adds administration without adding control.
This question gets asked in two very different situations. One is a business with a working spreadsheet, wondering whether it is missing out on something better. The other is a business whose spreadsheet has quietly stopped being trustworthy, and is looking for software to fix what is really a discipline problem.
The answer depends on which situation you are actually in, and it is worth being honest about that before spending money either way.
What a spreadsheet does well
A spreadsheet has no learning curve, costs nothing beyond time, and can be reshaped in five minutes to answer a new question. For a business with one or two people selling, a handful of active opportunities each, and a sales cycle short enough that nothing sits open for months, a well-maintained spreadsheet does everything a dashboard needs to do.
The word doing the work in that sentence is 'well-maintained'. A spreadsheet only works if someone updates it consistently, and its biggest weakness is that nothing forces that discipline. It will let a stale opportunity sit untouched for six months without complaint.
The signs a spreadsheet has stopped being enough
- More than one person is actively selling and needs to see the same live pipeline, not a version emailed round on Friday.
- Deals routinely involve several people at the buying company, and remembering who said what to whom depends on one person's memory.
- The sales cycle is long enough that an opportunity can be forgotten between updates.
- You have been caught out by a lead going cold because the person who owned it was on holiday and nobody else knew it existed.
- You want to know conversion rates by source, stage or salesperson, and building that view by hand is starting to take real time each month.
Any one of these on its own might not justify the change. Two or three together usually mean the spreadsheet is now costing more in lost deals and admin time than a CRM would cost in subscription fees.
What CRM actually buys you
The real benefit of CRM is not the reporting, though that helps — it is that a lead and its history belong to the business rather than to one person's inbox and memory. If someone leaves, is off sick, or simply forgets a follow-up, the information is still there for someone else to pick up. That single fact is usually worth more than any dashboard feature.
A secondary benefit is consistency: a shared pipeline forces a shared definition of what counts as a qualified opportunity, what stage means what, and when something should be marked lost rather than left to rot. That structure is hard to enforce in a spreadsheet where every user can quietly do things their own way.
What CRM does not fix
CRM will not create the discipline it needs to be useful. A business that cannot keep a spreadsheet updated honestly will not keep a CRM updated honestly either — it will simply have a more expensive, more complicated version of the same problem, with the added frustration of a system everyone resents. If your spreadsheet is failing because of a habit problem rather than a scale problem, buying software addresses the wrong cause.
The cost that is easy to underestimate
CRM cost is not just the monthly subscription. It is the time spent configuring it to match how your business actually sells, migrating existing data cleanly, training people who are used to a spreadsheet, and maintaining data quality once the novelty wears off. For a very small team, that setup and adoption cost can outweigh the benefit for a year or more — which is a legitimate reason to wait, not a failure to modernise.
Conversely, delaying too long has its own cost: the longer a business waits past the point of genuine need, the more historical pipeline knowledge exists only in people's heads, and the harder migration becomes when it eventually happens.
Choosing between a lightweight and a full CRM
Not every business that has outgrown a spreadsheet needs an enterprise-grade system. Many SMEs are better served by a simple, low-configuration CRM that captures the pipeline, contacts and follow-up dates without the overhead of a system built for a much larger sales organisation. Buying more capability than the team will use is one of the more common ways a CRM project stalls after a promising first month.
| Situation | Likely fit |
|---|---|
| One or two sellers, short cycle, simple pipeline | Spreadsheet |
| Multiple sellers sharing accounts or leads | Lightweight CRM |
| Long, multi-contact enterprise sales cycle | Full CRM |
| Spreadsheet inaccurate due to lack of discipline | Fix the process first, then decide |
Making the decision
If you recognise two or more of the signs above, it is worth costing out a simple CRM properly rather than continuing to patch the spreadsheet. If none of them apply yet, spending money on software will not create the discipline your business is currently missing, and the better use of the budget is fixing how consistently the spreadsheet gets updated.
If you are not yet sure which of these problems you actually have, the Sales Help for Founders & Business Owners hub is a reasonable starting point before committing to either route.
Where AI changes the calculation
Some of the manual burden that used to justify delaying a CRM move — data entry, note-taking, chasing follow-ups — can now be reduced with sensible automation layered onto either a spreadsheet or a CRM. That does not remove the underlying decision, but it does mean the admin cost of moving to CRM is lower than it was even a couple of years ago, which is worth factoring in if cost of adoption is the thing holding you back.
Could your commercial operation run with less admin and better information?
Evans Sales Consultancy applies AI, automation and practical digital systems to prospecting, sales operations, reporting, customer journeys and management visibility — starting from the commercial problem, not the technology.
Related services
Written by
By Tom Evans
International Sales & Market Development Director, Evans Sales Consultancy
Published 21 September 2026 — 5 min read