# Issues importing current client companies database CSV

**URL:** <https://community.hubspot.com/t/issues-importing-current-client-companies-database-csv/3601>\
**Category:** Lists, Lead Scoring & Workflows\
**Created:** [October 18, 2017, 10:23am UTC](https://community.hubspot.com/t/issues-importing-current-client-companies-database-csv/3601 "2017-10-18T10:23:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\
**Post date:** [October 18, 2017, 10:23am UTC](https://community.hubspot.com/t/issues-importing-current-client-companies-database-csv/3601/1 "2017-10-18T10:23:54Z")

</div>

I am having issues importing a text column on my csv file of companies and can’t seem to find a solution.

**The headers I have are:**  
Name: text field  
Email: text field  
Work phone: number field  
Project name: text field  
Project type: text field  
Project number: number field  
Type of customer: text field  
Lead status: text field  
Tags: text field  
Work website: text field  
Facebook: text field  
Twitter: text field  
Linkedin: text field  
The issue I am having is with importing the “Tags” column which I renamed during the import process as “Industry”.  
The tag options for our companies are Architect, Developer, Real Estate, Design Agency etc.  
For some reason only the companies tagged “Real Estate” have carried over. I thought maybe this could be an issue with Hubspot not being able to pickup the tags when there are more than one in the field, e.g “Architect, Developer”, however it won’t even pick up “Architect” on its own.  
What is also odd is it seems to have added an industry tag of its own - “Education Management” which doesn’t appear on our csv file anywhere!  
Any help would be much appreciated as we were almost certain we were changing over to Hubspot however this is going to be a massive issue for us.

---

<div class="post-metadata">

**Author:** ![Jenny](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jenny/32/24_2.png) [@Jenny](https://community.hubspot.com/u/Jenny)\
**Post date:** [October 31, 2017, 6:37pm UTC](https://community.hubspot.com/t/issues-importing-current-client-companies-database-csv/3601/2 "2017-10-31T18:37:57Z")

</div>

Hi [@Rockhunter](https://community.hubspot.com/t5/user/viewprofilepage/user-id/19240),

If you look at the industry company property in your portal (settings\>properties\>company) you’ll see that there are already options associated with that property that HubSpot has created (as it is a default Company property). What this means is that during the import process, HubSpot is going to map to the industries that are created as property options. If you want to add additional options to the industry field, you will need to create the options you want to map to (architect, etc.) before you do the import so that HubSpot can successfully map to them. In other words, property options cannot be added through an import, they need to exist already so that the import can map to them.

I would recommend adding the options you’re looking to map to and then trying the import again.

Additionally, if you don’t want to use the options HubSpot has, I would recommend making a new company property to house the informaiton you’re looking to import.

Thank you,  
Jenny