# Retrieving All Picklist Property Options **URL:** \ **Category:** CRM\ **Tags:** workaround, free, how-to\ **Created:** [April 13, 2022, 6:58am UTC](https://community.hubspot.com/t/retrieving-all-picklist-property-options/54895 "2022-04-13T06:58:05Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![jleow](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jleow/32/16014_2.png) [@jleow](https://community.hubspot.com/u/jleow)\ **Post date:** [April 13, 2022, 6:58am UTC](https://community.hubspot.com/t/retrieving-all-picklist-property-options/54895/1 "2022-04-13T06:58:05Z")
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. ![jleow_0-1649831674868.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/1/4/142ba622987b18e57add3629947edeb1b39b8389.png) search for the property to retrieve options from 1. After adding the property as a new form field, hover over the field and click the **pencil icon**. ![jleow_1-1649831674870.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/7/f/7f8081aa7870494c75088b9bb1f7c1d8185d8b34.png) select the form field 1. In the left panel of the form editor, scroll down to the _Field options_ section. 2. At the bottom of the section, click **See more**. ![jleow_2-1649831674866.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/7/f/7fee8303f04fb0ce48fd181b6f0e5e23e8ede12f.png) view all property options by select “See more” 1. Click anywhere above the _Field options_ section, then hold and drag to highlight all property options. ![Community - click drag.gif](https://d2qpr2jzcazej7.cloudfront.net/original/2X/b/bea6d3e3f29630f54d722614fc5635880b820654.gif) click and drag to highlight property options 1. Once all options are highlighted, you can copy and paste these values into an excel sheet or pages. ![jleow_3-1649831674860.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/9/b/9b19665e904ba856f320cdbc8e3834fac769efd1.png) 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! ---
**Author:** ![jeszhang](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jeszhang/32/54568_2.png) [@jeszhang](https://community.hubspot.com/u/jeszhang)\ **Post date:** [April 13, 2022, 8:41am UTC](https://community.hubspot.com/t/retrieving-all-picklist-property-options/54895/2 "2022-04-13T08:41:28Z")
Thanks for coming up with the workaround @jleow ! So helpful 🙂 ---
**Author:** ![Amy\_Brierley](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/amy_brierley/32/91639_2.png) [@Amy\_Brierley](https://community.hubspot.com/u/Amy_Brierley)\ **Post date:** [June 14, 2022, 9:30am UTC](https://community.hubspot.com/t/retrieving-all-picklist-property-options/54895/3 "2022-06-14T09:30:52Z")
Thank you @jleow but do you have a work around for Deal properties? ---
**Author:** ![jleow](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jleow/32/16014_2.png) [@jleow](https://community.hubspot.com/u/jleow)\ **Post date:** [June 20, 2022, 8:19am UTC](https://community.hubspot.com/t/retrieving-all-picklist-property-options/54895/4 "2022-06-20T08:19:19Z")
Hi [@Amy\_Brierley](https://community.hubspot.com/t5/user/viewprofilepage/user-id/63434), there isn’t a way to do so directly - instead, you can [clone the deal property as a contact property](https://knowledge.hubspot.com/crm-setup/organize-and-export-properties#clone-archive-or-add-properties-to-a-group). 1. From the property settings, hover over the property, and select clone. ![jleow_0-1655712904956.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/3/33678755f4b86c65589d4f49c826ba34fb3d19c3.png) 2. In the right-side panel, when setting up your cloned property, change the object type to Contact. ![jleow_1-1655713096674.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/5/3/53903da3b63d25f509c79d98c66053dbaf394049.png) After which, you can continue with the above steps. Hope this helps! ---
**Author:** ![Amy\_Brierley](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/amy_brierley/32/91639_2.png) [@Amy\_Brierley](https://community.hubspot.com/u/Amy_Brierley)\ **Post date:** [June 20, 2022, 10:10am UTC](https://community.hubspot.com/t/retrieving-all-picklist-property-options/54895/5 "2022-06-20T10:10:24Z")
Thanks - a bit of a long winded way, would be so much easier if we could export directly! ---
**Author:** ![rfraser008](https://avatars.discourse-cdn.com/v4/letter/r/90ced4/32.png) [@rfraser008](https://community.hubspot.com/u/rfraser008)\ **Post date:** [May 18, 2023, 7:22pm UTC](https://community.hubspot.com/t/retrieving-all-picklist-property-options/54895/6 "2023-05-18T19:22:29Z")
@jleow Thanks so much for sharing this work around. Really helped me with a project I was working on. Best, Rob ---
**Author:** ![ADeokinandan](https://avatars.discourse-cdn.com/v4/letter/a/e47c2d/32.png) [@ADeokinandan](https://community.hubspot.com/u/ADeokinandan)\ **Post date:** [March 19, 2024, 8:42pm UTC](https://community.hubspot.com/t/retrieving-all-picklist-property-options/54895/7 "2024-03-19T20:42:54Z")
I’ve been looking for a workaround for so long - thank you for sharing and providing a detailed tutorial.