HubSpot Ideas

annemarien

Export a single property's sub-values (e.g. dropdowns, checkboxes)

We've conducted an internal review of properties and one of the needs was to see the values in dropdowns/checkboxes, and the only way was to manually copy out the values. Would be useful to be able to export them instead.

 

Also do you need an idea category of "properties"? I can't find the best category for this idea.

77 Replies
HSalvo1
Member

Would love to see this functionality implemented ASAP! 

Thomas_Vanguard
Participant | Platinum Partner

Bumping this one as we seem to need to review the industry property every other month with clients and it gets very tedious manually exporting the current values.

AMurray_CH
Participant

This would be very useful - our use case is maintaining property consistency when setting up lead forms in third party platforms (e.g. Meta Ads).

SSabio
Participant

Sorely needed in the process of optimizing and updating out-dated client portals.

noahmckeon
Top Contributor | Elite Partner

There's a bit of an odd solution to this issue using our app MigrateMyCRM, for those who are interested...

This feature - to be able to export values in a picklist - exists within our mapping feature, which you can use without needing to run a migration. Simply connect to HubSpot as your source, and select Excel or CSV as your target. Then, just continue through the steps until you land on the Mapping screen.

From here, find the object you're looking for (Companies, Contacts, etc.), find your field, then click the Control/CTRL key, and you'll notice that the picklist fields become underlined. One of the icons next to the field name will also switch to a CSV icon. Click on the icon while the field is underlined, and it will download a file with all of your picklist options for that field.

 

Screenshot 2024-10-03 at 9.33.34 PM.png

 

Hope this helps!

Peter__Jones
Participant | Diamond Partner

Needed!

CCeustermans
Member

@noahmckeon  thanks for the tip - i've tried it though, but no CSV download option available for my industry field. Maybe it's because I am on a free version? 🙃 

noahmckeon
Top Contributor | Elite Partner

@CCeustermans Nope, it works on the free version, too! Want to send me your migration ID? I can grab it and send it over to you (and I'll record a Loom too, if that's helpful!)

SGeorge41
Member

its been 2 years and still nothing,  its a standard requirement to export most lists,  the backend seems very old fashioned>

 

