How to move your customer list from spreadsheets into a CRM

Step 1: Gather everything in one place

Collect every list you use: the main spreadsheet, the accounts package’s customer list, phone contacts, the email newsletter list. Save a copy of each before you touch anything.

Step 2: Decide what is worth moving

Not every row deserves a place in your new system. A sensible rule for a small business:

• Move current customers and anyone you have dealt with in the last two to three years.
• Move open quotes and live opportunities.
• Archive old prospects who never replied.

Also consider whether you still have a good reason to keep each person’s details. Our Privacy Act guide covers why that matters.

Step 3: Clean the list

• Split names into first and last name columns.
• Separate people from businesses. One file for companies, one for contacts with a company name column to link them.
• Remove duplicates. Sort by email, then by phone, and merge rows that are the same person.
• Standardise formats. Phone numbers in one style, states as abbreviations, dates as DD/MM/YYYY.
• Fix obvious errors such as missing @ signs or numbers in name fields.

Step 4: Map your columns

Your CRM will ask which spreadsheet column goes into which field. Write the mapping down before you start. Columns that don’t match a standard field can often go into custom fields; if they’re not useful, leave them behind.

Step 5: Import a small sample first

Import 20 rows. Open a few records and check that names, emails, phone numbers and company links look right. It is far easier to fix the mapping now than to clean up 2,000 records later.

In NovaSoft One, the Data Hub import shows a preview of what will be created and flags problem rows before anything is saved. Paid plans keep an import history and can roll back an import if something went wrong.

Step 6: Import the rest and check

Once the sample looks right, import the full list. Then:

• Spot-check ten random records.
• Run a duplicate check.
• Assign owners to your active customers.
• Add next-step tasks for open deals.

Mistakes that make migrations painful

• Importing everything. Old, duplicated and incomplete rows make the new system feel as messy as the old one.
• Mixing people and businesses in one file. You lose the link between a contact and their company.
• Skipping the test import. A wrong column mapping repeated across thousands of rows takes days to fix.
• Leaving owners blank. Records without an owner are nobody’s responsibility.
• Running two systems. Updates end up split between the spreadsheet and the CRM, and neither is right.

A simple one-week plan

For a business with a few hundred customers, that is realistic alongside normal work. Larger lists take longer mainly because of the cleaning step.

After the move

For the first month, check in weekly. Are people finding what they need? Are any fields missing or unused? Small adjustments early make the CRM fit your business and stop people drifting back to old habits.

Checking the import worked

After the import, pick ten records at random and compare them with the original file: names, emails, phone numbers, company links and owners. Then search for two or three customers you know well and check their details look right. Run a duplicate check and a count of records, and compare the count with your cleaned file. If the numbers don’t match, find out why before anyone starts relying on the system.

Step 7: Stop using the old list

The most common mistake is running both systems “for a while”. Pick a date, tell the team the CRM is now the source of truth, and make the spreadsheet read-only.

Common questions

This guide is general information for Australian businesses, not legal, tax or financial advice. Check anything specific to your situation with a qualified adviser or the relevant government agency.