Home / Import contacts into a CRM

How to import contacts from Excel into a CRM (and clean them first)

Moving a spreadsheet of contacts into HubSpot, Salesforce, Zoho or any other CRM? Five minutes of cleanup before the import saves hours of fixing duplicates, broken fields and bounced emails afterward. Here's the whole process.

Step 1: Clean the list before it goes in

A CRM imports whatever you give it. If your spreadsheet has the same person three times, a typo like gmial.com or a row with no email at all, those problems move straight into your CRM, where they're much harder to fix.

Before importing, fix these:

  • Duplicates, including the same email in different capitals (JANE@ and jane@).
  • Domain typos such as gmial.com, yahoo.con or hotmial.com.
  • Broken entries: missing @, spaces inside the address, two addresses in one cell.
  • Extra spaces before or after names and emails, which stop the CRM matching records.

The free List Fixer does all of this in one go, right in your browser. It keeps every column (names, phone numbers, tags) and lists every change it made, so nothing disappears without you knowing. Prefer a spreadsheet? Use the free cleaning template instead.

Step 2: Get the columns ready

  • One header row at the top, with a clear name for each column: First Name, Last Name, Email, Phone, Company. HubSpot, for example, requires the first row to be a header row whose names match its properties.
  • One contact per row and one value per cell. Split "Jane Cooper" into First Name and Last Name if your CRM has both fields.
  • One sheet per file. HubSpot allows only one sheet in an import file, so delete or move any other tabs.
  • Consistent dates, all in the same format (for example 2026-11-12).
  • No merged cells, formulas or pictures. Copy and paste as values if your sheet uses formulas.

Step 3: Save it in the right format

Most CRMs accept Excel files, but CSV is the safest choice and the only one some tools take. In Excel, choose File > Save As > CSV UTF-8 (Comma delimited). The "UTF-8" part keeps accented names like José or Zoë from turning into strange symbols; HubSpot asks for UTF-8 when a file has foreign-language characters. If names are already garbled, the free garbled text fixer can repair them.

Step 4: Check your CRM's limits

CRMFile typesHow many at once
HubSpot.csv, .xlsx, .xls (one sheet)Up to 1,048,576 rows per file on paid tiers; 20 MB files on free tools
Salesforce (Data Import Wizard)CSVUp to 50,000 records at a time
Zoho CRMXLS, XLSX, CSV, vCard10,000 to 50,000 rows per import, depending on edition

From each company's help pages, checked November 12, 2026. Limits change, so check your own plan. For a bigger list, split it first with the free Split List tool.

Step 5: Map the columns and avoid duplicates

During the import, the CRM asks which of your columns matches which of its fields. Match Email to Email, First Name to First Name, and so on, and skip any column you don't need.

Then tell it how to recognize contacts that already exist. HubSpot can use Email as the unique identifier for contacts; without one, an import can create duplicates instead of updating existing records. Zoho CRM can match on email too, and skip rows that match an existing contact. Choose email matching whenever it's offered.

Already have contacts in the CRM? Export them first and use Compare Lists to find which people in your spreadsheet are new and which are already there.

Step 6: Test with a few rows first

Import 5 or 10 contacts before the whole file. Open them in the CRM and check that names, emails, phone numbers and dates landed in the right fields. If something's off, fix the mapping and delete the test contacts before running the full import.

Should you verify the emails before importing?

For a fresh list, an old list or a file someone handed you, it's worth it. Cleaning fixes the format of each address, but a browser can't tell whether a mailbox still exists. Most CRMs only find out an address is dead when an email to it bounces, and a lot of bounces can push your future emails toward spam.

That's what Veml, ListaFix's sister service, is for: upload the cleaned file, pay once (no account), and get the same spreadsheet back with every column kept plus a status for each address. Import only the ones marked Passed.

Common questions

Can I import an Excel file straight into a CRM?

Most CRMs accept Excel or CSV. HubSpot takes .csv, .xlsx and .xls with one sheet per file; Zoho CRM takes XLS, XLSX, CSV and vCard. Salesforce's Data Import Wizard works with CSV files. When in doubt, save as CSV UTF-8.

How do I stop a CRM import creating duplicates?

Remove duplicates from the file first, then tell the CRM which field identifies a contact. HubSpot can use Email as the unique identifier for contacts, and Zoho CRM can skip rows whose email matches an existing record.

How many contacts can I import at once?

It depends on the CRM and plan. Salesforce's Data Import Wizard handles up to 50,000 records at a time. Zoho CRM allows 10,000 to 50,000 rows per import depending on edition. HubSpot's paid tiers allow up to 1,048,576 rows per file.

Should I verify emails before importing into a CRM?

For a new or old list, yes. A CRM usually learns an address is dead only when an email bounces, and too many bounces can hurt delivery for everyone else on the list.

Sources: HubSpot: Set up your import file; Salesforce: Data Import Wizard; Zoho CRM: Import data. ListaFix isn't affiliated with HubSpot, Salesforce or Zoho.