CRM

wademak
Participant

Importing Client Contacts & Companies

SOLVE

When I import my CSV file for companies, the contacts and email are a default property but when the company is imported, there is no contact associated with the company even though it's in the CSV file.

I've tried everything but can't figure it out.

Help?

1 Accepted solution
Mike_Eastwood
Solution
Key Advisor | Gold Partner
Key Advisor | Gold Partner

Importing Client Contacts & Companies

SOLVE

Hello,

After chatting with @wademak we found out what the challenge was...

Here's a detailed set of instructions for importing associated Contacts and Companies when they have similar emails and/or domain names.

Importing Contacts and Companies with multiple branches/offices

In the HubSpot CRM if you have "Automatically create and associate companies with contacts." turned on then HubSpot will try and help you - which is not always what we want. HubSpot will associate companies based on email address and domain, plus it will de-duplicate based on domain.

You can opt-out, or exclude, a domain so HubSpot will stop trying to associate the contacts and companies (in our example below you would exclude example.com).

So, if you have multiple branches with the same, or similar domain names they could end up all in the same company.

Here's a really simple example (you may have lots more properties you want to import):

Screen Shot 2019-01-26 at 1.16.06 PM.png


If you import this file normally you would end up with five people in the same company.

Here's how to import them as separate companies and contacts associated with each company.

  1. Turn of "Automatically create and associate companies with contacts." or exclude the domains to stop the association.

  2. Check your data - a sanity check now could save lots of pain later.

  3. Save your data as a CSV twice - exactly the same file - one named Contacts.csv and one named Companies.csv

  4. Import your contacts into HubSpot: Contacts > Import (button top right).

  5. Click Start and Import (button top right)

  6. What would you like to Import? Choose File from computer. Then click Next.

  7. How many files are you importing? Choose Multiple files with Associations. Then click Next.

  8. Select the objects you's like to import and associate. Choose Contacts and Companies. Then click Next.

  9. Upload your files. Choose and upload a file for Contacts and a choose and upload a file for Companies. (Yes, we know it's the same file but HubSpot doesn't). Then click Next.

  10. How to associate your data. In the select list choose Unique ID. You will now be asked "Which object is Unique ID the unique key for?" choose Contacts. Then click Next.

  11. Map columns in your file to contact properties.

    If you've named your columns, with a header row, this should be easy.

    For each column map "Column Header From File" to corresponding "HubSpot Property".

    For "Unique ID" choose "Don't import column" at the bottom of the pop-up. Once you've mapped all the fields you want to include then click Next.

  12. Map columns in your file to company properties.

    Now we repeat the mapping for the companies. You don't want discard the "Unique ID" so select "Don't import column".

    You won't need "Frstname", "Lastname" and "email" in your Company so choose "Don't import column".  

    You do want to map "Company Name" and "Website" so map them and any other properties you want to import. Then click Next.

    WARNING: you want to map the "Website" to the "Website URL" NOT the "Domain" otherwise HubSpot will glue them all into one company.

  13.  Name your import with a sensible name so you know which import it is.
    Confirm you have permission to import these Contacts and Companies. Then click Next.

  14. Repeat the selection for the second file - choose Unique ID. Then click Next.

  15. Cross your fingers... you will see a message saying HubSpot is importing your Contacts and Companies.

    If you have lots of companies this may take some time... you will receive an email, and an alert, when the contacts and companies are imported.

  16.  Double check your Contacts and Companies have imported successfully. You will see, on the import screen, your import - which you named sensibly. Hover over the row and you will see View Contacts or Companies.

    Important: just because it worked doesn't mean it worked - you need to double check.

  17. Now you can relax...

 

 

Notes:

  1. One spreadsheet to rule them all. If you have everything in one sheet your life will be easier - less likely to get errors trying to link things across multiple sheets.

  2. If you think this is tricky then you should have tried the old way - what a nightmare - thank you HubSpot for making this sooooo much easier.

  3. I prefer exporting to CSV so Excel is not trying to "help me".

  4. Always use column headers in your import file - and name them the same as your HubSpot CRM Properties - it will make life much easier.

 

UPDATE

This ended up being an essay... then I wrote a more comprehensive version (with pictures) on our blog:

 

https://www.webalite.com/blog/import-contacts-companies-with-multiple-branches-hubspot-crm

 

View solution in original post

6 Replies 6
Mike_Eastwood
Solution
Key Advisor | Gold Partner
Key Advisor | Gold Partner

Importing Client Contacts & Companies

SOLVE

Hello,

After chatting with @wademak we found out what the challenge was...

Here's a detailed set of instructions for importing associated Contacts and Companies when they have similar emails and/or domain names.

Importing Contacts and Companies with multiple branches/offices

In the HubSpot CRM if you have "Automatically create and associate companies with contacts." turned on then HubSpot will try and help you - which is not always what we want. HubSpot will associate companies based on email address and domain, plus it will de-duplicate based on domain.

You can opt-out, or exclude, a domain so HubSpot will stop trying to associate the contacts and companies (in our example below you would exclude example.com).

So, if you have multiple branches with the same, or similar domain names they could end up all in the same company.

Here's a really simple example (you may have lots more properties you want to import):

Screen Shot 2019-01-26 at 1.16.06 PM.png


If you import this file normally you would end up with five people in the same company.

