HubSpot Data Import Guide (2025): Clean Links, Zero Guesswork
Getting companies and contacts into HubSpot isn’t hard—keeping associations intact and duplicates out is the real game. This guide gives you a practical flow you can repeat any time, plus a light cleanup routine so Sales, Marketing, and CS can trust the data.
Correct company ↔ contact links via Company Record IDs
Minimal duplicates and a simple way to resolve the rest
A repeatable import you can hand off to the team
Good to have before you start: export/import rights in HubSpot, Excel/Google Sheets, and 20 minutes for a small test batch.
The 6-Step Import—explained simply
You’ll import companies first, capture their Record IDs, then bring in contacts that carry those IDs.
1) Export companies already in HubSpot
Grab your current truth:
Go to CRM → Companies → Export
Include Company Name, Company Domain Name, Company Record ID
Why: this gives you the IDs you’ll need to link contacts to existing accounts.
2) Add those IDs to your contacts file
Open your contacts sheet and:
Add a column Company Record ID
Use a quick lookup (VLOOKUP/XLOOKUP) against the company export by Domain or Name
Result: contacts tied to existing companies now carry the correct ID
3) Create missing companies
New accounts that don’t exist yet:
Put them into a separate “New Companies” sheet (Name, Domain, Address, City, Postal Code, Region, Country; optional Sales Motion)
Import via CRM → Companies → Import (companies only)
HubSpot generates Record IDs for these newcomers
4) Re-export companies to capture fresh IDs
After Step 3, export companies again (or filter to just the new ones) with Name / Domain / Record ID
Now you have complete, up-to-date IDs for everything
5) Second lookup for contacts tied to the new companies
Back in the contacts file, fill Company Record ID for contacts belonging to the newly added companies
Sanity check: every contact row has a Company Record ID
6) Import contacts (with associations)
Head to CRM → Contacts → Import and choose company and contact import
Upload the contacts file that includes Email and Company Record ID
HubSpot will auto-associate each contact to the right company
Pro tip: run a 50-row test first, confirm associations, then ship the full batch.
Data cleanup: quick, safe, and client-friendly
The goal is a trusted dataset—no ghost duplicates, no formatting weirdness.
Open Manage duplicates (Contacts or Companies → Actions top-right)
Click Review and decide which record to keep; the other merges into it
Prioritise Email for contacts and Domain for companies
Reject a duplicate suggestion when both entities must remain (e.g., adidas.de vs. adidas.ch)
Note: without Operations Hub Professional, bulk fixes are limited—plan small rolling batches. Align with the client first: what to merge, what to keep separate.
Best practices that keep imports boring (in the best way)
A few practices keep this whole process pleasantly boring. Stage the work in the same order every time: companies first, re-export for fresh IDs, then contacts. Treat Company Record ID as the primary association key—names and domains can change, IDs don’t. Normalize obvious format quirks up front (lowercase domains, consistent company naming) to avoid false duplicates. Document your column-to-property mapping and keep the exact files you used in each run; if you ever need to audit or roll back, you’ll be grateful. And always start with a small test import; those 50 rows will surface 90% of edge cases before they become thousand-row problems.
Stage it: companies → re-export for fresh IDs → contacts
Require keys: Email on contacts; Domain on companies
Trust IDs: use Company Record ID for associations (names change, IDs don’t)
Normalize first: lowercase domains; consistent company naming to avoid false dupes
Document mappings: save the exact column-to-property map and all exports for auditability
Test small: 50 rows expose 90% of edge cases—fix once, scale confidently
Common pitfalls (and the fix in one line)
Contacts with no Email → enrich or expect dupes
Name-only matching → switch to Domain/Record ID
Orphaned contacts after import → ensure Company Record ID is present
Over-merging multi-entity brands → set a rulebook (legal entity/region/BU) and reject false dupes
No stakeholder sign-off on merges → agree written rules before bulk actions
Frequently Asked Questions
Do I have to import companies first?
Yes. You need Record IDs to associate contacts cleanly.
Can I link by domain only?
You can, but Record ID is safer and future-proof.
What if many contacts don’t have emails?
Expect duplicates or enrich first—Email is the strongest de-dupe key.
We have multiple regions/brands—merge or separate?
Create a rulebook and reject duplicate suggestions that shouldn’t merge.
Do I need Ops Hub Pro?
Not for importing, but it accelerates bulk duplicate/formatting fixes.
Other Articles
9
min Read Time
-
Erik Steffen
ABM with HubSpot for B2B-SaaS Enterprise: A Pilot-First Playbook You Can Actually Ship
ABM pays off when your product is complex, the ACV is high, and the total number of winnable accounts is small. The mistake most teams make? Over-automating too soon and under-investing in data discipline and weekly rituals. This guide gives you the sweet spot: just enough structure to run a credible pilot in 90 days—using HubSpot as the backbone—without burying your team in tooling.
No-Bullshit Sales Reporting in 2025 (with HubSpot): What to Track, Why it Matters, and How to Ship It
Great reporting isn’t a wall of charts. It’s a shared language the whole GTM team uses to decide what to do next week. In 2025, the winning teams use HubSpot to make performance visible, coachable, and forecastable—without turning reps into part-time data clerks. Below is a practical playbook that blends clear narrative with punchy checklists you can implement right away.
HubSpot Marketing Contacts (Enterprise): How to Cut Cost, Keep Control, and Still Scale
When your database runs into the millions, “just make everyone a Marketing Contact” becomes an expensive habit. The good news: HubSpot lets you store unlimited contacts in CRM while only paying for the subset you actually market to. Mastering this lever is the difference between tidy, predictable budgets and runaway license bills.
Below is a practical guide for Marketing Ops, RevOps, and CRM admins who need to balance reach, compliance, and cost—with clear definitions, pricing logic, enterprise best practices, and a rollout checklist you can use today.