The short answer
There is nothing wrong with running leads in a spreadsheet. Plenty of healthy businesses do. The moment to switch is not when you reach a certain size. It is when the sheet starts costing you enquiries: follow-ups get missed, two people overwrite each other, and nobody can say for certain what was last said to a customer.
What each one is good at
| Spreadsheet | CRM | |
|---|---|---|
| Cost | Free or nearly free | A monthly fee per user, or a one-off build |
| Set-up time | Minutes | Days to weeks |
| Flexibility | Total. Any column, any layout | Structured. You work within its model |
| Several people editing | Fragile | Designed for it |
| History of each conversation | Whatever someone types in a cell | Emails, calls and notes against the contact |
| Reminders and follow-up | None unless you build them | Built in |
| Reporting | Manual | Automatic, if the data is entered |
| Connecting to your website and other tools | Possible but brittle | Usually straightforward |
Five signs you have outgrown the spreadsheet
1. Follow-ups depend on someone remembering
If the only reminder to call someone back is a person scrolling down a column, some calls will not be made. This is the most expensive symptom and usually the first to appear.
2. More than two people update it
Shared spreadsheets cope badly with several editors. Rows get sorted halfway, filters hide records, and a careless paste overwrites a week of notes.
3. You cannot see the history
When a customer rings, can whoever answers see what was quoted, when, and what was said last time? If the answer lives in someone's inbox, you have a memory problem dressed up as a spreadsheet.
4. You do not know where leads come from
Deciding where to spend marketing money requires knowing which source produced which customers. A sheet can hold that, but only if someone types it in every time.
5. You want something to happen automatically
An acknowledgement email, a task for the right person, a reminder when a quote goes quiet. Once you want the system to act, not just store, you are describing a CRM.
When a spreadsheet is still the right answer
- One or two people handle all enquiries.
- Volume is low enough to hold in your head.
- The sales process is short: enquiry, quote, yes or no.
- You are still working out what your process is. Do not buy software to formalise a process that changes monthly.
Off the shelf or built for you?
Most businesses should start with an established CRM. They are quick to set up and the per-user fee is modest for a small team. A custom build makes sense when your process genuinely does not fit the standard model, when per-user fees have become significant, or when you are paying for several tools that one system could replace. Our guide to what business automation actually costs works through that comparison with numbers.
How to switch without the pain
- Write down your stages first: for example new, contacted, quoted, won, lost. Keep it to five or six.
- Clean the spreadsheet before importing. Remove duplicates and dead records.
- Move live leads and customers only. Archive the rest.
- Connect the website form on day one, so new enquiries arrive without retyping.
- Agree one rule with the team: if it is not in the CRM, it did not happen.
The technical migration is usually the easy part. The habit is the hard part. A CRM that half the team ignores is worse than a spreadsheet everyone uses.
What to do once it is in
With a CRM in place, the useful automations become simple: acknowledging enquiries, assigning owners and chasing quotes. We cover those in how to automate lead follow-up and in connecting your website, CRM and sales process.
Common questions
Which CRM should we choose?
The one your team will actually use. Shortlist two or three, test each with real enquiries for a week and choose on ease of daily use, not the feature list.
How long does a switch take?
For a small team with a clean list, a basic set-up can be working in days. Allow a few weeks for the habits to settle.
Can we keep the spreadsheet for some things?
Yes. Spreadsheets remain good for analysis and one-off lists. The CRM should hold the live record of customers and conversations.
Can Storm set this up?
Yes. Storm's CRM automation service covers choosing or building the system, connecting the website and setting up the follow-up. If you are not sure whether you need it yet, a free 24-hour audit will tell you.
Want this applied to your website?
George or Nicholas will record a personal walkthrough of your site within 24 hours.
Not ready for an audit? See CRM automation.
