if i want to create new set of data (removing existing one) with association between contacts-companies-deals-calls should i import all four files together and they will build association between four of them?
Hi @SSingh822,
No need to cross-post, I already answered your query here: https://community.hubspot.com/t5/Tickets-Conversations/Association-between-contacts-and-deals/m-p/1224496/highlight/true#M8998
To answer your question here: Yes, that’s also an option – during the import process, select the objects you want to import and HubSpot will show the option to generate a sample file for you as a reference.
Best regards
Hi @SSingh822 , yes, you can import all four objects together, but there are a couple of important nuances to be aware of so expectations are set correctly.
When you do a multi-object import, HubSpot will only create associations if each file includes a shared unique identifier that HubSpot can use to link records. For example:
- Contacts - Companies via company domain
- Contacts - Deals via email or contact ID
- Deals - Calls via deal ID or call ID
If those linking columns are missing or inconsistent, HubSpot will happily import the records but won’t associate them.
Also, importing “new data” does not automatically remove existing associations or records. Imports are additive by default. If your goal is a clean rebuild, you usually need to:
- Delete or archive existing records first, or
- Import with a unique ID and explicitly overwrite properties (associations won’t be removed unless you handle that separately).
HubSpot’s sample file generator during import is actually very helpful here. It shows you exactly which columns are required for associations across selected objects (Format import files).
One practical tip: if this is a large or sensitive reset, test with a small subset first. Associations are easy to create, but painful to unwind at scale.
If you want, the key question is: are you trying to replace everything or just restructure associations going forward? The approach changes quite a bit depending on that goal.