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.
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.
| File types | Size limit | Duplicate handling | Help moving from another CRM | |
|---|---|---|---|---|
| Unavoidable CRM | CSV | 20 MB, up to 50,000 rows per file | Matches on email or the last 9 digits of the phone number; skip or update | Free 15-minute setup call on every plan; spreadsheet import |
| HubSpot (free tools) | CSV, XLSX, XLS | 20 MB per file, 500,000 rows a day | Matches contacts on email or Record ID; without one it creates duplicates | Self-serve import |
| Capsule | CSV or Excel | Not stated on the page read | Not described on the page read | Free migration from over 25 CRMs through Import2 |
| Tradify | CSV (convert Excel first) | Not stated on the page read | Customer name is the ID; matching names update mapped fields | Self-serve import |
| Jobber | CSV, TSV, PSV | Under 2.5 MB (about 5,000 rows) | No automatic matching described; admin users only | Sample 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.
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.
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.
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.
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.
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.
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.
14-day free trial, every feature, no card needed. From £29 a month per business.
Start free trial →