i have managed a work around for now but some manual work done.  you need to extract using a formula ot text to columns

 
[{"label":"Accounting","value":"ACCOUNTING","displayOrder":0,"hidden":false,"readOnly":true},{"label":"Airlines/Aviation","value":"AIRLINES_AVIATION","displayOrder":1,"hidden":false,"readOnly":true},{"label":"Alternative Dispute Resolution","value":"ALTERNATIVE_DISPUTE_RESOLUTION","displayOrder":2,"hidden":false,"readOnly":true},{"label":"Alternative Medicine","value":"ALTERNATIVE_MEDICINE","displayOrder":3,"hidden":false,"readOnly":true},{"label":"Animation","value":"ANIMATION","displayOrder":4,"hidden":false,"readOnly":true},{"label":"Apparel & Fashion","value":"APPAREL_FASHION","displayOrder":5,"hidden":false,"readOnly":true},{"label":"Architecture & Planning","value":"ARCHITECTURE_PLANNING","displayOrder":6,"hidden":false,"readOnly":true},{"label":"Arts and Crafts","value":"ARTS_AND_CRAFTS","displayOrder":7,"hidden":false,"readOnly":true},{"label":"Automotive","value":"AUTOMOTIVE","displayOrder":8,"hidden":false,"readOnly":true},{"label":"Aviation & Aerospace","value":"AVIATION_AEROSPACE","displayOrder":9,"hidden":false,"readOnly":true},{"label":"Banking","value":"BANKING","displayOrder":10,"hidden":false,"readOnly":true},{"label":"Biotechnology","value":"BIOTECHNOLOGY","displayOrder":11,"hidden":false,"readOnly":true},{"label":"Broadcast Media","value":"BROADCAST_MEDIA","displayOrder":12,"hidden":false,"readOnly":true},{"label":"Building Materials","value":"BUILDING_MATERIALS","displayOrder":13,"hidden":false,"readOnly":true},{"label":"Business Supplies and Equipment","value":"BUSINESS_SUPPLIES_AND_EQUIPMENT","displayOrder":14,"hidden":false,"readOnly":true},{"label":"Capital Markets","value":"CAPITAL_MARKETS","displayOrder":15,"hidden":false,"readOnly":true},{"label":"Chemicals","value":"CHEMICALS","displayOrder":16,"hidden":false,"readOnly":true},{"label":"Civic & Social Organization","value":"CIVIC_SOCIAL_ORGANIZATION","displayOrder":17,"hidden":false,"readOnly":true},{"label":"Civil Engineering","value":"CIVIL_ENGINEERING","displayOrder":18,"hidden":false,"readOnly":true},{"label":"Commercial Real Estate","value":"COMMERCIAL_REAL_ESTATE","displayOrder":19,"hidden":false,"readOnly":true},{"label":"Computer & Network Security","value":"COMPUTER_NETWORK_SECURITY","displayOrder":20,"hidden":false,"readOnly":true},{"label":"Computer Games","value":"COMPUTER_GAMES","displayOrder":21,"hidden":false,"readOnly":true},{"label":"Computer Hardware","value":"COMPUTER_HARDWARE","displayOrder":22,"hidden":false,"readOnly":true},{"label":"Computer Networking","value":"COMPUTER_NETWORKING","displayOrder":23,"hidden":false,"readOnly":true},{"label":"Computer Software","value":"COMPUTER_SOFTWARE","displayOrder":24,"hidden":false,"readOnly":true},{"label":"Internet","value":"INTERNET","displayOrder":25,"hidden":false,"readOnly":true},{"label":"Construction","value":"CONSTRUCTION","displayOrder":26,"hidden":false,"readOnly":true},{"label":"Consumer Electronics","value":"CONSUMER_ELECTRONICS","displayOrder":27,"hidden":false,"readOnly":true},{"label":"Consumer Goods","value":"CONSUMER_GOODS","displayOrder":28,"hidden":false,"readOnly":true},{"label":"Consumer Services","value":"CONSUMER_SERVICES","displayOrder":29,"hidden":false,"readOnly":true},{"label":"Cosmetics","value":"COSMETICS","displayOrder":30,"hidden":false,"readOnly":true},{"label":"Dairy","value":"DAIRY","displayOrder":31,"hidden":false,"readOnly":true},{"label":"Defense & Space","value":"DEFENSE_SPACE","displayOrder":32,"hidden":false,"readOnly":true},{"label":"Design","value":"DESIGN","displayOrder":33,"hidden":false,"readOnly":true},{"label":"Education Management","value":"EDUCATION_MANAGEMENT","displayOrder":34,"hidden":false,"readOnly":true},{"label":"E-Learning","value":"E_LEARNING","displayOrder":35,"hidden":false,"readOnly":true},{"label":"Electrical/Electronic Manufacturing","value":"ELECTRICAL_ELECTRONIC_MANUFACTURING","displayOrder":36,"hidden":false,"readOnly":true},{"label":"Entertainment","value":"ENTERTAINMENT","displayOrder":37,"hidden":false,"readOnly":true},{"label":"Environmental Services","value":"ENVIRONMENTAL_SERVICES","displayOrder":38,"hidden":false,"readOnly":true},{"label":"Events Services","value":"EVENTS_SERVICES","displayOrder":39,"hidden":false,"readOnly":true},{"label":"Executive Office","value":"EXECUTIVE_OFFICE","displayOrder":40,"hidden":false,"readOnly":true},{"label":"Facilities Services","value":"FACILITIES_SERVICES","displayOrder":41,"hidden":false,"readOnly":true},{"label":"Farming","value":"FARMING","displayOrder":42,"hidden":false,"readOnly":true},{"label":"Financial Services","value":"FINANCIAL_SERVICES","displayOrder":43,"hidden":false,"readOnly":true},{"label":"Fine Art","value":"FINE_ART","displayOrder":44,"hidden":false,"readOnly":true},{"label":"Fishery","value":"FISHERY","displayOrder":45,"hidden":false,"readOnly":true},{"label":"Food & Beverages","value":"FOOD_BEVERAGES","displayOrder":46,"hidden":false,"readOnly":true},{"label":"Food Production","value":"FOOD_PRODUCTION","displayOrder":47,"hidden":false,"readOnly":true},{"label":"Fund-Raising","value":"FUND_RAISING","displayOrder":48,"hidden":false,"readOnly":true},{"label":"Furniture","value":"FURNITURE","displayOrder":49,"hidden":false,"readOnly":true},{"label":"Gambling & Casinos","value":"GAMBLING_CASINOS","displayOrder":50,"hidden":false,"readOnly":true},{"label":"Glass, Ceramics & Concrete","value":"GLASS_CERAMICS_CONCRETE","displayOrder":51,"hidden":false,"readOnly":true},{"label":"Government Administration","value":"GOVERNMENT_ADMINISTRATION","displayOrder":52,"hidden":false,"readOnly":true},{"label":"Government Relations","value":"GOVERNMENT_RELATIONS","displayOrder":53,"hidden":false,"readOnly":true},{"label":"Graphic Design","value":"GRAPHIC_DESIGN","displayOrder":54,"hidden":false,"readOnly":true},{"label":"Health, Wellness and Fitness","value":"HEALTH_WELLNESS_AND_FITNESS","displayOrder":55,"hidden":false,"readOnly":true},{"label":"Higher Education","value":"HIGHER_EDUCATION","displayOrder":56,"hidden":false,"readOnly":true},{"label":"Hospital & Health Care","value":"HOSPITAL_HEALTH_CARE","displayOrder":57,"hidden":false,"readOnly":true},{"label":"Hospitality","value":"HOSPITALITY","displayOrder":58,"hidden":false,"readOnly":true},{"label":"Human Resources","value":"HUMAN_RESOURCES","displayOrder":59,"hidden":false,"readOnly":true},{"label":"Import and Export","value":"IMPORT_AND_EXPORT","displayOrder":60,"hidden":false,"readOnly":true},{"label":"Individual & Family Services","value":"INDIVIDUAL_FAMILY_SERVICES","displayOrder":61,"hidden":false,"readOnly":true},{"label":"Industrial Automation","value":"INDUSTRIAL_AUTOMATION","displayOrder":62,"hidden":false,"readOnly":true},{"label":"Information Services","value":"INFORMATION_SERVICES","displayOrder":63,"hidden":false,"readOnly":true},{"label":"Information Technology and Services","value":"INFORMATION_TECHNOLOGY_AND_SERVICES","displayOrder":64,"hidden":false,"readOnly":true},{"label":"Insurance","value":"INSURANCE","displayOrder":65,"hidden":false,"readOnly":true},{"label":"International Affairs","value":"INTERNATIONAL_AFFAIRS","displayOrder":66,"hidden":false,"readOnly":true},{"label":"International Trade and Development","value":"INTERNATIONAL_TRADE_AND_DEVELOPMENT","displayOrder":67,"hidden":false,"readOnly":true},{"label":"Investment Banking","value":"INVESTMENT_BANKING","displayOrder":68,"hidden":false,"readOnly":true},{"label":"Investment Management","value":"INVESTMENT_MANAGEMENT","displayOrder":69,"hidden":false,"readOnly":true},{"label":"Judiciary","value":"JUDICIARY","displayOrder":70,"hidden":false,"readOnly":true},{"label":"Law Enforcement","value":"LAW_ENFORCEMENT","displayOrder":71,"hidden":false,"readOnly":true},{"label":"Law Practice","value":"LAW_PRACTICE","displayOrder":72,"hidden":false,"readOnly":true},{"label":"Legal Services","value":"LEGAL_SERVICES","displayOrder":73,"hidden":false,"readOnly":true},{"label":"Legislative Office","value":"LEGISLATIVE_OFFICE","displayOrder":74,"hidden":false,"readOnly":true},{"label":"Leisure, Travel & Tourism","value":"LEISURE_TRAVEL_TOURISM","displayOrder":75,"hidden":false,"readOnly":true},{"label":"Libraries","value":"LIBRARIES","displayOrder":76,"hidden":false,"readOnly":true},{"label":"Logistics and Supply Chain","value":"LOGISTICS_AND_SUPPLY_CHAIN","displayOrder":77,"hidden":false,"readOnly":true},{"label":"Luxury Goods & Jewelry","value":"LUXURY_GOODS_JEWELRY","displayOrder":78,"hidden":false,"readOnly":true},{"label":"Machinery","value":"MACHINERY","displayOrder":79,"hidden":false,"readOnly":true},{"label":"Management Consulting","value":"MANAGEMENT_CONSULTING","displayOrder":80,"hidden":false,"readOnly":true},{"label":"Maritime","value":"MARITIME","displayOrder":81,"hidden":false,"readOnly":true},{"label":"Market Research","value":"MARKET_RESEARCH","displayOrder":82,"hidden":false,"readOnly":true},{"label":"Marketing and Advertising","value":"MARKETING_AND_ADVERTISING","displayOrder":83,"hidden":false,"readOnly":true},{"label":"Mechanical or Industrial Engineering","value":"MECHANICAL_OR_INDUSTRIAL_ENGINEERING","displayOrder":84,"hidden":false,"readOnly":true},{"label":"Media Production","value":"MEDIA_PRODUCTION","displayOrder":85,"hidden":false,"readOnly":true},{"label":"Medical Devices","value":"MEDICAL_DEVICES","displayOrder":86,"hidden":false,"readOnly":true},{"label":"Medical Practice","value":"MEDICAL_PRACTICE","displayOrder":87,"hidden":false,"readOnly":true},{"label":"Mental Health Care","value":"MENTAL_HEALTH_CARE","displayOrder":88,"hidden":false,"readOnly":true},{"label":"Military","value":"MILITARY","displayOrder":89,"hidden":false,"readOnly":true},{"label":"Mining & Metals","value":"MINING_METALS","displayOrder":90,"hidden":false,"readOnly":true},{"label":"Motion Pictures and Film","value":"MOTION_PICTURES_AND_FILM","displayOrder":91,"hidden":false,"readOnly":true},{"label":"Museums and Institutions","value":"MUSEUMS_AND_INSTITUTIONS","displayOrder":92,"hidden":false,"readOnly":true},{"label":"Music","value":"MUSIC","displayOrder":93,"hidden":false,"readOnly":true},{"label":"Nanotechnology","value":"NANOTECHNOLOGY","displayOrder":94,"hidden":false,"readOnly":true},{"label":"Newspapers","value":"NEWSPAPERS","displayOrder":95,"hidden":false,"readOnly":true},{"label":"Non-Profit Organization Management","value":"NON_PROFIT_ORGANIZATION_MANAGEMENT","displayOrder":96,"hidden":false,"readOnly":true},{"label":"Oil & Energy","value":"OIL_ENERGY","displayOrder":97,"hidden":false,"readOnly":true},{"label":"Online Media","value":"ONLINE_MEDIA","displayOrder":98,"hidden":false,"readOnly":true},{"label":"Outsourcing/Offshoring","value":"OUTSOURCING_OFFSHORING","displayOrder":99,"hidden":false,"readOnly":true},{"label":"Package/Freight Delivery","value":"PACKAGE_FREIGHT_DELIVERY","displayOrder":100,"hidden":false,"readOnly":true},{"label":"Packaging and Containers","value":"PACKAGING_AND_CONTAINERS","displayOrder":101,"hidden":false,"readOnly":true},{"label":"Paper & Forest Products","value":"PAPER_FOREST_PRODUCTS","displayOrder":102,"hidden":false,"readOnly":true},{"label":"Performing Arts","value":"PERFORMING_ARTS","displayOrder":103,"hidden":false,"readOnly":true},{"label":"Pharmaceuticals","value":"PHARMACEUTICALS","displayOrder":104,"hidden":false,"readOnly":true},{"label":"Philanthropy","value":"PHILANTHROPY","displayOrder":105,"hidden":false,"readOnly":true},{"label":"Photography","value":"PHOTOGRAPHY","displayOrder":106,"hidden":false,"readOnly":true},{"label":"Plastics","value":"PLASTICS","displayOrder":107,"hidden":false,"readOnly":true},{"label":"Political Organization","value":"POLITICAL_ORGANIZATION","displayOrder":108,"hidden":false,"readOnly":true},{"label":"Primary/Secondary Education","value":"PRIMARY_SECONDARY_EDUCATION","displayOrder":109,"hidden":false,"readOnly":true},{"label":"Printing","value":"PRINTING","displayOrder":110,"hidden":false,"readOnly":true},{"label":"Professional Training & Coaching","value":"PROFESSIONAL_TRAINING_COACHING","displayOrder":111,"hidden":false,"readOnly":true},{"label":"Program Development","value":"PROGRAM_DEVELOPMENT","displayOrder":112,"hidden":false,"readOnly":true},{"label":"Public Policy","value":"PUBLIC_POLICY","displayOrder":113,"hidden":false,"readOnly":true},{"label":"Public Relations and Communications","value":"PUBLIC_RELATIONS_AND_COMMUNICATIONS","displayOrder":114,"hidden":false,"readOnly":true},{"label":"Public Safety","value":"PUBLIC_SAFETY","displayOrder":115,"hidden":false,"readOnly":true},{"label":"Publishing","value":"PUBLISHING","displayOrder":116,"hidden":false,"readOnly":true},{"label":"Railroad Manufacture","value":"RAILROAD_MANUFACTURE","displayOrder":117,"hidden":false,"readOnly":true},{"label":"Ranching","value":"RANCHING","displayOrder":118,"hidden":false,"readOnly":true},{"label":"Real Estate","value":"REAL_ESTATE","displayOrder":119,"hidden":false,"readOnly":true},{"label":"Recreational Facilities and Services","value":"RECREATIONAL_FACILITIES_AND_SERVICES","displayOrder":120,"hidden":false,"readOnly":true},{"label":"Religious Institutions","value":"RELIGIOUS_INSTITUTIONS","displayOrder":121,"hidden":false,"readOnly":true},{"label":"Renewables & Environment","value":"RENEWABLES_ENVIRONMENT","displayOrder":122,"hidden":false,"readOnly":true},{"label":"Research","value":"RESEARCH","displayOrder":123,"hidden":false,"readOnly":true},{"label":"Restaurants","value":"RESTAURANTS","displayOrder":124,"hidden":false,"readOnly":true},{"label":"Retail","value":"RETAIL","displayOrder":125,"hidden":false,"readOnly":true},{"label":"Security and Investigations","value":"SECURITY_AND_INVESTIGATIONS","displayOrder":126,"hidden":false,"readOnly":true},{"label":"Semiconductors","value":"SEMICONDUCTORS","displayOrder":127,"hidden":false,"readOnly":true},{"label":"Shipbuilding","value":"SHIPBUILDING","displayOrder":128,"hidden":false,"readOnly":true},{"label":"Sporting Goods","value":"SPORTING_GOODS","displayOrder":129,"hidden":false,"readOnly":true},{"label":"Sports","value":"SPORTS","displayOrder":130,"hidden":false,"readOnly":true},{"label":"Staffing and Recruiting","value":"STAFFING_AND_RECRUITING","displayOrder":131,"hidden":false,"readOnly":true},{"label":"Supermarkets","value":"SUPERMARKETS","displayOrder":132,"hidden":false,"readOnly":true},{"label":"Telecommunications","value":"TELECOMMUNICATIONS","displayOrder":133,"hidden":false,"readOnly":true},{"label":"Textiles","value":"TEXTILES","displayOrder":134,"hidden":false,"readOnly":true},{"label":"Think Tanks","value":"THINK_TANKS","displayOrder":135,"hidden":false,"readOnly":true},{"label":"Tobacco","value":"TOBACCO","displayOrder":136,"hidden":false,"readOnly":true},{"label":"Translation and Localization","value":"TRANSLATION_AND_LOCALIZATION","displayOrder":137,"hidden":false,"readOnly":true},{"label":"Transportation/Trucking/Railroad","value":"TRANSPORTATION_TRUCKING_RAILROAD","displayOrder":138,"hidden":false,"readOnly":true},{"label":"Utilities","value":"UTILITIES","displayOrder":139,"hidden":false,"readOnly":true},{"label":"Venture Capital & Private Equity","value":"VENTURE_CAPITAL_PRIVATE_EQUITY","displayOrder":140,"hidden":false,"readOnly":true},{"label":"Veterinary","value":"VETERINARY","displayOrder":141,"hidden":false,"readOnly":true},{"label":"Warehousing","value":"WAREHOUSING","displayOrder":142,"hidden":false,"readOnly":true},{"label":"Wholesale","value":"WHOLESALE","displayOrder":143,"hidden":false,"readOnly":true},{"label":"Wine and Spirits","value":"WINE_AND_SPIRITS","displayOrder":144,"hidden":false,"readOnly":true},{"label":"Wireless","value":"WIRELESS","displayOrder":145,"hidden":false,"readOnly":true},{"label":"Writing and Editing","value":"WRITING_AND_EDITING","displayOrder":146,"hidden":false,"readOnly":true},{"label":"Mobile Games","value":"MOBILE_GAMES","displayOrder":147,"hidden":false,"readOnly":false}]

 

 

