Import HubSpot Contacts With Their Associated Companies

An event signup export often names the company in each contact row. Map an identifier for each object so those contacts attach to the right company even when its display name has several spellings.

Worked example

Three rows for a test import

Email,First name,Company Record ID
[email protected],Nia,89001
[email protected],Dev,89001
[email protected],Cam,89002

Expected association count = Three links across two company records

Steps

  1. Export existing company Record IDs when you are updating known companies. If you use the company domain instead, check for subsidiaries or existing records that share a domain.
  2. In a two-object import, map email to the Contact object and company domain or Record ID to the Company object. Use HubSpot's sample for the same file arrangement.
  3. Import a test batch with two contacts at one company and a third at another. Open all three contacts and confirm their company associations in the record sidebar.
  4. Review the import's errors and check the company count. Correct unresolved identifiers before importing the remaining rows.

What to check

  • Make sure Record ID maps to Company. The contact and company versions identify different objects.
  • Treat an ambiguous company name as a review item. Assigning a unique identifier after review prevents accidental duplicates.

View HubSpot

References