topic Re: Export country property dropdown list in Dashboards & Reporting

Export country property dropdown list

amesserman — Wed, 14 Oct 2020 22:58:30 GMT

I have an integration field mapping project and need to export the options for a dropdown select field for Country/Region. I could go one by one... but there are over 300 rows of data and I can't be the only person looking for this solution. There has to be an easy way to do this, no??

Here is what I've tried already:

I selected the list from "edit property" and tried to copy/paste into excel using the keep source formatting (pasted as html boxes, can't manipulate text) and match destination formatting (label and internal value fields don't paste because they aren't recognized as text). Paste special allows me to paste as text, but I lose the columns and every part of the row pastes as a new line.
Tried to "export all properties" in the property settings page, but that only gave me the list of properties - not their dropdown/list options

Re: Export country property dropdown list

TitiCuisset — Thu, 15 Oct 2020 09:25:31 GMT

Hi @amesserman,

Thank you for reaching out and welcome to the Community!

This is not something possible in HubSpot at this stage, but I invite you to upvote this Idea I found in our Ideas Forum. It is the main platform for communicating feature requests to our Product Team.

I also want to share with you this API that could help you achieve this goal - please keep this mind that you would need the help of a developer for this.

Hope that helps.
Have a lovely day,
Tiphaine.

Re: Export country property dropdown list

SComeau — Thu, 28 Oct 2021 18:08:18 GMT

For training purposes I NEED the ability to export all drop down options for each property. PLEASE let us have the ability to do that.

Re: Export country property dropdown list

JonnyKatz — Sun, 20 Feb 2022 14:25:41 GMT

I used this endpoint /crm/v3/properties/{objectType}/{propertyName} on https://developers.hubspot.com/docs/api/crm/properties

Exported it to excel and used text to columns. This is a workaround for now...

Re: Export country property dropdown list

Racecheck — Thu, 08 Dec 2022 15:24:40 GMT

This would be really useful—having the ability to easily export any dropdown list created in HubSpot.

Re: Export country property dropdown list

SarahOps — Fri, 02 Feb 2024 14:04:23 GMT

Hi - looking to export property options to Excel. Is this still the only option?

Re: Export country property dropdown list

PamCotton — Thu, 08 Feb 2024 15:09:54 GMT

Hey @EugenieB, Users with Export permissions can export a list of all properties across all of your account’s objects. The exported file will contain basic information including each property’s name, internal name, type, description, group, and if applicable, its options. To view property values instead, you can export an individual property’s history or view historical data for a property on a record.

More information here

Kindly,

Pam