KMace3
Participant

I need to do an audit with another team of a property that has 40+ dropdown options. I would love to be able to export the options to help with this. 

ARedman
Member

Is this what you are looking for? It exports all the properties, but not too hard to find the ones you want...
https://knowledge.hubspot.com/properties/organize-and-export-properties#export-all-properties

ARedman
Member

Is this what you're looking for? I managed to download all the properties. It's ALL properties, not just Contact or one's you select, but then you can at least filter them in Excel to get what you want fairly quickly. I found it quite helpful to be able to see everything avaiable.https://knowledge.hubspot.com/properties/organize-and-export-properties#export-all-properties

noahmckeon
Top Contributor | Elite Partner

@KMace3 You can export the dropdown options for free using MigrateMyCRM (without performing a migration). Register for an account at migratemycrm.syncmatters.com, then connect HubSpot as your source system and 'CSV' as your target:

screely-1733793917717.png

 

Then, click on 'Next: Select objects' under Customize Your Migration:

screely-1733793937991.png

 

Next, select the object(s) where the needed dropdown fields are and click Next again. This will take you to the mapping.

 

screely-1733794190787.png

 

Lastly, find the field you're looking for, then click and hold the Command key to show the CSV icon next to the needed field. Click the CSV icon to download a field of the picklist values for that field.

