Before you start
Moving from spreadsheets to a CRM is mostly a data-cleaning job. The import itself takes minutes. Getting the data ready is where the time goes, and where most problems start.
This checklist works for any CRM. Work through it in order. Skipping the early steps usually means cleaning up inside the new system later, which is harder.
1. Take stock of what you have
List every place customer information lives today. It's usually more than one:
- the main customer spreadsheet, and any older copies
- sales or enquiry trackers
- quote and invoice lists
- email address books and phone contacts
- your accounting software's customer list
- notes kept by individual team members
[STEVEN: the messiest set of sources you've seen a business migrate from.]
For each source, note who owns it, roughly how many records it holds, and when it was last updated. This tells you which source to trust when two disagree.
2. Decide what to bring across
Not everything deserves to move. Agree some rules before you start:
- Customers: bring across anyone you've worked with or quoted in a set period, such as the last few years. Archive the rest in the old file.
- Contacts: bring the people you actually deal with at each customer.
- Open leads: bring every live enquiry and quote, with its value and next step.
- Closed deals and old history: often better left in an archived copy, unless you need it for reporting.
- Products and prices: bring your current price list, not every price you've ever charged.
A smaller, cleaner start is better than a complete but messy one.
3. Check your lawful basis and consent
Moving data into a new system is a good moment to check you're handling it properly under UK GDPR.
- Make sure you have a lawful reason to keep each kind of personal data.
- Don't bring across data you no longer need.
- For marketing emails to individuals, check what consent you hold and where it came from. Carry that record across with the contact, not just a yes or no.
- Note the new system in your privacy information and records, if your setup requires it.
If you're unsure, the ICO's guidance for small businesses is a good starting point.
4. Clean the data
Work in a copy of the spreadsheet, never the original. Then go column by column:
- Names: one format for business names. Decide whether it's "Smith & Co Ltd" or "Smith and Co Limited", and stick to it.
- People's names: split first and last names into separate columns if the CRM expects them.
- Email addresses: remove spaces, fix obvious typos, and delete addresses you know have bounced.
- Phone numbers: one format throughout.
- Addresses: separate columns for street, town, county, postcode and country. Check postcodes look valid.
- Dates: one date format throughout, and real dates rather than text like "next week".
- Values: numbers only. Remove "£" signs and notes from value columns.
5. Remove duplicates
Duplicates are the most common problem after a migration. Look for:
- the same business under slightly different names
- the same person with two email addresses
- the same phone number written different ways
- the same company at the same postcode
[STEVEN: a duplicate pattern that caught you or a customer out.]
Decide which record wins, merge any useful details into it, and delete the rest. Sorting by postcode, then by name, finds many of them quickly.
6. Map your columns to the CRM
Most CRMs import from a template or let you match your columns to their fields. Before you import:
- download the CRM's import template if it has one, and read every column heading
- decide which of your columns goes into which field
- note any of your columns with no matching field, and decide whether to drop them or create a custom field
- check which fields are required, and fill any gaps
Keep a short note of the mapping. You'll want it if you need to import again.
7. Import in the right order
Records depend on each other. A contact belongs to a customer. A lead belongs to a customer. Import in an order that respects that:
- customers
- contacts at those customers
- open leads and opportunities
- products and price lists
- suppliers, if you use them
8. Test with a small batch
Import ten or twenty records first. Then open each one in the CRM and check:
- names and addresses look right
- phone numbers and emails are in the right fields
- special characters, like apostrophes and accented letters, have survived
- values and dates are correct
Fix the source and try again until a small batch comes through clean. Only then import the rest.
9. Import, then check the errors
Most import tools report rows that failed and why. Don't ignore them. Fix the rows in your spreadsheet and re-import just those. Then compare the record counts in the CRM against your source. They should match, less any duplicates you removed.
10. Cut over on a set date
The riskiest period is when both the spreadsheet and the CRM are in use. People update one and forget the other.
- Pick a date after which all new work goes into the CRM.
- Make the old spreadsheet read-only on that date and store it somewhere safe.
- Tell the team clearly, and check in after the first week.
[STEVEN: how long you'd suggest running both side by side, if at all.]
11. Keep it clean afterwards
A clean import stays clean only with a few habits:
- search before creating a new customer
- agree who can create and delete records
- run a duplicate check every few months
Moving into Beagle
If you're moving into Beagle CRM, imports use Excel (.xlsx) templates for customers, leads, contacts, products and suppliers. The customer import previews which rows are ready and which need attention before anything is created. The help centre explains how to import customers, and you can read more about Beagle for small businesses.
The checklist
- List every source of customer data and who owns it.
- Agree what to bring across, and what to archive.
- Check lawful basis and marketing consent, and carry consent records across.
- Clean names, emails, phones, addresses, dates and values.
- Remove duplicates.
- Map your columns to the CRM's fields.
- Import customers first, then the records that depend on them.
- Test a small batch before the full import.
- Fix and re-import failed rows, and compare record counts.
- Cut over on a set date and make the spreadsheet read-only.
- Keep it clean with simple habits.