Spreadsheet or CRM? When the switch starts to pay
A spreadsheet is a perfectly legitimate customer database. It costs nothing, anyone can use it, and it is set up in five minutes. The switch only pays off once a particular point is passed — and that point has less to do with the number of contacts than most people think.
In short
- The number of contacts does not decide it. What decides is whether several people work with them at once and whether follow-ups need scheduling.
- Five signs are reliable: duplicate entries, missed follow-ups, "which version is current", nobody knows the status, and no report without manual work.
- The calculation rarely works out on licence cost. It works out on lost working time and enquiries nobody followed up.
- The move realistically takes two to five days — most of it tidying, not technology.
The question is usually put the wrong way round. It is not "how many contacts before you need a CRM", but: which task is the spreadsheet no longer doing reliably?
There are one-person businesses with 900 contacts for which a spreadsheet is entirely sufficient, because one person has the whole picture and the sale closes in a single conversation. And there are three-person firms with 80 contacts where the spreadsheet does damage daily, because three people edit the same rows.
Five signs the spreadsheet no longer holds
If one applies, the switch is worth considering. If three apply, staying costs more than moving.
1. The same contact appears twice
Two rows for the same company, spelled differently, with different states. Once that happens the spreadsheet is no longer a reliable answer — you have to check it before you believe it.
2. Follow-ups get forgotten
A spreadsheet does not remind you. Keeping follow-ups in your head or your calendar means losing enquiries regularly — and not noticing, because the absence of a reply shows up nowhere.
3. "Which version is the current one?"
Once that question gets asked, the answer is usually: none. Even with cloud spreadsheets, copies appear for reports, quotes and meetings.
4. Nobody but one person knows the status
If nobody can say where a case stands while one person is away, the knowledge is not in the system. That is not a tooling problem, but a tool can solve it.
5. Reports cost half a day
"How many enquiries came in last quarter from which channel, and what became of them?" — if that means manual work, the question soon stops being asked. And with it, the steering.
Worth knowing
The most expensive thing about an overloaded spreadsheet is rarely the mistakes you notice. It is the enquiries nobody followed up — those appear in no statistic, because they never became a case.
That is exactly why the decision usually gets made too late: the damage is real but invisible.
The calculation that carries the decision
Comparing on licence cost alone always favours the spreadsheet — it costs nothing. Two other items are what decide.
Lost working time. Searching, double upkeep, reconciling versions, manual reports. In firms with two to five people in customer contact, experience puts this at two to five hours a week.
Enquiries not followed up. The harder item to quantify, but usually the larger one. With twenty enquiries a month, forgetting to follow up on two, an average order value of 3,000 and a 25 per cent close rate, that is roughly 1,500 a month — in revenue that was already standing at the door.
| Situation | Time lost / week | Licence cost / month | Recommendation |
|---|---|---|---|
| 1 person, closes in first conversation | under 1 h | 0 | keep the spreadsheet |
| 1 person, multi-stage sale | 1–2 h | 0–25 | borderline, look at a simple system |
| 2–3 people, shared contacts | 2–5 h | 25–90 | the switch pays off |
| 4+ people, or marketing involved | 5–10 h | 90–300 | the switch is overdue |
The figures are experience-based estimates for small firms, not a survey. They are there to show the order of magnitude, not to imply a precision that does not exist here.
A pattern that repeats reliably: the switch gets started because someone wants a better tool — and fails six weeks later because nobody tidied the data. The old spreadsheet keeps running alongside, and after three months the system is empty and the spreadsheet is the truth again.
The difference between successful and failed moves is almost never the software. It is whether a date was set after which the spreadsheet is no longer used. Without that date there is no move, only a coexistence.
Where the spreadsheet stays the better tool
Some tasks are better served by a spreadsheet — even in companies that have long had a CRM.
- One-off analyses with unusual logic. You do not build something you need once into the system.
- Calculating. Costings, scenarios, quote variants — a spreadsheet is built for that; a CRM is not.
- Lists without history. A trade-fair attendee list, a supplier overview: flat data without history belongs in a flat file.
The move in five steps
- Tidy up, before importing. Merge duplicates, delete dead contacts, standardise spellings. Import dirty data and you have an expensive dirty system afterwards. This is the most laborious step: one to three days.
- Decide the required fields — as few as possible. Five to eight fields that always have to be filled. Every additional required field lowers the chance that anything gets maintained at all.
- Name the stages of the sale. Four to six, each with a clear condition for moving on. Not "interested", but "meeting scheduled".
- Set a shutdown date for the spreadsheet. From that day it is only read, not maintained. Without that date there is no move.
- Sharpen after four weeks. Which fields stay empty? Those go. Which are missing? Those get added. A system never touched again after setup is out of date within a year.
I am checking whether we should move from a spreadsheet to a CRM. Our situation: - People in customer-facing roles: [number] - Active contacts in the list: [number] - Typical sale: [one conversation / weeks / months] - Enquiries per month: [number] - Average order value: [amount] - What regularly goes wrong today: [bullet points] Tasks: 1. Judge from these details whether a switch pays off. Argue from lost working time and unfollowed enquiries, not from feature lists. 2. If yes: name the 5 to 8 fields that should be required fields for us, and justify each one. 3. Propose 4 to 6 stages for our sales process. For each stage, phrase the condition under which a case moves there. 4. If no: say so clearly and name the two improvements that would make our current list most workable. Do not recommend a specific product or vendor.
In closing
A spreadsheet is not a beginner's tool you eventually outgrow. It is the right tool for one situation — and no longer right for another.
The transition is reached when several people work on the same contacts, when follow-ups need scheduling, and when reports become manual work. Switch before that and you buy upkeep without return. Switch long after it and you pay quietly, in enquiries nobody ever answered.
Common questions
When is a company too big for a spreadsheet as its customer database?
The contact count does not decide it; the way of working does. Once more than one person edits the same contacts, follow-ups need scheduling, or reports mean manual work, the spreadsheet no longer holds. A one-person business closing in the first conversation can stay with it even at several hundred contacts.
What does a CRM cost for a small company?
For two to three people, simple systems run at roughly 25 to 90 a month, more extensive ones from 90 upwards. The larger cost block is usually the introduction: one to three days of tidying existing data, plus getting used to it.
How long does moving from a spreadsheet to a CRM take?
Two to five working days is realistic. By far the largest part goes on cleaning up the existing list — merging duplicates, deleting dead contacts, standardising spellings. The technical import itself usually takes under an hour.
Can you use a spreadsheet and a CRM in parallel?
For clearly separated tasks, yes — costings, one-off analyses, flat lists without history. Not for the same contact data: two separately maintained contact sets drift apart within weeks, and after that neither is reliable.
What do you need to consider on data protection when moving?
The CRM provider becomes a processor. A data processing agreement has to be in place before the first import, the provider belongs in the privacy notice, and servers outside your own jurisdiction require a separate basis for the transfer. The move is also a good moment not to bring along contacts that have no lawful basis in the first place.
Marketing that sets itself up
The Studio Engine beta is live. Claim your spot and help shape it from the start.
Join the beta →