Moving from spreadsheets to a CRM without losing what matters

1. List what you hold

Start by finding every place where customer information lives. This usually means more than one spreadsheet: a main customer list, a quotes file, a jobs file, email folders, contact lists on phones, and paper notes.

For each source, write down what it holds, who updates it, and how often. This list is your map for the rest of the move.

2. Clean it

Old data usually has problems. Fix them before you move anything, because a CRM will only be as good as what you put in. Look for:

• the same person written in two or three different ways;
• phone numbers and addresses in different formats;
• blank cells where something important should be;
• customers who have not been in touch for many years;
• notes that mix several kinds of information in one cell.

3. Decide what to keep

Not everything needs to move. Decide with your team which records are still useful, which should be archived, and which can go. Keep any records you are required to hold by law or by contract, and ask your adviser if you are unsure how long that is.

Moving less is not a loss. A smaller, cleaner set of records is easier to trust and to use.

4. Match the fields

Fields are the labelled boxes in a record, such as name, email, address and job type. Make a table with the column from your spreadsheet on one side and the matching field in the CRM on the other.

Some columns will have no home in the CRM yet. Decide whether to add a field, merge the information into notes, or leave the column out. Decide too which system holds the main copy of each piece of information once the move is done.

5. Run a trial import

Before the real move, import a small sample, perhaps a few dozen records, into a test copy of the CRM. Then check them against the spreadsheet. Are the names right? Did the dates arrive correctly? Are the notes in the right place? Are there duplicates?

Fix the problems and run the trial again until the result is what you expect. Only then move the full set.

6. Run both for a short time

For a short period, keep the spreadsheet as a safe copy while the team starts to use the CRM for new work. Do not update both by hand for long, because that doubles the work and causes mistakes. Instead, pick a date after which the spreadsheet is read-only.

Keep a backup of the original files in a safe place, so you can go back and check something if you need to.

7. Train the team

A CRM is only useful if the people who use it every day are comfortable with it. Show each person the few tasks they will do most: adding an enquiry, finding a customer, adding a note, and setting a next action.

Choose one person to answer questions in the first weeks, and write down the answers so new staff can use them later. Ask the team what is awkward, and be ready to change the setup.

Decide who owns each step

A move like this goes wrong when nobody is clearly in charge. Name one person who owns the whole plan, one who checks the data against the old files, and one who signs off that the team is ready to switch.

Write down the date of the switch, the date the old spreadsheet becomes read-only, and what happens if the trial import shows problems. Having these decisions on paper makes the final weeks calmer, and it makes it easy to see what is still open.

Keep the old data safe

Do not delete the original files straight after the move. Keep a read-only copy for as long as your business needs it, and store it where it is backed up. When you no longer need it, delete it safely. If something looks wrong in the CRM weeks later, the old file is the quickest way to see what the record said before.

A note on data that is hard to move

Some information is harder to move than a list of names. Email history, attachments and files may not export in a usable form from your current tool. Check this early, so you are not surprised on the day.