You need a CRM when follow-ups are being missed, more than one person talks to the same customers, or you cannot say how much potential business is in progress. A CRM (customer relationship management system) stores contacts, conversations and deals in one place and prompts the next action. For one person with 40 active contacts, a well-kept spreadsheet is still fine.
Signs a spreadsheet has stopped working
- You forget to follow up quotes, or find out a colleague already did.
- You cannot tell which leads came from which source.
- Contact details live in your inbox, your phone and three different files.
- You are tracking a pipeline with stages, values and expected close dates by hand.
- You need to hand a customer record to someone else without a long explanation.
If none of those apply, improve the spreadsheet first. Adding a status column, a next-action date and a weekly review costs nothing and shows you what you actually need from software.
What to map before you look at tools
Write down your sales process in plain steps: enquiry, call, quote, follow-up, won or lost. Most small-business CRMs let you rename pipeline stages, so choose a tool that matches your steps instead of reshaping your business around the vendor's template. Note the fields you genuinely use (source, service interested in, quote value, next contact date) and the reports you would read monthly. Anything beyond that list is setup effort without payoff.
Selection criteria
| Criterion | What to check |
|---|---|
| Pipeline fit | Custom stages, deal values, lost reasons, simple dashboards |
| Email and calendar sync | Two-way sync with your mailbox and calendar, and whether logged emails are visible to the whole team |
| Integrations | Forms on your website, your email marketing platform, invoicing or accounting, phone system |
| Data export | Full export of contacts, notes, deals and activity history in CSV or similar |
| Permissions | Control over who sees which records, which matters once you have staff or contractors |
| Data location and compliance | Where data is hosted, whether a data processing agreement is offered, how deletion requests are handled |
| Mobile use | Whether the phone app lets you log a call and set a reminder in under a minute |
Per-user pricing is the usual model, so a team of five costs five times a solo plan. Check which features sit behind higher tiers (automation, reporting, custom fields are common candidates) and if you must commit annually. Read the live pricing page rather than relying on any comparison, because limits change.
Switching costs and data
A CRM becomes sticky because it holds your history. Before you commit, confirm you can export notes and activity as well as names and emails, since some exports leave out the conversation record that makes the data valuable. Run a test export during the trial and open the file. If it is incomplete, assume leaving will be painful.
Under UK GDPR you remain responsible for the personal data you hold. Keep only what you need, record where contacts came from, and be able to find and delete a person's record if they ask. The ICO publishes practical guidance for small organisations on its website at ico.org.uk. If you use the CRM to build a marketing list, the rules on consent in UK GDPR and PECR for email marketing apply to those emails.
Do not import every old contact on day one. Start with live customers and open deals. Importing years of stale records hides the pipeline in clutter and carries old data you may have no good reason to keep.
Running a trial that tells you something
Load 30 to 50 real contacts and three live deals, then use the tool for every customer conversation for two weeks. Measure whether follow-ups happen faster and if you ever go back to the spreadsheet. Bring your team in only after you have settled the pipeline stages. The step-by-step method is in how to run a software trial properly.
Rolling it out to a team
Agree three rules before anyone logs in: every new enquiry goes in within a day, every deal has a next action and date, and lost deals record a reason. Without those rules, the CRM becomes another inbox. Name one person as the owner of settings and data quality, even in a team of three. Hold a ten-minute weekly pipeline review in the CRM itself, so the tool becomes the source of truth. After a month, remove fields nobody fills in. A simple system that is used beats a detailed one that is not.
Questions to ask a vendor
- What happens to my price when I add a second and third user?
- Which features are limited on the plan I am considering, and what are the exact limits?
- How do I export all data, including notes and files, and how long does it take?
- Where is data stored, and do you provide a data processing agreement?
- What is the notice period, and is billing monthly or annual?
Write the answers down. Vendors change terms, and a dated record helps if you later need to challenge a charge or a change in features.
Frequently asked questions
When should I move from a spreadsheet to a CRM?
When follow-ups are missed, several people handle the same contacts or you cannot see your pipeline at a glance.
Which CRM features matter most for a small team?
Customisable pipeline stages, email and calendar sync, the integrations you rely on and a complete data export.
How long should a CRM trial last?
About two weeks, using real contacts and live deals, so you see if the habit sticks.
Does UK GDPR apply to my CRM?
Yes, if it holds personal data. Keep only what you need, record the source of contacts and be able to delete a record on request.