Here's how to import them as separate companies and contacts associated with each company.

  1. Turn of "Automatically create and associate companies with contacts." or exclude the domains to stop the association.

  2. Check your data - a sanity check now could save lots of pain later.

  3. Save your data as a CSV twice - exactly the same file - one named Contacts.csv and one named Companies.csv

  4. Import your contacts into HubSpot: Contacts > Import (button top right).

  5. Click Start and Import (button top right)

  6. What would you like to Import? Choose File from computer. Then click Next.

  7. How many files are you importing? Choose Multiple files with Associations. Then click Next.

  8. Select the objects you's like to import and associate. Choose Contacts and Companies. Then click Next.

  9. Upload your files. Choose and upload a file for Contacts and a choose and upload a file for Companies. (Yes, we know it's the same file but HubSpot doesn't). Then click Next.

  10. How to associate your data. In the select list choose Unique ID. You will now be asked "Which object is Unique ID the unique key for?" choose Contacts. Then click Next.

  11. Map columns in your file to contact properties.

    If you've named your columns, with a header row, this should be easy.

    For each column map "Column Header From File" to corresponding "HubSpot Property".

    For "Unique ID" choose "Don't import column" at the bottom of the pop-up. Once you've mapped all the fields you want to include then click Next.

  12. Map columns in your file to company properties.

    Now we repeat the mapping for the companies. You don't want discard the "Unique ID" so select "Don't import column".

    You won't need "Frstname", "Lastname" and "email" in your Company so choose "Don't import column".  

    You do want to map "Company Name" and "Website" so map them and any other properties you want to import. Then click Next.

    WARNING: you want to map the "Website" to the "Website URL" NOT the "Domain" otherwise HubSpot will glue them all into one company.

  13.  Name your import with a sensible name so you know which import it is.
    Confirm you have permission to import these Contacts and Companies. Then click Next.

  14. Repeat the selection for the second file - choose Unique ID. Then click Next.

  15. Cross your fingers... you will see a message saying HubSpot is importing your Contacts and Companies.

    If you have lots of companies this may take some time... you will receive an email, and an alert, when the contacts and companies are imported.

  16.  Double check your Contacts and Companies have imported successfully. You will see, on the import screen, your import - which you named sensibly. Hover over the row and you will see View Contacts or Companies.

    Important: just because it worked doesn't mean it worked - you need to double check.

  17. Now you can relax...

 

 

Notes:

  1. One spreadsheet to rule them all. If you have everything in one sheet your life will be easier - less likely to get errors trying to link things across multiple sheets.

  2. If you think this is tricky then you should have tried the old way - what a nightmare - thank you HubSpot for making this sooooo much easier.

  3. I prefer exporting to CSV so Excel is not trying to "help me".

  4. Always use column headers in your import file - and name them the same as your HubSpot CRM Properties - it will make life much easier.

 

UPDATE

This ended up being an essay... then I wrote a more comprehensive version (with pictures) on our blog:

 

https://www.webalite.com/blog/import-contacts-companies-with-multiple-branches-hubspot-crm

 

Mike_Eastwood
Key Advisor | Gold Partner
Key Advisor | Gold Partner

Importing Client Contacts & Companies

SOLVE

Hi @wademak 

 

When you import the Contact and Companies do your contacts have email addresses with the same domain name as the Company?


For example if you import a Contact with the email wademak@example.com and you have a Company with the domain company.com then HubSpot can automatically associate the contact to the company (doesn't work with Gmail, Hotmail, etc.).

 

You need to turn on Automatic Company Association here are the instructions.

 

One gotcha - with automatic association - you may end up with HubSpot guessing when it doesn't know the email and associating the Contact with a local ISP (Internet Service Provider).

 

If you are importing Contacts and Companies then HubSpot now lets you great associations on import - lifesaver!

 

Check out "2. Import objects with associations" on this page:

 

https://blog.hubspot.com/customers/everything-you-need-to-know-new-hubspot-import

 

Really greatful HubSpot have added this functionality recently.

 

Have fun

Mike

0 Upvotes
wademak
Participant

Importing Client Contacts & Companies

SOLVE

Thanks Mike, I appreciate the feedback. Is it just me or is it overly complicated to get your contacts into Hubspot?

 

I did figure out what I was doing wrong, I needed to import seperate Company and Contacts spreadsheets. 

 

Is there no way to associate a specific contact with a specific company on 1 spreadsheet? My issue now is that I have a realestate client with multiple locations with different names. However, each contacts email address are the same and link to the corporate URL so they get associated with the overall corporate company and not the specific loctation. If I import the contacs seperately, they all link to the head office.

 

Any ideas?

Thank you,

Wade

0 Upvotes
Mike_Eastwood
Key Advisor | Gold Partner
Key Advisor | Gold Partner

Importing Client Contacts & Companies

SOLVE

Nice work @wademak – sounds like you're making progress.

 

If all your data is in one spreadsheet - for sanity and safety - I recommend using one spreadsheet to import the Contacts and Companies.

 

Screen Shot 2019-01-23 at 12.39.41 PM.png

 

Column A is a unique ID (autonumbering in Excel is enough) used to link the Company to the Contact

Column E represents any other Contact Columns e.g. Contact phone number

Column H represents any other Company Columns e.g. Company phone number

 

If you're importing into an existing HubSpot Portal with existing data you may want to spin up a Trail Portal to test your import.

 

Is all you data in a single CSV file? Or multiple files?

 

Mike

 

 

0 Upvotes
wademak
Participant

Importing Client Contacts & Companies

SOLVE

Mike,

I did a trial run before it imported and it's asking me the property of the unique id column. Is it a company or contact property and what property is it?

Thanks,

Wade

0 Upvotes
wademak
Participant

Importing Client Contacts & Companies

SOLVE

Thanks again Mike, this is helpful. My next question is how do I set up a Trail? Portal so I don't mess up my current database.

To answer your question, my data is currently in multiple CSV files as I've been trying different ways to import and associate contacts.

 

My problem is that my contacts emails get associated with the corporate head office not the different locations they are in because they all end the same. I need to directly associate each contact with each location.

 

Wade

0 Upvotes