Setting unique identifier in import file

[LucyM]

Hi, 

I'm uploading my first set of records into HubSpot and am having trouble with the unique identifer part.  

The information I am uploading includes Contact and Company info. I'd like to set the Unique Identifier as the email address, but each time I try and upload, I get an error message saying that I haven't used a Unique Identifier.  Can anyone help?  

Thanks, 

Lucy 

[TiphaineCuisset]

Hi @LucyM 

Thank you for reaching out!

Have you followed all the steps detailed here? You will need the unique identifier in both the excels. 

If you've followed all the steps, I would recommend connecting with HubSpot Technical Support, as Support is included in your subscription and they will be able to provide real-time assistance for this matter, where you are able to share screenshots and specific examples about this. 

Thank you!

Best

Tiphaine

[LucyM]

Hi Tiphaine, 

Thanks for getting back to me, yes I have followed those steps, but actually realised I've merged the data into one Excel file, so maybe that's the issue!  Does the email address column have to be named differently, or should it pick it up automatically as my Unique Identifier?  

And thank you, that's great to know about support!  

Many thanks, 

Lucy 

[TiphaineCuisset]

Hi @LucyM 

Thank you for your reply!

If you've put the email, that should work it's strange... did you put "Email" as the column title? Then, in the map step, make sure to double check this has been mapped to the email contact property - and that should work

Hope that helps.
Have a lovely day,
Tiphaine.

[LucyM · Accepted solution]

Hi Tiphaine, 

Thank you, so I didn't have the company domain included, which was needed as it was a mix of contact and company data! 

Many thanks for your help.  

Best, 

Lucy