From Excel to a CRM without losing data: four steps

Moving from a spreadsheet to a CRM without losing data takes four steps: clean the sheet, choose the CRM, import the file and work in parallel for a while before dropping the sheet. The hardest part is not the import but getting the team to use it.

Reviewed on 2026-10-10. BAI Business offers a CRM and publishes this article; that is why we also say what to do with any other.

Signs that the spreadsheet no longer works for you

If you recognise three or more, it is time:

• Several people edit at once and overwrite each other's changes.
• When someone goes on holiday, their customer follow-up stops.
• Preparing the weekly sales report takes a long time of filtering and copying and pasting.
• You don't know how many open deals you have at each stage without counting them by hand.
• Invoices go out with out-of-date details because someone copied an old address.

If you have few active customers and work alone with no plans to grow, the spreadsheet may be enough for now.

The four steps

Step 1: clean the sheet before migrating

The most common mistake is migrating the sheet as it is: the CRM inherits the mess. First:

• Make a full backup. It is rule number one.
• Keep the active customers. Those with years of no contact go into a history sheet that you keep but don't migrate.
• Standardise the formats. The same phone number written three ways becomes three different records; the CRM won't fix that for you.
• Remove the duplicates in the sheet, where it is easier.
• Decide which columns come across. Almost always a few are surplus.
• Gather the scattered notes into a single field.

Step 2: choose the CRM

Choose according to the size of the team, what you want to connect to the CRM (invoices, appointments, website) and how the provider charges. Before paying, try a free plan or a trial and check that you can export your data. The criteria are in How to choose a CRM for your small business.

Step 3: import the file

Most CRMs accept a file. HubSpot, for example, supports .csv, .xlsx and .xls, asks for a header row whose columns correspond to its own fields and creates duplicate records if the file has no unique identifier, such as the email (source: HubSpot, accessed on 2026-10-10). The steps are similar in all of them:

1. Save the clean sheet as a file.
2. Upload it to the CRM and check which field each column goes to.
3. Decide what to do with the duplicates; the prudent choice is to skip them and not overwrite.
4. Import and check that the number of contacts is what you expect.

Step 4: work in parallel for a while

Don't cut off the sheet on the first day. Work in the CRM as your main system and keep the sheet as a copy for a month. After that, check whether the information is better in the CRM: if so, drop the sheet; if not, adjust first.

The most common mistakes

• Migrating years of old data. A CRM full of inactive contacts is slow and confusing.
• Not training the team. A perfect migration with a team that doesn't use it changes nothing. Spend a few hours teaching how to create a contact, log an activity and move a deal.
• Expecting the CRM to fix a badly defined process. It makes it visible; it doesn't fix it. First define what a qualified contact is, what stages a sale has and who looks after each customer.
• Paying for features you don't use. Start with the simplest and move up when you need to.
• Having no owner. If nobody looks after the data, in six months the CRM is as messy as the sheet. Assign an owner from day one; it doesn't need to be full-time.

Where BAI fits

According to the sheet for its CRM solution, in BAI Business you upload your customers from your spreadsheet and the repeated ones are merged by email and phone; each customer, supplier or company has a record with its history, its tags and who looks after it, and whatever arrives through forms, bookings or the receptionist goes into its record. You can see it on the CRM for your business page. If you are looking for a purely sales CRM, some programs focus more on that part.

Frequently asked questions

When is it time to move from a spreadsheet to a CRM?

When several people edit the same sheet and overwrite each other, when the follow-up of a customer stops if the person responsible is away, or when you don't know how many open deals you have without preparing a report by hand.

Do I lose data when importing?

Not if you keep a full copy of the sheet before starting. Whatever the CRM doesn't accept you can recover from the copy.

What file format does a CRM accept for importing?

It depends on the CRM. HubSpot, for example, supports .csv, .xlsx and .xls files, asks for a header row and creates duplicates if the file has no unique identifier, such as the email (accessed on 2026-10-10).

What if I choose the wrong CRM?

Try a free plan or a trial first and check that you can export your data. That way, if you switch, you take your customers with you.

You may also be interested in

• First 30 days with a new CRM: what to set up after importing.
• How to choose a CRM for your small business: the selection criteria.

Sources

• Prepare your import file in HubSpot, accessed on 10 October 2026.