See the Industry field before holding the Command key, then after holding the Command key:

See the Industry field before holding the Command keySee the Industry field before holding the Command keyAnd after holding the Command keyAnd after holding the Command key

 

The result:

Screenshot 2024-12-09 at 5.34.01 PM.png

 

Hope this helps!

KMace3
Participant

This worked! To your point I'd like to export the options for an individual property in a better format because now I have to clean up the file, but this does get me what I need. 

DMeyerWI
Participant

Is this available yet? 

cecilia-thespot
Participant

Hi all, hope this can help someone.

 

You can export all of your properties from the Properties table in Settings and you'll get a spreadsheet that will leave you with a column that will pack all of the dropdown (etc) values into one cell. It will look something like this:

[{"label":"Freshman","value":"Freshman","displayOrder":0,"hidden":false,"readOnly":false},{"label":"Sophomore","value":"Sophomore","displayOrder":1,"hidden":false,"readOnly":false},{"label":"Junior","value":"Junior","displayOrder":2,"hidden":false,"readOnly":false},{"label":"Senior","value":"Senior","displayOrder":3,"hidden":false,"readOnly":false},{"label":"Graduated","value":"Graduated","displayOrder":4,"hidden":false,"readOnly":false}

 

With a little finesse in Excel, using this formula in a blank column of cells, you can pick out the dropdown values:

=TEXTJOIN(", ",1,TOCOL(TEXTAFTER(TEXTSPLIT(A1,""","""),"""label"":"""),2))

 

Paste into the top of a column and drag it all the way down. After this, I will typically create ANOTHER blank column, copy the formula row with cleaned values that I just created and then paste "values" into the new blank column. Now you can remove your "formula" column and the original ugly values text column and just have one left with your cleaned up values. 

*Note you have to paste "Values," otherwise, you will just copy the forumla again and when you remove the original ugly values text column, it will "break" your formula and you won't have any values. 

It would be grrrrreeeeat if HubSpot allowed us to format the exports ahead of time, or just made the default export a little more wieldy, but until this, this has saved me HOURS of copying and pasting.

(Shout out to the kind person on Reddit who helped me with this Excel formula, because I am no pro.)

Aaskarovo
Member

I join the request.

This should be a basic functionality without the need to use external tools.