Importing database companies and contacts

Hi @AMa4,

Welcome to the HubSpot Community!

Since HubSpot can’t automatically associate your company records with your contacts (because you’re missing the company domain in the company import file), you have to make that information available in some other form. The only way (other than by company domain) that I know of would be by using a unique identifier column. Here are two import files for fictional records including such a column.

Contact file:

Company file:

40933i63222092D6ABC8D8.png

Here’s a quick screen recording for the import steps themselves:

40936iD1D093B4D4DE8EFF.gif

(The legal basis of course should reflect the status of your records. For the purpose of this demonstration, I chose “not applicable”. This post does not consitute legal advice.)

If you have a contacts file with notes, you would omit that notes column the first time around. (Here’s a HubSpot example for what an import file of an object + notes should look like.) After the first import, you’d go back and re-import that contact file (HubSpot will not create additional contacts because of the email as unique identifier). This time, you select File from computer > One file > Multiple objects > Contacts + Notes.

Hope this helps!