Moving from a spreadsheet to a CRM is a big step up for any small business. But the first import is where things often go wrong: the same client appears three times, phone numbers land in the wrong field, or half the contacts are missing their email.
The good news is that both Zoho CRM and HubSpot can spot duplicates during import, as long as your spreadsheet is prepared properly. This guide shows how to clean your Excel file first, then import into HubSpot or Zoho CRM step by step, without creating a mess you’ll spend weeks fixing.
Still deciding between the two? Read our HubSpot vs Zoho CRM comparison, or CRM vs spreadsheet if you’re not sure you need a CRM yet.
Step 1: Clean Your Excel File First
Most duplicate problems start in the spreadsheet, not the CRM. Spend 20 minutes here and the import becomes easy.
Use one row per contact and clear column headers
Keep one header row at the top, with simple names that match CRM fields:
| Column header | Example |
| First Name | Priya |
| Last Name | Sharma |
| [email protected] | |
| Phone | +91 98xxxxxxxx |
| Company | Sharma Traders |
| City | Bhubaneswar |
Delete merged cells, blank rows, notes in the margins and summary rows like “Total”.
Make sure every contact has an email
Both CRMs use email address as the main way to recognise an existing contact. Contacts without an email can’t be checked for duplicates, so they’re the ones most likely to be created twice. Fill in missing emails where you can, and keep the rest in a separate sheet to review.
Remove duplicates inside the spreadsheet
- Trim stray spaces: add a helper column with =TRIM(LOWER(C2)) for the email column, then copy and paste it back as values.
- Select your data and go to Data → Remove Duplicates.
- Tick only the Email column and click OK. Excel tells you how many duplicates it removed.
Before deleting, check whether the “duplicate” rows hold different phone numbers or notes worth merging into the row you keep.
Tidy the formats
- Phone numbers: use one format, ideally with the country code, such as +91 or +1.
- Names: split full names into First Name and Last Name columns.
- Dates: use one format, such as YYYY-MM-DD.
- Dropdown fields like Lead Status: make sure values match what the CRM uses.
Step 2: Save as CSV and Test With a Small Batch
- In Excel, go to File → Save As and choose CSV UTF-8 (Comma delimited). UTF-8 keeps names with accents or Indian-language characters from turning into strange symbols.
- Keep your original .xlsx file as a backup. Never edit only the CSV.
- Make a second CSV with just 5 to 10 contacts, including one you know already exists in the CRM.
Import the small test file first. If the existing contact updates instead of being duplicated and the fields land in the right places, you’re ready for the full list.
Both CRMs also accept .xlsx files directly, but CSV is the safest format and avoids hidden formatting problems.
Step 3: Import Into HubSpot
HubSpot is forgiving: it automatically uses email address to avoid duplicate contacts. If an email already exists, HubSpot updates that contact instead of creating a new one.
- In HubSpot, go to CRM → Contacts.
- Click Import (top right), then Start an import.
- Choose File from computer, then One file and One object, and select Contacts.
- Upload your CSV.
- Map columns: HubSpot matches your headers to its properties. Check every row, fix anything matched wrongly, and choose Don’t import column for anything you don’t need.
- Choose how to handle existing records. Picking Create and update contacts updates existing contacts by email and adds new ones.
- Name the import, tick the consent box confirming these contacts expect to hear from you, and click Finish import.
When it finishes, HubSpot shows how many contacts were created, updated or had errors. Click the error report to see what failed and why.
Tip: if you also import companies, HubSpot matches them by company domain name, such as sharmatraders.com, so include a domain column to avoid duplicate companies.
Step 4: Import Into Zoho CRM
Zoho CRM asks you to choose what to do with duplicates during the import, so pay attention at that step.
- In Zoho CRM, open the Contacts module (or Leads, if these are new prospects).
- Click the arrow next to Create Contact and choose Import Contacts, then From File.
- Upload your CSV and check that Zoho reads the header row correctly.
- Choose how to handle duplicates. Zoho asks what to do with records already in the CRM:
- Add as new creates all rows as new contacts. Avoid this for lists that may overlap.
- Update existing only changes matching contacts but adds no new ones.
- Add new and update existing is usually the right choice.
- Set the field Zoho uses to find existing contacts to Email.
- Map fields: match each column to a Zoho field, and skip columns you don’t need.
- Review the summary and click Import.
Zoho emails you when the import finishes, with a count of added, updated and skipped records. Open Import History to review any rows that failed.
Menu names can vary slightly between Zoho CRM editions, but these options appear in every version’s import wizard.
Step 5: Check and Clean Up After the Import
Even with a clean file, check the results before your team starts using the CRM.
- Compare the numbers. The import summary should roughly match your spreadsheet: new plus updated should equal your row count, minus errors.
- Open a few random contacts and check that names, phones and companies landed in the right fields.
- Search for a contact you know was duplicated in the old spreadsheet and confirm there’s only one record.
- Fix errors from the error file, then import just those rows again.
Merging duplicates that slipped through
- HubSpot: open a contact, click Actions → Merge, and pick the duplicate. HubSpot also suggests possible duplicates under Contacts → Actions → Manage duplicates, though this depends on your plan.
- Zoho CRM: use Deduplicate from the module’s action menu to find records with the same email or phone, then merge them.
If the import went badly
Don’t try to fix hundreds of records by hand. Both CRMs let you find all records from a specific import. Delete that batch, fix the spreadsheet, and import again.
Once your contacts are in, the next step is putting the CRM to work. See how to automate client onboarding without coding.
Related guides: The Small Business Software Stack: What You Actually Need (and What It Costs)
FAQ
Does HubSpot remove duplicates automatically when importing?
Yes, for contacts with an email address. If an imported email already exists, HubSpot updates that contact instead of creating a new one. Contacts without an email can still be duplicated.
How does Zoho CRM handle duplicates on import?
Zoho asks you during the import. Choose to add new records and update existing ones, and select Email as the field to match on.
Can I import directly from Excel, or do I need CSV?
Both CRMs accept .xlsx and .csv files. CSV UTF-8 is the safest choice, especially for names with special characters.
What if my contacts don’t have email addresses?
You can still import them, but neither CRM can reliably detect duplicates without email. Clean these carefully in Excel first, and match on phone number in Zoho if your plan allows it.
Is there a limit on how many contacts I can import?
Both have file size and row limits that depend on your plan. For very large lists, split the file into smaller batches.
Can I undo an import?
Not with one button, but you can filter records by the import and delete that batch, then try again with a fixed file.
Final Word
A clean CRM starts with a clean spreadsheet. Give every contact an email, remove duplicates in Excel, save as CSV UTF-8 and test with 10 rows before importing everything. HubSpot then handles duplicates by email automatically, and Zoho does the same once you choose “add new and update existing” with Email as the match field.
Do it carefully once, and your team starts with one reliable list instead of three messy ones.


