What holds most teams back from moving to a CRM isn’t the price or the choice of tool. It’s the fear that something will go missing on the way. Years of leads and notes sit in one file, and you’re being asked to trust a stranger’s software with them.
The reassuring part is that a spreadsheet move is one of the more predictable jobs in software. It follows the same steps whichever system you pick, and most of the effort is thinking rather than typing. (If you haven’t yet decided whether to move, seven signs your sales team has outgrown its spreadsheet might help.)
Decide what’s coming with you
Open the sheet and be ruthless. Over the years it’ll have collected columns nobody fills in, leads that went cold in 2019 and half-finished notes. Carrying all of that into a new system just recreates the clutter somewhere more expensive.
Sort the leads into three piles. Live leads must come across with every detail. Dormant ones worth keeping can come too, tagged so they’re easy to filter out. Dead ones stay in the archived file.
Then save a copy with today’s date in the name, and don’t touch it again. That’s your safety net. Agree a day when the live sheet stops being updated, because the worst moment of any move is finding a lead edited in two places.
Tidy before you import
A clean import is much easier than a messy one, and an hour’s work here saves days later. Sort by company name and by email and remove the repeats. Fix the variants, because to a computer “Fuel Wise”, “Fuelwise” and “FUELWISE Ltd” are three companies. Put phone numbers and dates in one format. Split cells that hold two things, like a name and a number. Make sure every lead has one row, and strip out the empty rows and merged cells that trip up almost any import.
Work out where each column goes
This is the step that matters most, and it’s worth doing on paper. Company, contact, email and phone are obvious. “Source” becomes the lead source, “Rep” becomes the assigned rep and “Next call” becomes a callback date.
The one that surprises people is status and value. In a CRM they belong to the deal, not the lead, because a lead can have more than one deal. A customer might have a quote open for one product and a renewal coming up for another, and the lead page shows both.
Anything specific to your business, such as fleet size or renewal month, should become a custom field rather than being dumped into a notes box. A custom field can be searched and reported on. A note can’t, not easily. Our post on what to track in a sales spreadsheet is a useful test of which columns deserve a place.
Import a few first, then the lot
Don’t import everything as your first move. Pick ten or twenty rows that cover the awkward cases: a lead with several contacts, one with a very long note, one with a missing phone number, one with a callback date. Import those and open each one next to the spreadsheet.
You’re looking for names cut off or merged, dates that have flipped between day-first and month-first, values in the wrong currency and notes that stopped halfway. Fix the cause, whether that’s the sheet or the column mapping, and repeat until the sample is right.
Then import the rest and check again. Open a few leads at random, and count. If the sheet had 640 leads and the CRM shows 612, find the missing 28 before you do anything else.
At Henkan CRM you don’t do this alone. Our team imports your spreadsheet for you, whether it’s Excel, Google Sheets or another CRM, and you can bring in lists yourself too. Every import is checked for duplicates. The capture page explains the options.
The switch-over
Pick a quiet day and make it a clean break. Take a final export that morning, import anything that’s changed, and tell the team that from now on the CRM is the only place leads live. Then make the old sheet read-only, rename it with “ARCHIVE” and the date, and keep it for a few months.
Resist running both side by side for long. Two sources of truth is how the original problem starts, and it’s also how a CRM quietly dies, because people drift back to the file they trust. How to stop that happening is the subject of getting your whole team to use the CRM.
The first fortnight
Sit with people as they work their first few leads. You’ll hear what’s missing from the lead screen within a day or two, and adding a field is a five-minute job. The teams that struggle are the ones who leave it alone and hope.
As for how long all this takes, for a typical team it’s a morning to tidy the sheet, a morning for the sample import and checks, and about a day for the full import and switch-over. The slow part is nearly always deciding what each column becomes.
It’s worth knowing that you can always get your data out again, as CSV or Excel. Ask any supplier about that before you sign anything, us included. And if you’re curious how the two compare job by job, we’ve set that out on the Henkan CRM vs spreadsheets page.
What about old notes and emails?
People worry about history, and sensibly. Our advice is to be practical. For live leads, write a short summary of the story so far and put it in as the first note, with the key dates. You don’t need to import five years of email threads, and you’ll rarely miss them. Where a document really matters, such as a signed agreement, keep it attached to the lead rather than in a shared drive nobody can find.
If your data is in more than one place
Many teams have more than one sheet: one per rep, one for web enquiries, one for customers. Combine these before you import, not after. Decide which is the master where the same company appears in two, and use something stable such as email address or company name to spot duplicates. It’s dull work, but it’s the part that makes the new system trustworthy from day one. If you’d rather not do it alone, bring all the files to your demo and tell us what you’ve got.
If you’d like to see your own spreadsheet in Henkan CRM, book a demo and bring a copy with you.




