← Back to Blog
Guide

How to move your customer list into a new CRM without losing anything

6 min read · Updated 16 November 2026

Short answer: export everything from your old system as a CSV file, clean it once, import it with duplicate matching switched on, and check a sample before you switch the old system off.
In Unavoidable CRM (from £29 a month, 14-day free trial, no card) the importer maps your columns, matches duplicates by email or phone and shows you what it created, updated and skipped.

Most small businesses do not have a “database”. They have a spreadsheet, a phone full of contacts, an old job app and an inbox. Moving all of that into a new CRM is usually a half-day job, not a project, as long as you do it in the right order. This guide walks through that order, what to bring across, what to leave behind, and how the import tools in five CRMs compare.

What should you bring across?

Leave behind people you have no reason to keep, duplicates, test entries and old suppliers mixed in with customers. UK GDPR expects you to keep only what you need, so a move is a good moment to tidy up rather than copy every row forever.

How to move your customer list, step by step

  1. Export everything. Pull a full CSV export from each old system, plus your phone contacts if customers live there. Keep an untouched copy of every export somewhere safe.
  2. Put it in one sheet. Some systems split contacts, companies and notes across several files. Combine them so there is one row per customer.
  3. Clean it once. Use one column per field, fix phone numbers (format the column as text in Excel so numbers do not turn into scientific notation), delete blank rows and remove obvious duplicates.
  4. Record marketing permission. Add a tag or column for people who agreed to marketing. The ICO says you should keep a record of consent (who, when and how), and anyone who has opted out must stay opted out in the new system.
  5. Test with 20 rows. Import a small sample first, open a few contacts and check every field landed in the right place.
  6. Import the rest. Keep duplicate matching on, then read the summary of created, updated, skipped and failed rows.
  7. Run both for a week. Keep the old system read-only for a week while new enquiries go into the new CRM, then cancel it once nothing is missing.

Import tools compared (November 2026)

File typesSize limitDuplicate handlingHelp moving from another CRM
Unavoidable CRMCSV20 MB, up to 50,000 rows per fileMatches on email or the last 9 digits of the phone number; skip or updateFree 15-minute setup call on every plan; spreadsheet import
HubSpot (free tools)CSV, XLSX, XLS20 MB per file, 500,000 rows a dayMatches contacts on email or Record ID; without one it creates duplicatesSelf-serve import
CapsuleCSV or ExcelNot stated on the page readNot described on the page readFree migration from over 25 CRMs through Import2
TradifyCSV (convert Excel first)Not stated on the page readCustomer name is the ID; matching names update mapped fieldsSelf-serve import
JobberCSV, TSV, PSVUnder 2.5 MB (about 5,000 rows)No automatic matching described; admin users onlySample CSV file provided

Details are from each company’s own help pages, read in November 2026. Import tools change, so check the current page before you rely on a limit.

Where the others are strong

Where Unavoidable CRM is different

The trade-offs: there is no automated one-click migration from another CRM like Capsule’s Import2, the importer takes CSV rather than Excel files, and the Solo plan holds 1,000 contacts (Team holds 10,000 and Agency is unlimited). Count your list before you pick a plan.

Which should you choose?

If you are moving years of sales history out of another full CRM, a tool with automated migration such as Capsule may save you the most effort. If your customers live in a spreadsheet, a phone and an old job app, the import itself matters less than what the CRM does next. Start a free trial of Unavoidable CRM, import 20 customers, and see whether calls, quotes and reminders all land in one place before you move the rest. You can also see how we compare on our comparison page.

Questions people ask

Will I lose my notes and history when I move CRM?

Not if you export them and give them their own column. Most importers bring notes across as text, but call logs, emails and attachments often do not transfer from a spreadsheet. Keep your full exports for as long as you need them.

Can I bring my email marketing list with me?

Yes, but bring the permission with it. Under PECR you can email existing customers about similar products if they had a chance to opt out when you collected their details and in every message. Anyone who opted out should be imported as opted out, not left off and forgotten. This is general guidance, not legal advice.

How long does it take to move to a new CRM?

For a few hundred customers in one spreadsheet, allow an afternoon: an hour to clean, a test import, then the full import and checks. Messy data from several systems takes longer, and cleaning is where the time goes.

Can I get my data out again if I leave?

You should always check this before you move in. Unavoidable CRM lets you export your contacts at any time or ask for a full export, and deletes data from the live system within 30 days of leaving.

Related: how to choose a CRM for a small UK service business and our GDPR checklist for a CRM.

Try it on real jobs.

14-day free trial, every feature, no card needed. From £29 a month per business.

Start free trial →