Guides
How to migrate to a new CRM without losing data
Published November 12, 2026 · 8 min read
To migrate to a new CRM without losing data, export what you have as CSV, remove duplicates and contacts without usable details, recreate your pipeline stages in the new tool, import contacts before deals, and check a sample before you call the move finished. Keep the old tool read-only for a few weeks. Automations and templates are the two things that do not move on their own, so plan to rebuild them.
Before you start: decide what to migrate
Write down what you have and what your team actually uses. Not everything is worth carrying over:
- Contacts and companies: essential.
- Deals: always the open ones, plus closed deals from the last one or two years.
- Activities and notes: useful if the team looks at them. If nobody has opened them for years, archive them instead.
- Documents and invoices: usually they stay in your invoicing system, not in the CRM.
- Automations and templates: rebuild them, and use the chance to review them.
A migration is also a clean-up. What you leave behind stays behind.
From Excel or a spreadsheet
This is the most common case for small businesses, and it brings the most duplicates:
- Merge the tabs into one table, with one row per contact.
- Normalize the columns: name, company, email, phone, stage, value, date.
- Remove duplicates by email or phone. Check the ones that share a name but have different details.
- Drop rows with no usable detail: a row with no email, no phone and no name is no use.
- Save the file as CSV in the encoding the new CRM accepts.
A practical tip: before you import, count your contacts and your open deals with their total value. Those figures become your final check.
From another CRM
Moving from another CRM follows the same pattern, with two differences: the data is more connected and you have more stages to recreate.
- Export contacts, companies and deals separately. Most CRMs allow CSV export.
- Check the relationships: a deal should point to a contact and a company. If the export does not include them, match them by email or name.
- Recreate the stages of your pipeline in the new CRM before you import deals.
- Map custom fields and decide which ones to keep.
If you are coming from HubSpot, Pipedrive or Clientify, our comparison pages go into tool-specific detail: HubSpot alternative, Pipedrive alternative and Clientify alternative.
From Holded
If your customers are already in Holded, a business software suite from Spain, Flowgration can import them with an API key: you paste the key and the customers come across with their tax details. Products and the invoice history are not imported as such. You can keep old invoices as a record in the original system. More detail is on the Holded alternative page.
The import order matters
- Contacts and companies first, so they exist before you link anything to them.
- Deals next, assigned to their contact and stage.
- Activities and notes last, if you import them.
If you import deals before contacts, many will be left unlinked and you will have to fix them by hand.
Clean up before you import
Before you touch the new CRM, resolve these:
- Duplicates. Decide which record is the right one when there are two.
- Consent. A contact with no legal basis to receive marketing messages should not come in as a marketing contact. Read our GDPR and CRM guide.
- Empty or test records. Delete or fix entries such as "test" or "xxx".
- Stage names. Map old stages to the new ones before you import.
If your database has serious problems, our guide on cleaning up a customer database gives you a method.
How to check the migration worked
Looking at five records is not enough. Run three checks:
- Counts. The number of contacts and deals should match the source, minus the duplicates you removed on purpose.
- Totals. The sum of open deals should match the source.
- Sample. Review at least 20 records at random, including some of your most important clients.
If a check fails, stop and fix it before you go on.
What you have to rebuild
- Automations. Rebuild each flow with its triggers, waits and conditions.
- Email templates. Move your templates across and review the copy.
- Permissions. Decide who sees what in the new CRM.
- Integrations. Reconnect your shop, email and invoicing.
Include this in your plan. It usually takes longer than importing the data.
Common mistakes
- Migrating everything without filtering. You carry the rubbish across and clean it up later, which is harder.
- Closing the old tool on day one. Keep it read-only for a few weeks.
- Skipping the stage recreation. Deals lose their context.
- Not telling the team. Everyone should know where things are from the first day.
Frequently asked questions
How long does a CRM migration take?
For a small business with a few thousand contacts, the import itself usually takes a day or two. Cleaning the data, rebuilding automations and getting the team used to the new tool take longer. Plan at least two weeks of transition.
Can I migrate without losing a customer's history?
It depends on what the source tool exports. Usually you can bring contacts, companies, deals and notes. Check beforehand what is exported and what is not, so you are not caught out.
Do I have to migrate invoices too?
Usually not. Issued invoices live in your invoicing system and are exported to the register for your accountant. If you need them in the CRM, check how the new tool handles them.
What should I do with the old tool?
Keep it read-only for a few weeks, and export a full copy before you cancel. Store that copy somewhere safe for as long as your accountant advises.
Can I migrate from a spreadsheet?
Yes, that is the most common case. Merge the sheets, remove duplicates and save a CSV. Before you import, count your contacts and open deals so you have a final check.
Build your WooCommerce CRM in 60 seconds
Flowgration turns your store's orders into a living CRM and runs email, SMS and WhatsApp on autopilot. Free up to 500 contacts.
Start free