Hi everyone,
I’m trying to create Contact-to-Contact associations between existing contacts in HubSpot using a CSV import.
Here’s a sample of my file:
| Contact ID |
Association label |
Contact ID |
| 123 |
|
345 |
| 123 |
|
346 |
The first association (123 → 345) is created successfully, but the second one (123 → 346) fails with a “Duplicate record ID” error.
I can manually associate multiple contacts with the same contact, but the CSV import only processes the first one and skips the rest.
Has anyone faced this issue or found a workaround? I’d appreciate any help in getting multiple associations to import correctly.
Hi @Phoenix_,
The “Duplicate record ID” error happens because HubSpot’s importer treats each row in your CSV as a unique record to be created or updated. When it sees the same Contact ID in the first column on multiple rows, it flags the subsequent entries as duplicates.
To associate multiple contacts with a single contact in one step, list all the associated Contact IDs in the same cell in your CSV, separated by a semicolon.
Here’s an example:
| Contact ID |
Associated Contact ID |
| 123 |
345;346 |
This will instruct HubSpot to associate both contacts with IDs 345 and 346 with the contact with ID 123.
I hope this helps resolve the issue for you.