Exporting Property Labels

It would be useful to be able to export the property labels independently from the associated data. 

For example, we have created a country property that allows contacts to select from a drop-down menu, rather than enter free-form text - this requires over 200 labels.  In our system we have over 1,000,000  contacts with country information; therefore, in order to get the list of labels, I need to export the entire property history.  This results in a huge data file that takes a long time for HubSpot to produce and is too large for me to manipulate in Excel.

HubSpot updates
3 Replies
lizyork
Regular Contributor

We need to be able to export internal values as well. I know this is possible through the API but I am not a developer. Thanks!

Florencenoblet
New Contributor

We also need this feature! :-) 

Harry_Grant
New Member

I've got a solution for this. It requires a bit of work but these are the steps:

  1. Go to Settings (the wheel); then 'properties'; then 'contact properties';  scroll down to 'Country' and click on it.
  2. In your browser, search 'view source' and you will get a whole load of HTML code to sort through
  3. Go to the last link in the page - //static.hsappstatic.net/PropertySettingsUI/static-1.8526/js/App.js This is basically where they store all the country names (among other things)
  4. Search for {countryCodes: 
  5. This is your list. Copy it to the last country (Zambia). I then pasted this into Word.
  6. In Word, I did a find and replace, finding ',' and replacing with a special character 'manual line break'
  7. Then you can drop into excel or sheets and filter out the rubbish. 
  8. Your then left with a list like the below - note you will have periodically (maybe annually?) do the process again to update it:

Afghanistan
Albania
Antarctica
Ã…land Islands
Algeria
American Samoa
Andorra
Angola
Anguilla
Antigua and Barbuda
Aruba
Asia/Pacific Region
Azerbaijan
Argentina
Armenia
Australia
Austria
Bahamas
Bahrain
Bangladesh
Barbados
Belgium
Bhutan
Bolivia
Bosnia and Herzegovina
Botswana
Bouvet Island
Brazil
Caribbean Netherlands
Belize
Solomon Islands
Brunei
Bulgaria
Burundi
Belarus
Bermuda
Cambodia
Cayman Islands
Cameroon
Canada
Cape Verde
Central African Republic
Cuba
Curaçao
Sri Lanka
Chad
Chile
China
Christmas Island
Cocos (Keeling) Islands
Colombia
Comoros
Congo
Democratic Republic of the Congo
Cook Islands
Costa Rica
Croatia
Cyprus
Czech Republic
Benin
Denmark
Dominica
Dominican Republic
Ecuador
El Salvador
Equatorial Guinea
Ethiopia
Eritrea
Estonia
Europe
South Georgia and the South Sandwich Islands
Fiji
Finland
France
Falkland Islands
Faroe Islands
French Polynesia
French Southern and Antarctic Lands
Djibouti
Gabon
Georgia
Gambia
Germany
Ghana
Greenland
Guadeloupe
Guernsey
Kiribati
Greece
Grenada
Guam
Guatemala
Guinea
Guyana
French Guiana
Gibraltar
Haiti
Heard Island and McDonald Islands
Vatican City
Honduras
Hungary
Hong Kong
Isle of Man
Iran
Jersey
Macau
Martinique
Montserrat
Myanmar (Burma)
North Korea
Palestine
Puerto Rico
Réunion
Saint Barthélemy
Saint Martin
Sint Maarten
South Sudan
Sudan
Syria
Taiwan
Turks and Caicos Islands
U.S. Virgin Islands
Iceland
India
Indonesia
Iraq
Ireland
Israel
Italy
British Indian Ocean Territory
Cote d'Ivoire
Jamaica
Japan
Kazakhstan
Jordan
Kenya
South Korea
Kuwait
Kyrgyzstan
Laos
Lebanon
Lesotho
Latvia
Liberia
Libya
Liechtenstein
Lithuania
Luxembourg
Madagascar
Malawi
Malaysia
Maldives
Mali
Malta
Mauritania
Mauritius
Mayotte
Mexico
Monaco
Mongolia
Moldova
Montenegro
Morocco
Mozambique
Oman
Namibia
Nauru
Nepal
Netherlands
New Caledonia
Vanuatu
Netherlands Antilles
New Zealand
Nicaragua
Niger
Nigeria
Niue
Norfolk Island
Norway
Northern Mariana Islands
United States Minor Outlying Islands
Micronesia
Marshall Islands
Palau
Pakistan
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Pitcairn Islands
Poland
Portugal
Guinea-Bissau
East Timor
Qatar
Romania
Russia
Rwanda
Saint Helena
Saint Kitts and Nevis
Saint Lucia
Saint Pierre and Miquelon
Saint Vincent and the Grenadines
San Marino
Sao Tome and Principe
Saudi Arabia
Senegal
Svalbard and Jan Mayen
Serbia
Seychelles
Sierra Leone
Singapore
Slovakia
United Kingdom
Vietnam
Western Sahara
Slovenia
Somalia
South Africa
Zimbabwe
Spain
Suriname
Swaziland
Sweden
Switzerland
Tajikistan
Thailand
Togo
Tokelau
Tonga
Trinidad and Tobago
United Arab Emirates
Tunisia
Turkey
Turkmenistan
Tuvalu
Uganda
Ukraine
Macedonia (FYROM)
Egypt
United Kingdom
Tanzania
United States
Burkina Faso
Uruguay
Uzbekistan
Venezuela
British Virgin Islands
Wallis and Futuna
Samoa
Yemen
Zambia