Moving off Excel: how to move your customer records without losing anything
16 October 2026 · Staffold

Spreadsheets are the most common business system there is. They're flexible, free and familiar, which is exactly why they end up holding years of a business's history: customers, jobs, policies, bookings, notes, who said what and when.
Moving all that into a proper system can feel risky. What if something gets lost? What if it comes across wrong? The good news is that a careful move is mostly a matter of preparation, and you don't have to switch off the spreadsheet until you're sure.
1. Find every spreadsheet
Start by gathering everything, not just the main file. Most businesses have more than they think:
- The main customer list
- Separate sheets for jobs, bookings, policies or renewals
- A mailing list, and a note of who unsubscribed
- Old versions saved by different people ("customers FINAL v3")
- Contacts that only live in someone's phone or email address book
- Notes in a notebook or a Word document
Spreadsheets kept by different people rarely agree. Gathering them together is the first time you'll see where they differ.
2. Decide what each row is
Before tidying anything, decide what the new system should hold. For each sheet, ask: what is one row? A customer? A job? A visit? A person at a company?
This matters because a spreadsheet often mixes them. A row might be a job, with the customer's name, phone and address typed out again on every job they've ever had. In a proper system the customer is one record, and their jobs hang off it. Spotting this early saves a lot of duplicates later.
3. Tidy the columns
A system wants one kind of thing in each column. Common fixes:
- Split full names into first and last name if the system wants them apart, and businesses from people
- Put each phone number and email in its own column, not "07700 900123 / john@..." in one cell
- Make dates real dates, in one format, rather than "next spring" or "w/c 5th"
- Give each status one spelling: "Active", not "active", "ACTIVE" and "current"
- Move long notes into a notes column, so they come across as notes rather than squashed into a name
You don't have to make it perfect. You do have to make it consistent.
4. Merge the duplicates
The same customer often appears several times: once per job, once in the mailing list, once with a typo. Sort by email address, then by phone number, then by name and postcode, and decide which is the true record. Where two rows disagree, the most recent is usually right, but not always, so look.
If you're not sure whether two rows are the same person, leave them separate and make a note. It's easier to merge two records later than to untangle a wrong merge.
5. Keep the unsubscribes
This one is easy to miss. If anyone has asked not to receive your marketing emails, that request has to come with them. A move to a new system is not a fresh start for consent. Make sure the people who unsubscribed stay unsubscribed in the new system, from the first day.
6. Export as CSV
Most systems import CSV files: plain text, one row per line, columns separated by commas. In Excel, use File, then Save As, and choose CSV, one sheet at a time. In Google Sheets, it's File, then Download, then CSV. Keep the original spreadsheets untouched as your backup.
7. Try a small import first
Import twenty or thirty rows before the whole lot. Then open a few of those records in the new system and check them against the spreadsheet: names, numbers, addresses, notes, dates. If anything's in the wrong field, fix the column mapping and try again. It's much quicker to correct this on thirty rows than on three thousand.
A good import tool matches columns for you, refuses to create duplicates of records already there, and lets you undo a whole import if it went wrong.
8. Check it with the people who use it
Once everything is in, ask the people who know the customers best to look through it. They'll spot the wrong phone number, the customer who moved, the two businesses with the same name. This is the step most often skipped, and the one that catches the most.
9. Switch over when you're ready
Keep the spreadsheet running alongside the new system while you check. When you're happy, pick a day to switch, bring across anything added since the first export, and from then on make the spreadsheet read-only. Rename it so nobody updates it by habit.
What won't come across
It's worth being clear about what a move can and can't do. Your records come across: customers, contacts, history and notes. Your habits don't. The formulas, colour-coding and conditional formatting that made the spreadsheet work were standing in for things a proper system does differently, such as reminders, statuses and reports. Expect to set those up again, better, rather than copy them.
A quick checklist
- Every spreadsheet found, including the old copies
- One row means one thing, and you know what
- One kind of data per column, in a consistent format
- Duplicates merged, or flagged if you're unsure
- Unsubscribes kept unsubscribed
- A small test import checked by eye
- The whole import checked by the people who know the customers
- The old spreadsheet made read-only on switch-over day
How Staffold helps
Every Staffold build includes a free switch: we take your spreadsheets as they are, tidy them, merge the duplicates and show you anything we're unsure of before it goes in. You check it all in your new system before you go live, and keep your spreadsheet until you're happy. Read how moving from spreadsheets works, see what comes across from other systems, or get in touch.