Retrieving All Picklist Property Options

[jleow]

There are times when you may want to export all property options for picklist-type properties such as checkboxes or dropdown menus. A common reason is to audit the options to remove duplicates or outdated values. 

At the moment, it isn’t possible directly export the values to an excel sheet or similar. However, we can use the forms tool as an intermediary to display all property values. Then, we can copy and paste these values into an excel sheet.  

1. In your HubSpot account, from the top menu, navigate to Marketing > Lead Capture > Forms.
2. In the top right, click Create form.
3. On the Choose your form type page, select the option for an Embedded form, then click Next. 
4. On the Select a Template page, select the option for a Blank Template, then click Start.  
5. In the left panel of the form editor, search for your [property name]. 
6. Click to drag and drop the property into the right panel of the form editor.
   
   

search for the property to retrieve options from

7. After adding the property as a new form field, hover over the field and click the pencil icon.

select the form field

8. In the left panel of the form editor, scroll down to the Field options section. 
9. At the bottom of the section, click See more.
   
   

view all property options by select "See more"

10. Click anywhere above the Field options section, then hold and drag to highlight all property options.
    
    

click and drag to highlight property options

11. Once all options are highlighted, you can copy and paste these values into an excel sheet or pages. 

format the data in excel

With this method, you may need to clean up the data and format your cells. But, it should provide you with a full list of property values to work with. 

Hope this helps!   

[ADeokinandan]

I've been looking for a workaround for so long - thank you for sharing and providing a detailed tutorial. 

[rfraser008]

@jleow Thanks so much for sharing this work around. Really helped me with a project I was working on. 

Best,

Rob

[Amy_Brierley]

Thank you @jleow but do you have a work around for Deal properties?

[jleow]

Hi @Amy_Brierley, there isn't a way to do so directly - instead, you can clone the deal property as a contact property.

1. From the property settings, hover over the property, and select clone.

2. In the right-side panel, when setting up your cloned property, change the object type to Contact.

After which, you can continue with the above steps. Hope this helps!   

[Amy_Brierley]

Thanks - a bit of a long winded way, would be so much easier if we could export directly!

[jeszhang]

Thanks for coming up with the workaround @jleow ! So helpful 🙂