Contacts

Associate records via import

Last updated: May 28, 2019

When importing records into HubSpot, you can create associations between two different record types by uploading a spreadsheet for each. You can also import notes in one file to be associated to the records in the other file.

Set up your spreadsheets

To associate records via import, set up an import file for each record type and include a common field in both to uniquely identify the records you want to associate. This field can be named anything, as long as they are the same in both import files, and can contain any string, as long as they match up.

If the records already exist in HubSpot, and you want the import to overwrite values for the existing deals rather than create new deals, export the existing deals and use the object ID from HubSpot as the unique identifier instead. 

An example is when you want to import new contacts and deals, and associate them:

  • Create two spreadsheets, one for contacts and one for deals. In each spreadsheet, create a "Common field" column.
  • In your contact import file, enter a unique string for each contact in the "Common field" column.
  • In your deal import file, for each deal, in the "Common field" column, enter the unique string of the contact you want the deal to be associated to.

Please note: if you upload files for existing contacts with email addresses or companies with company domain names, any existing information will be overwritten by new values you’ve imported. Learn how HubSpot deduplicates records.

Import your spreadsheets

  • In your HubSpot account, navigate to contacts, companies, deals, or tickets.
  • Click Import
  • Click Start an import
  • Select File from computer, then click Next
  • Select Multiple objects with associations, then click Next
  • Select the two objects to associate via import, then click Next.
  • Upload each of your record type spreadsheets into the corresponding section. If you are using object ID to deduplicate either or both of your files, check the corresponding Update existing [object type] using "Object ID" exported from HubSpot box. Click Next

relational-import-upload-your-files

  • Click the Common column headers found in your files dropdown menu and select the column header for the field used as the association identifier in both of your spreadsheets.
  • Click the Which object is [header] the unique key for? dropdown menu, and select the object type that this field is the unique identifier for (i.e., each row in the spreadsheet for this record type has a unique value for this field). This matters when there are many-to-one associations (e.g., many deals associated to one contact). Then, click Next

relational-import-map

  • Review and confirm your selection. Then, click Next
  • HubSpot will automatically match the columns in your file to your properties in HubSpot. If any columns do not match an existing property, click the corresponding dropdown menu, then select an existing property, or click Create new property to set up a new property to which this column will be mapped. Once you've mapped the columns in your files to properties in HubSpot, click Next.

    Please note: if you're importing contacts or companies with the object ID the Email or Company domain name property will not be mapped. If you're using a throw-away column for matching, you don't have to import the field.

  • Enter a name for your import. If the EU General Data Protection Regulation (GDPR) setting is enabled in your account and you're importing contacts, you will need to enter a legal basis for processing your contacts' data. 
  • Click Finish import