How to Migrate From Spreadsheets to a CRM (Without Losing Your Data or Your Mind)
This article contains affiliate links. If you purchase through links on this page, we may earn a commission at no extra cost to you.
Migration Is a Data Quality Problem
If your contacts live across three spreadsheets and your follow-ups are Post-it notes, a CRM fixes that. The migration is where people come unstuck, usually by pressing import on a chaotic spreadsheet and then wondering why the CRM is just as messy as what they left.
This guide covers the full sequence: cleaning the data, resolving your UK GDPR position before you import anything, mapping fields properly, testing with a small batch, and keeping a rollback. Capsule CRM and Zoho CRM appear throughout as worked examples, since both are common among UK small businesses and both have decent import tools.
Step 1: Clean and Deduplicate First
It is far easier to fix data in a spreadsheet than to unpick a bad import inside a CRM.
Remove Duplicates
Sort by email address and company name and look for the same contact appearing twice, once from a trade show list and once from manual entry. A spreadsheet maintained for a few years will usually have more duplication than you expect.
Excel’s Data then Remove Duplicates is a starting point, not an answer. It matches exact text, so “Smith & Sons Ltd” and “Smith and Sons” both survive. Merge by hand: keep the fullest record, check the other for anything worth carrying across, then delete it.
Standardise Fields
Pick one format and apply it everywhere. Phone numbers as 07700 900123 or +447700900123, not both. One convention for Ltd or Limited. One version of job titles. Correct postcodes if you plan to filter geographically.
Two file-level details save a lot of pain. Save the CSV as UTF-8, or accented names and pound signs arrive as gibberish. And write dates in ISO format, 2026-03-14, which no importer can misread, rather than relying on the system to interpret a British date correctly.
Keep a short note of the decisions you made. You will need it when you come back to this in six months.
Step 2: Sort Out UK GDPR Before You Import Anything
Most migration guides skip this. You cannot pour an entire contact database into a new system and call it done.
Lawful Basis
Every personal data record needs a documented lawful basis. For B2B contacts that is usually legitimate interests, where you have a genuine business reason and it does not override the individual’s rights. For consumer contacts, particularly for marketing, consent is normally the basis.
Ask of each group: did we collect this ourselves or buy it, do we know when and how, and have these people engaged with us in the last year or two? Bought lists you cannot verify and contacts who went cold years ago are the risky ones.
Marketing Consent, PECR and the Soft Opt-In
Marketing by email or text is governed by the Privacy and Electronic Communications Regulations as well as UK GDPR, and the rules are more specific than “we have their address”.
The general position is that you need consent. The main exception is the soft opt-in: you can email existing customers about similar products or services where you collected their details during a sale or negotiation, provided you offered an opt-out at the time and offer one in every message since.
There is also a distinction people get wrong. PECR treats corporate subscribers, meaning companies, LLPs and public bodies, differently from individuals, and unsolicited B2B email to those organisations does not require consent. Sole traders and ordinary partnerships are treated as individuals, so if your list is full of one-person trades businesses, the consumer rules apply.
Add a column called Marketing Consent with values such as “Yes, opted in, date”, “No”, or “Unknown”, and only migrate the first group into anything that feeds a campaign. Zoho CRM has custom fields for consent status, and Capsule supports tags such as “Marketing opt-in” to filter contacts.
The Penalties Changed in 2026
Worth knowing before you decide how careful to be. The Data (Use and Access) Act 2025 took effect on 5 February 2026, and the maximum fine for breaching PECR’s marketing rules rose from £500,000 to £17.5 million or 4% of global turnover, matching UK GDPR levels. The old requirement to show that a breach caused substantial damage or distress has also gone.
For a small business the realistic exposure is a complaint and an ICO investigation rather than a headline fine. The point is that sloppy marketing data is no longer a cheap risk.
The Practical Rule
Do not migrate data you have no lawful basis to hold. A bad migration carries legal exposure into a system where the data becomes more searchable and more likely to be used. If a record is old, unverifiable or from a source you would not want to name to the ICO, delete it before import rather than after.
While you are in the file, action any erasure requests you have received and never got round to.
Your Contract With the CRM Provider
The CRM company processes personal data on your behalf, which means you need a written processor agreement with them under Article 28. Both Capsule and Zoho publish one; it is usually a click-through as part of the terms rather than a negotiation, but you should know where yours is.
Check where the data is stored, and if it leaves the UK, which transfer mechanism the provider relies on, whether that is the UK’s International Data Transfer Agreement, the addendum to the EU standard clauses, or the UK extension to the EU-US Data Privacy Framework. Then make sure your privacy notice reflects the categories of recipients you now use.
Step 3: Standardise Your Column Headers
CRMs import by matching your columns to their fields. Make that easy.
| Instead of | Use |
|---|---|
| Cust Name | First Name and Last Name, in two columns |
| Tel | Phone |
| Biz | Company Name |
| Notes from last call | Notes |
| Status | Contact Status |
Split full names into two columns. Importing a combined name field is the most common cause of reversed or blank names.
Delete columns with no equivalent in the CRM: formulas, colour-coding references, anything that only made sense in the old workflow.
Step 4: Map Columns to CRM Fields
In Capsule, the import tool sits in the People and Organisations area, takes a CSV and walks you through mapping to its standard fields. It supports custom fields, so create anything unusual, such as Trade Category or Preferred Contact Method, before you import rather than after.
In Zoho CRM, import lives under Contacts or Leads, and the first decision is which of those your records are. Leads are unqualified prospects; Contacts are customers and qualified prospects. Getting this wrong is tedious to unpick, so decide before you start. Zoho’s mapper puts your headers beside its fields, and anything unmatched can go to a custom field or be skipped. Note what you skip, and confirm you genuinely do not need it.
Step 5: Run a Small Test Import
Do not import 1,200 contacts on the first attempt. Take 10 to 20 records, mixing complete ones, incomplete ones and a couple of edge cases such as an organisation with no named contact.
Then check that names have not reversed, that phone numbers and emails look right, that custom fields have populated, that tags have carried across, and open two or three records against the spreadsheet line by line.
If anything is wrong, delete the test records, fix the source file or the mapping, and run it again. Twenty minutes here saves hours later.
Step 6: Full Import With a Rollback
Before you start the full run:
- Save a timestamped copy of the cleaned spreadsheet somewhere outside the CRM. That file is your rollback.
- Export any data already in the CRM, so you have a baseline to return to. Both Capsule and Zoho export to CSV.
- Import outside working hours if a team uses the system, so nobody opens half-populated records.
Afterwards, spot check a small percentage of records against the spreadsheet, looking particularly for data that has landed in the wrong field, which is what inconsistent formatting produces.
Common Mistakes
Importing everything rather than what is current. Dead leads and people who left their company three years ago inflate your numbers, confuse the team and create exposure.
Skipping the cleaning stage. A dirty spreadsheet imported into a CRM is a dirty CRM with a nicer interface.
Not training the team before go-live. If half of them keep using the spreadsheet “just for now”, you have two sources of truth within a week.
Choosing the wrong record type. In Zoho especially, prospects imported as Contacts rather than Leads cause workflow problems.
Leaving the old spreadsheet editable. Do not delete it, but move it to an archive folder and remove edit rights so it stops being updated after go-live.
FAQ
How long does a migration take?
Under 500 contacts: a working day for cleaning, a couple of hours for the import and checks. Between 500 and 2,000: two to three days. Cleaning always takes longer than people expect, especially where several people have maintained the file.
Do I need to tell contacts their data has moved?
You do not need to notify people individually about moving data between systems you control. You should check that your privacy notice still describes who processes data on your behalf, and if the new provider stores data outside the UK, that your notice and transfer arrangements reflect that.
What if my spreadsheet has columns the CRM does not support?
Use custom fields, created before you import. If a column has no purpose in the new system, that usually tells you it was not being used productively in the old one.
Should I import historical notes?
Be selective. Import notes that carry real context: an agreed price, a preference, a piece of feedback. Leave three years of “left voicemail” entries behind. Clutter is what stops people using a CRM.
Which CRM is easier to import into?
Capsule is the gentler process for a first migration, with a free plan for two users and 250 contacts and paid tiers from £14 per user per month billed annually. Zoho CRM’s importer is more powerful once you understand Leads versus Contacts, and its paid plans start at £12 per user per month billed annually or £16 monthly.
Migrating From Spreadsheets to a CRM: The Bottom Line
The sequence is the whole job. Clean the data first, resolve your GDPR and PECR position before the import tool is open, standardise the headers, map carefully, test with twenty records, and keep the cleaned spreadsheet as a rollback.
The part worth slowing down for is the consent column. It is the one decision in this process that has legal consequences, and it is much easier to make before the data is in a system that will happily email all of it.
Prices and product details correct at time of writing and subject to change, so confirm current details with the provider. This article is general information about UK data protection, not legal advice, and it does not take account of your circumstances. Check the current position with the ICO and take professional advice on your own marketing data before relying on anything here.