Stop HubSpot Imports From Creating Duplicate Contacts and Companies
You import a spreadsheet to update records you already have, and HubSpot creates new ones instead. This guide shows why that happens and how to stop it.
- How HubSpot deduplicates contacts and companies on import, in plain language
- A pre-import checklist to run before every import
- Choosing a unique identifier: Email, Company domain name, Record ID, or a custom unique property
- Updating existing records instead of creating new ones: export, VLOOKUP (formula included), split into update and create files
- A decoder for the duplicate-related import errors and what to do about each
- Finding and merging duplicates already in your CRM
- Worksheet and templates: import columns, duplicate log, post-import review