# Setting unique identifier in import file

**URL:** <https://community.hubspot.com/t/setting-unique-identifier-in-import-file/63405>\
**Category:** CRM\
**Created:** [August 21, 2022, 10:29am UTC](https://community.hubspot.com/t/setting-unique-identifier-in-import-file/63405 "2022-08-21T10:29:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![LucyM](https://avatars.discourse-cdn.com/v4/letter/l/a9adbd/32.png) [@LucyM](https://community.hubspot.com/u/LucyM)\
**Post date:** [August 21, 2022, 10:29am UTC](https://community.hubspot.com/t/setting-unique-identifier-in-import-file/63405/1 "2022-08-21T10:29:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![TitiCuisset](https://avatars.discourse-cdn.com/v4/letter/t/8baadc/32.png) [@TitiCuisset](https://community.hubspot.com/u/TitiCuisset)\
**Post date:** [August 22, 2022, 9:46am UTC](https://community.hubspot.com/t/setting-unique-identifier-in-import-file/63405/2 "2022-08-22T09:46:09Z")

</div>

Hi @LucyM

Thank you for reaching out!

Have you followed all the steps detailed [here](https://knowledge.hubspot.com/crm-setup/import-and-associate-multiple-objects#import-multiple-objects-in-two-files)? 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](http://help.hubspot.com/), 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

---

<div class="post-metadata">

**Author:** ![LucyM](https://avatars.discourse-cdn.com/v4/letter/l/a9adbd/32.png) [@LucyM](https://community.hubspot.com/u/LucyM)\
**Post date:** [August 22, 2022, 9:53am UTC](https://community.hubspot.com/t/setting-unique-identifier-in-import-file/63405/3 "2022-08-22T09:53:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![TitiCuisset](https://avatars.discourse-cdn.com/v4/letter/t/8baadc/32.png) [@TitiCuisset](https://community.hubspot.com/u/TitiCuisset)\
**Post date:** [August 23, 2022, 1:48pm UTC](https://community.hubspot.com/t/setting-unique-identifier-in-import-file/63405/4 "2022-08-23T13:48:15Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![LucyM](https://avatars.discourse-cdn.com/v4/letter/l/a9adbd/32.png) [@LucyM](https://community.hubspot.com/u/LucyM)\
**Post date:** [September 2, 2022, 1:31pm UTC](https://community.hubspot.com/t/setting-unique-identifier-in-import-file/63405/5 "2022-09-02T13:31:52Z")

</div>

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