August is the quietest month of the year for most UK service businesses. Clients are away, enquiries dip, and the diary has gaps in it for the first time since spring. That gap is the single best window you get to move your client list off a spreadsheet, and it takes an afternoon, not a project.
This is the plan we walk new Kabooly customers through. Five steps, roughly three hours, and one rule at the end that decides whether the move actually sticks or whether you drift back to the spreadsheet by October.
Why the spreadsheet has to go, briefly
You already know the symptoms: the enquiry you forgot to chase, the "Clients 2026 FINAL v3" file, the client who asks what you quoted in March and you cannot answer. We have written elsewhere about why growing businesses outgrow spreadsheets, so this post skips the argument and gets on with the move.
One point is worth making though. The reason a migration feels intimidating is not the data. Most solo and small service businesses have somewhere between 80 and 600 rows. Importing 600 rows takes ninety seconds. The reason it feels intimidating is that nobody wants to open the spreadsheet and confront how messy it is. That is step one, and it is the only step that requires any real thought.
The afternoon, block by block
Block 1: clean the list (60 minutes)
Open the spreadsheet and do three passes, in this order.
- Delete the dead. Anyone who enquired more than two years ago and never became a client is not a lead, they are clutter. Bin the row. If you have a "not interested" or "wrong fit" column, bin those too. This usually removes 20 to 40 percent of a list and it is the most satisfying hour of the whole exercise.
- Deduplicate on email, not name. Sort by email address and scan for repeats. People change surnames, get entered twice with a middle initial, or appear once as "Sam" and once as "Samantha". Email is the only reliable key. If a client genuinely has no email, decide now whether you are keeping them as a contact at all.
- Fix phone numbers. Mixed formats are the number one cause of a messy import:
07700900123,+44 7700 900123,07700 900 123. Pick one format, find and replace the rest. If you ever want to text a client from your CRM, this matters.
Do not try to fill in missing data during this pass. If a row has no phone number, leave it empty. Empty is honest; guessed is worse than empty.
Block 2: cut the columns (20 minutes)
Spreadsheets accumulate columns the way garages accumulate paint tins. Most of them are not worth carrying into a CRM. Here is what earns its place and what does not.
| Spreadsheet column | Take it? | Why |
|---|---|---|
| Name, email, phone | Yes | The core record. Nothing works without these. |
| Where they came from | Yes | Becomes your source field. This is how you find out which marketing actually pays. |
| Status (enquiry, quoted, booked, past) | Yes | Maps straight onto pipeline stages. Tidy this before you import, not after. |
| Last contacted date | Yes | Lets the CRM tell you who has gone quiet on day one rather than in six months. |
| Free text notes | Trim | Keep the last two or three useful lines per client. Nobody reads a 400 word cell. |
| Colour coded highlighting | No | Colour is not data and will not export. Convert it to a real status column first or lose it. |
| Invoice totals and payment dates | No | That lives in your accounting software. Duplicating it creates two versions of the truth. |
| Anything clinical or sensitive | No | Session notes, health details and safeguarding records belong in your clinical system, never a sales pipeline. |
That last row deserves emphasis. Trimming what you carry across is not just tidiness, it is data minimisation, one of the core UK GDPR principles. The ICO's advice for small organisations ↗ is the plain English version if you want to check your thinking. We also cover the practicalities in our guide to GDPR compliance and your CRM.
Block 3: export to CSV (10 minutes)
File, Download, Comma Separated Values. Two things to check before you close the file.
First, your header row must be a single row of plain text with no merged cells. Merged headers are the most common reason an import fails with a cryptic error. Second, open the CSV in a text editor and look at the first three lines. If a client name contains a comma and it is not wrapped in quotes, your export is broken and you will get columns shifted by one on every affected row.
Keep the original spreadsheet. Do not delete anything yet.
Block 4: import and map the fields (30 minutes)
In Kabooly this is the import screen: upload the CSV, then match each of your columns to a field. The bit worth slowing down for is the status column. If your spreadsheet says "waiting on them", decide which pipeline stage that really means before you map it. Half the value of a CRM is that "waiting on them" becomes a stage with a follow up attached rather than a phrase you wrote in March.
Import in two batches if you are nervous. Take ten rows first, look at how they land, then run the rest. Fixing a mapping mistake on ten records takes a minute. Fixing it on 600 takes an evening.
Block 5: spot check and cut over (40 minutes)
Pick five clients you know well: your oldest, your newest, one with an unusual name, one with a mobile and a landline, one who is mid enquiry. Open each record in the CRM and check it against the spreadsheet by eye. Five records tells you almost everything a full audit would.
Then do the part that actually matters. Connect your website enquiry form to the CRM so new enquiries arrive there automatically, set one automatic acknowledgement message, and set one follow up reminder for anyone who enquires and does not book. Our how it works page walks through where those live.
The one rule: no parallel running
This is where most migrations quietly fail. The spreadsheet gets kept "just in case", someone adds a client to it out of habit, and within a fortnight you have two half correct lists and trust in neither.
So: rename the spreadsheet file to ARCHIVE do not edit 2026-07-31, move it out of your working folder, and make it read only if your storage supports that. Keep it, because HMRC expects business records to be retained for at least five years after the January filing deadline for that tax year, as set out in the gov.uk guidance on self employed records ↗. But keep it as an archive, not as a living document.
From the moment you cut over, every new enquiry, every note, every follow up goes in the CRM. Every one. The businesses that get value from a CRM within a month are the ones that were ruthless about this on day one.
What good looks like four weeks later
You should be able to answer these four questions in under ten seconds each. If you cannot, something in the migration was skipped.
- Who enquired this week and has not had a reply?
- Which quotes are outstanding and how old are they?
- When did I last speak to a given client, and about what?
- Where did my last ten enquiries actually come from?
That fourth one tends to be the surprise. Most owners are confident they know their best lead source and most are wrong by at least one channel. A month of clean source data usually reallocates somebody's marketing budget.
Frequently asked questions
How long does a CRM migration really take for a small business?
For a solo or small service business with under 1,000 client records, an afternoon. The import itself is minutes. The hour of cleaning is what makes the difference between a CRM you trust and a CRM full of the same mess you started with.
Will I lose data moving from a spreadsheet to a CRM?
Not if you keep the original file. The CSV export is a copy, so the spreadsheet is untouched by the import. Archive it read only after cutover and you have a complete fallback that you will almost certainly never open.
What if my spreadsheet is a total mess?
Then import the last two years only and leave the rest in the archive. A CRM with 150 accurate records beats one with 900 records you do not believe. You can always import the older rows later if you find you miss them.
Do I need a CRM if I am a one person business?
If you get more than a handful of enquiries a month and any of them arrive when you are with a client, yes. Sole traders are exactly who loses work to slow replies, because there is nobody else to pick up the phone. Our sector guides for freelancers and tradespeople go into the specifics.
What does it cost to try?
Kabooly has a 30 day free trial, which is long enough to run a full month of real enquiries through it before you decide. Pricing is on the pricing page, in pounds, with no per seat surprises. If you want a hand with the import, get in touch and we will do the mapping with you.