# how do I import?

**URL:** <https://community.hubspot.com/t/how-do-i-import/41830>\
**Category:** CRM\
**Tags:** free\
**Created:** [August 4, 2021, 9:45pm UTC](https://community.hubspot.com/t/how-do-i-import/41830 "2021-08-04T21:45:05Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![AGaulin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/agaulin/32/52876_2.png) [@AGaulin](https://community.hubspot.com/u/AGaulin)\
**Post date:** [August 4, 2021, 9:45pm UTC](https://community.hubspot.com/t/how-do-i-import/41830/1 "2021-08-04T21:45:05Z")

</div>

I am having trouble importing everything I need. Can someone please help describe what it is I am missing. I am getting these 3 error messages.

- **No unique identifier selected.**

We notice you didn’t use a unique identifier. For companies, HubSpot accepts **Company domain name** as the unique identifier. Without this, every row in your import file will be created as a new record.

-Some required properties are missing.

To complete your deal import, you need **Deal name** and **Pipeline** and **Deal stage** as HubSpot properties. Please review your property mappings below or review the columns in your file.

-Some required properties are missing.

To complete your company import, you need **Company domain name** or **Name** as a HubSpot property. Please review your property mappings below or review the columns in your file.

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [August 5, 2021, 3:44am UTC](https://community.hubspot.com/t/how-do-i-import/41830/2 "2021-08-05T03:44:44Z")

</div>

Hi @AGaulin,

Let’s go through these one by one.

**No unique identifier selected.** HubSpot deduplicates records based on certain criteria. For contacts it’s the email address or the contact ID, for companies it’s the company domain name (e.g. [acme.com](http://acme.com)) or the company ID. If HubSpot sees during an import that a company domain name already exists, it will not create a second version of it. It will update the existing file. Without a unique identifier, HubSpot can’t do that. That means that if you import the same file repeatedly, HubSpot would create the company record with the name “ACME” again and again and again, causing duplicates, since it doesn’t have a company domain name to go by. It’s generally recommended to have this company domain name. It’s also what [automatic association between contact and company](https://knowledge.hubspot.com/crm-setup/automatically-create-and-associate-companies-with-contacts) is based on.

**Some required properties are missing.** This is simple one: HubSpot needs a place where it can put your deals. In the free CRM there is only one deal pipeline but in bigger portals there might be multiple ones. HubSpot needs to now the destination where it should put those deals. In addition to knowing the pipeline, HubSpot also wants to know the pipeline stage. After all, not all these deals belong in the first pipeline stage. You can can learn more about your [pipeline and deal stages](https://knowledge.hubspot.com/deals/set-up-and-customize-your-deal-pipelines-and-deal-stages) here. To solve this, add two additional columns and add the name of the pipeline and the name of the deal stage.

**Some required properties are missing.** It looks like there are rows in your import file that have neither a company domain name (e.g. [acme.com](http://acme.com)) nor a name (ACME). HubSpot cannot create anything here, it’s like trying to create a file on your device without a name. You need to identify those rows in your file and add either the name or the company domain name.

Let me know if you have any follow-up questions!

---

<div class="post-metadata">

**Author:** ![AGaulin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/agaulin/32/52876_2.png) [@AGaulin](https://community.hubspot.com/u/AGaulin)\
**Post date:** [August 5, 2021, 8:20pm UTC](https://community.hubspot.com/t/how-do-i-import/41830/3 "2021-08-05T20:20:02Z")

</div>

Thank you for your help! This clarifies a lot.

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [August 6, 2021, 3:20am UTC](https://community.hubspot.com/t/how-do-i-import/41830/4 "2021-08-06T03:20:08Z")

</div>

Happy to help 🙂

---

<div class="post-metadata">

**Author:** ![NHaTrang](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/nhatrang/32/33328_2.png) [@NHaTrang](https://community.hubspot.com/u/NHaTrang)\
**Post date:** [October 14, 2021, 3:50pm UTC](https://community.hubspot.com/t/how-do-i-import/41830/5 "2021-10-14T15:50:07Z")

</div>

thanks, I am very satisfied with this answer

---

<div class="post-metadata">

**Author:** ![MYonova](https://avatars.discourse-cdn.com/v4/letter/m/eada6e/32.png) [@MYonova](https://community.hubspot.com/u/MYonova)\
**Post date:** [November 8, 2021, 1:26pm UTC](https://community.hubspot.com/t/how-do-i-import/41830/6 "2021-11-08T13:26:47Z")

</div>

Hi @karstenkoehler

Your answer really clarifies and helps a lot!

I just wanted to check the part regarding _companies_ - we would like to import data where in some cases _domain and name_ are the same (example: restaurant chain), but we do have UID and also different addresses for all these different locations.

How can we import such data? Is it possible to use the UID as an identifier?
