Why Lucro Pricing

Blog › Corporate

CRM Migration: How to Move From Spreadsheets or an Old CRM Without Losing Data

Tony·14 January 2025·5 min read

Nobody enjoys changing CRM. I get it. Your customer list is basically the business, and the thought of it going missing halfway through a move is enough to make most people put it off for another year.

Here’s the reassuring bit. For a firm of one to five people, it’s normally a few days of work, spread over a week. We do these imports for customers all the time, so this is roughly the order we’d tackle it in.

Where are your customers right now?

Start by being honest about this. In most small firms the answer is “a bit everywhere”. The spreadsheet. A slightly older copy of the spreadsheet on Sarah’s laptop. Mobile phones. The sent folder. QuickBooks. And yes, the notebook by the phone.

Write the list down. You won’t move every scrap, but you’d hate to find out in March that your best repeat customer only existed in someone’s phone.

What’s worth bringing?

Ask yourself whether you’ll want it in the next year. If yes, it comes. If not, it can probably stay put.

So: today’s customers, anyone you’ve done work for lately, open quotes, and the notes you’d be annoyed to lose. That might be a price you agreed, or the fact that one client hates being rung before lunch. Also note who looks after whom.

Leave the rest. The people you last spoke to in 2019. The doubles. The list of names from that exhibition you never emailed. Keep a full archive copy if it makes you feel better, and only import what’s live.

Exporting customer data from a spreadsheet before a CRM migration

Make a safe copy first

Before anything else, export. CSV or Excel, from every place on your list. Save those files in a folder with the date on and then leave them alone.

That folder is your undo button. If an import ever goes wrong, you can start over from scratch and nothing is lost.

Tidy it, but not too much

Paste it all into one sheet. Then spend an hour, no more, sorting the worst of it. You’ll find “Smith & Co” and “Smith and Co Ltd” sitting next to each other – merge them. Decide how you write phone numbers. If the new system wants first name and surname in separate boxes, split them. Delete any row with no way of actually contacting the person.

Don’t chase perfection here. Honestly, it’s easier to carry on cleaning once it’s all imported.

Line up the columns

Every system names things a bit differently. Your sheet says Tel, theirs says Phone. You say Firm, they say Company. The import screen will ask you to match them up one by one. Go slowly. This is where most mistakes creep in.

Got a column that doesn’t fit anywhere, like how each customer found you? Turn it into a tag. Easy to add, easy to search on later.

Checking a test batch of customer records after importing them into a new CRM

Do a test run

Bring in twenty customers. Not two thousand – twenty. Then open a few and look properly. Has the surname ended up in the first name box? Has the 0 dropped off the front of the mobile numbers? Are the notes there?

If something’s wrong, you’ve lost two minutes rather than a whole afternoon. When it looks right, import the rest.

Pick a day to switch

Choose a date and tell everybody. After that, new stuff goes in the new system only. Keep the old one around for a few weeks so people can look things up, but nobody adds to it.

Skip this and you’ll regret it. If both stay open, people drift back to what they know, and before long you’ve got two half-complete records for every customer.

Show the team, then step back

Half an hour does it for most small teams. How to add someone, log a call, set a reminder, find an existing customer. That’s it. Let them get going and answer questions as they pop up.

A couple of weeks in, ask what’s annoying them. It’s usually something small, like a field in a daft place or a template that’s missing, and sorting it makes a real difference.

Common migration mistakes

Moving the lot without looking. You just carry the old mess into the new place.

Not keeping the original export. Without it there’s no going back if something breaks.

Never switching off the old system. Set a date and stick to it.

Leaving it to one person. Whoever deals with customers should check their own records once they’re in.

Moving to Lucro

If you’re moving to Lucro, you don’t have to do the import yourself. Send us your spreadsheet or an export from your old CRM and our team will load it for you free of charge, on any plan. Your data is held on encrypted servers in UK data centres, and paid plans include automatic daily backups.

Lucro is built for teams of one to five, so there’s very little to configure once your data is in. You can start on the Free Forever plan with no card and upgrade when you need more. See our CRM pricing for small business, or compare a CRM against spreadsheets if you’re still deciding.

Related reading

Questions, answered

How long does a CRM migration take for a small business?

Usually a few days, not weeks. Finding and cleaning your data takes the longest. The import itself is quick, especially if you test a small batch first and the provider helps with the rest.

Can I move from Excel or Google Sheets to a CRM?

Yes, and it's one of the most common moves for a small business. Save the sheet as a CSV, match your columns to the CRM's fields and import. Lucro will do the import for you free if you'd rather not.

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

Not if you export them. Most systems let you export notes along with contacts, though email history is harder to carry across. Keep a dated copy of every export so nothing is lost for good.

Should I clean my data before or after migrating?

A bit of both. Remove obvious duplicates and fix phone formats first, but don't aim for perfect. It's easier to carry on tidying in the new CRM once everything is in one place.

How do I stop staff using the old system after the switch?

Set a switchover date and make the old system read-only from then. People can still look things up, but anything new has to go into the new CRM. A few weeks later, retire it altogether.

Does Lucro help with moving my data?

Yes. Send us your spreadsheet or an export from your old CRM and we'll load it for you free, on any plan, including the Free Forever plan. Your records are stored encrypted in UK data centres.

Try Lucro freeThe simple CRM for teams of 1–5 — no card needed, and we’ll import your customer data for you.
Start free
Written by TonyNews, tips and guides for businesses of 1–5 people.

Keep reading

Put the ideas into practice.

Lucro keeps customers, follow-ups, quotes and invoices in one place. Free forever — no card needed.

Start free