Most UK small businesses start with a spreadsheet, and for good reason. It is free, everyone knows how to use it, and at the start one tab with names, numbers and a notes column does the job. Plenty of firms fall into this group. The Department for Business and Trade's Business population estimates 2025 counts 5.64 million small businesses (0 to 49 employees) at the start of 2025, and around 4.27 million of them have no employees beyond the owners. For a business that size, a spreadsheet is a reasonable first system.
This guide covers when the spreadsheet stops being the right tool, and how to move from spreadsheet to CRM without losing customers, history or a month of your time.
What is the actual difference between a spreadsheet and a CRM?
In practice, the gap shows up in three places. First, history. A spreadsheet row holds whatever someone typed into the notes cell, usually "called, left VM" with no date. A CRM logs each interaction against the contact automatically, often pulling in emails straight from your inbox. Second, tasks. A CRM can set a follow-up for Thursday and remind the right person. A spreadsheet relies on someone sorting by a date column. Third, shared access. Two people editing a CRM see the same record. Two people working on a spreadsheet often end up with "Customers FINAL v3.xlsx" and "Customers FINAL v3 (Sarah).xlsx".
When should a small business switch from a spreadsheet to a CRM?
A useful test is to look back at the last month and ask a few direct questions:
- Did any enquiry go unanswered for more than two working days because nobody saw it?
- Does more than one person add or change customer details?
- Could you say, right now, which marketing channel brought in last month's customers?
- If a customer asked for everything you hold on them, could you find it all in one place?
If the first two get a "yes", or the last two get a "no" or "not sure", the spreadsheet has probably become a bottleneck. A trades firm juggling quotes across three vans, or a clinic using one sheet for bookings and another for reminders, tends to reach this point sooner than a sole consultant with twenty steady clients.
What are the risks of staying on a spreadsheet too long?
Lost follow-ups are the obvious cost, but the data protection side catches people out. The ICO's guidance on responding to subject access requests says you must respond without undue delay and at the latest within one month of receipt, with an extension of a further two months only for complex or multiple requests. If one customer's details sit in an emailed spreadsheet, a shared drive copy, a booking tool and someone's phone, pulling them together accurately within that month is hard. Our AI data protection checklist for UK businesses covers the wider housekeeping that sits alongside this.
Which CRM should a small UK business choose?
Work out your must-haves before looking at any demo. For most small firms that means a contact and company record, a simple pipeline of deal stages, task reminders, email logging and basic reporting on lead source. Industry tools (practice management for clinics, job management for trades) can be a better fit than a general CRM if they already handle bookings or quotes.
Free tiers are a fair starting point. HubSpot's CRM pricing page states you can add up to 2 users and 1,000 contacts to a free account, with no time limit. That suits a small team with a modest list, but check how fast you will reach the cap and which features sit behind paid tiers before building your process around it. Limits change, so confirm them on the pricing page on the day you sign up. If you are weighing an off-the-shelf tool against something custom, the trade-offs in AI build vs buy for small businesses apply here too.
How do I prepare my spreadsheet data before migrating?
Work on a copy of the file, never the original. Then go through it in this order:
- One row per person. Sort by email address, then by phone number, and merge duplicates. Keep the most recent details and combine the notes.
- Split combined columns. "John Smith, Smith Plumbing Ltd" should become first name, last name and company. Most CRMs map each column to one field.
- Standardise formats. Pick one date format (DD/MM/YYYY for UK data), one phone format and consistent postcodes. Make sure the CRM's import settings use UK dates, or 03/04 becomes 4 March.
- Turn free-text notes into fields. If the notes column often says "came from Google" or "referral", make a lead source column with a fixed list of values.
- Decide what to leave behind. Drop people who never replied years ago and anyone with no current reason to be on file. Keep a separate suppression list of people who asked not to be contacted.
How do I actually move from spreadsheet to CRM, step by step?
A sequence that works for most small businesses:
- Configure before importing. Create custom fields to match your cleaned columns, and set up pipeline stages that reflect how you really sell, such as "Enquiry", "Quote sent", "Booked", "Won", "Lost".
- Test with 20 to 50 rows. Import a sample, then open ten records and check that names, dates, phone numbers and notes landed in the right fields.
- Import the full list. Use the CRM's duplicate detection on email address.
- Connect your inbox and web forms. This is what makes a CRM worth having. New enquiries should create records automatically.
- Freeze the spreadsheet. Rename it with "ARCHIVE, do not edit" and make it read-only. Keep it for reference, but no new data goes in.
- Run a two-week check. Each Friday, compare new enquiries in the CRM against your inbox and phone log to catch anything that slipped through.
How do I get my team to actually use the new CRM?
Resistance usually comes from too many fields and too little payoff. Ask staff to fill in only what drives a decision: contact details, lead source, stage and next action. Show them what they get back, such as a morning list of calls due instead of scrolling a sheet. Small automations help adoption, and booking-based businesses often start with reminders like those in our guide to AI appointment reminders.
What mistakes should I avoid when switching?
Running both systems "just for now" is the most damaging, because nobody knows which one is correct. Set a cut-over date and stick to it. Over-building is a close second: twenty custom fields and nine pipeline stages look thorough but slow everyone down. Start lean and add fields only when someone needs them for a real decision. Finally, test the export before you commit. If you cannot get a clean CSV of your contacts and history out of a CRM, you are locked in.
Is it worth moving to a CRM if I only have a few customers?
If you are not ready, tidy the spreadsheet now. Add a lead source column, a next action date and a single owner for each contact. That makes a later migration far easier, and the habits you build, recording where leads come from and what happens next, are the same ones a CRM depends on.
Spreadsheet to CRM — FAQ
How do I know my business has outgrown its customer spreadsheet?
You have outgrown it when the spreadsheet stops telling you what to do next. Common signs: two people keep different copies, follow-ups get missed because nobody spotted the date, you cannot see where an enquiry came from, and finding everything you hold on one person takes more than a few minutes. One bad week is not a reason to switch. A pattern of missed callbacks or duplicated work over a month or two is. If chasing leads depends on one person remembering to check a tab, the system already sits in their head and not in the file, and that is the real risk.
Is a free CRM good enough for a small UK business?
Often, yes, for a start. HubSpot's own pricing page says its free plan covers up to 2 users and 1,000 contacts, with no time limit. That suits a sole trader or a two-person team with a modest customer list. Before you commit, check three things: whether the contact cap will be hit within a year, whether the automation you need (reminders, follow-up emails) sits behind a paid tier, and how easily you can export your data again. A free plan you outgrow in six months still beats a spreadsheet, provided you can leave cleanly.
How long does it take to move from a spreadsheet to a CRM?
For most small businesses with one main customer list, the hands-on work is a few days spread over two to three weeks. Cleaning and de-duplicating the data takes the longest. The import itself is usually quick. Then allow a fortnight running the CRM as the only place where new enquiries go, with the old spreadsheet locked as read-only. Businesses with several lists, years of email history, or custom quoting fields should allow longer and test the import on a small sample first.
Does moving to a CRM help with UK GDPR?
It can, if you set it up properly. The ICO says you must respond to a subject access request without undue delay and at the latest within one month of receipt. Pulling everything you hold on one person from scattered spreadsheet copies, inboxes and notebooks is slow and easy to get wrong. A single CRM record makes that search much faster. A CRM does not make you compliant by itself, though. You still need a lawful basis for each contact, sensible retention rules and controls over who can see what.
Should I import every old contact into the new CRM?
No. Import the contacts you have a reason to keep: current customers, open enquiries and past customers you could genuinely serve again. Leave out people who never replied years ago, duplicates and anyone who asked you to stop contacting them, though you should keep a suppression list so they are not emailed again. A smaller, accurate database is more useful than a large one full of dead records, and on contact-capped plans such as HubSpot's free tier of 1,000 contacts, it also keeps you inside the limit for longer.
