6
min Read Time
-
Miltos Stavridis

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.

What you’ll get from this process

A short run that reliably delivers:

  • 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.

6
min Read Time
-
Erik Plischke

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.

8
min Read Time
-
Eric Mattner

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.

Du willst Sales schnell skalieren?

Vermeide kostspielige Fehlentscheidungen und skaliere deinen Vertrieb in Monaten statt in Jahren (falls überhaupt).