# Export a single property's sub-values (e.g. dropdowns, checkboxes) **URL:** \ **Category:** HubSpot Ideas\ **Tags:** account-settings\ **Created:** [August 26, 2020, 11:29am UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647 "2020-08-26T11:29:33Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Vivi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/vivi/32/78108_2.png) [@Vivi](https://community.hubspot.com/u/Vivi)\ **Post date:** [January 14, 2022, 10:44am UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/21 "2022-01-14T10:44:26Z")
It will be so helpful to export the properties. ---
**Author:** ![Andrea\_MSC](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/andrea_msc/32/27794_2.png) [@Andrea\_MSC](https://community.hubspot.com/u/Andrea_MSC)\ **Post date:** [January 14, 2022, 4:39pm UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/22 "2022-01-14T16:39:50Z")
This is definitely needed. I spent days going through support since I have a dropdown of over 1,000 options. When exporting it doesn’t export all of it, and it is all in one cell! There needs to be a way to export the dropdown options, especially when there’s so many! ---
**Author:** ![JonnyKatz](https://avatars.discourse-cdn.com/v4/letter/j/7993a0/32.png) [@JonnyKatz](https://community.hubspot.com/u/JonnyKatz)\ **Post date:** [February 20, 2022, 2:43pm UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/23 "2022-02-20T14:43:23Z")
Hi I used the HubSpot api endpoint as a workaround, then cleaned up the response in excel using text to columns. [Accounts Dashboard | HubSpot](https://developers.hubspot.com/docs/api/crm/properties) use this endpoint/crm/v3/properties/{objectType}/{propertyName}. I was looking for the industry picklist values. ![JonnyKatz_0-1645367065021.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/9/39ac211cbdc8907155be99f0469c2adff0f84154.png) ---
**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, 7:22am UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/24 "2022-04-13T07:22:40Z")
Hi everyone! @jeszhang and I were looking into this roadblock. As a workaround, we can add the property to a form as a form field. In the form field editor, we can then display all property values. Finally, we can copy and paste these values into an excel sheet or similar. [Here’s a step-by-step guide on how to do so, hope this helps!](https://community.hubspot.com/t5/CRM/Retrieving-All-Picklist-Property-Options/m-p/613972/) ---
**Author:** ![LROADY](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lroady/32/81109_2.png) [@LROADY](https://community.hubspot.com/u/LROADY)\ **Post date:** [May 4, 2022, 11:19pm UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/25 "2022-05-04T23:19:26Z")
This isnt resolved yet?!?!? help please ---
**Author:** ![alexluong1](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/alexluong1/32/22074_2.png) [@alexluong1](https://community.hubspot.com/u/alexluong1)\ **Post date:** [June 8, 2022, 11:46pm UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/26 "2022-06-08T23:46:43Z")
Upvoted, agreed. It would be great to have a button to export options as a csv. There’s already options to paste in your own, and load from other properties. So this is the missing link! ---
**Author:** ![GScaglia](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gscaglia/32/81428_2.png) [@GScaglia](https://community.hubspot.com/u/GScaglia)\ **Post date:** [June 15, 2022, 2:39pm UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/27 "2022-06-15T14:39:25Z")
Hey there 👋 I found an easy workaround, it’s not very clean but it works ! 1. Create a new “Multiple Checkboxes” property (temporary) 2. Load the options of this new property with the values of the property you want to extract the data from 3. Add the newly created property to a new form (temporary) 4. Publish the form and use the preview page 5. Then select all the values of the checkbox property and paste that into your excel file 🎉 6. Delete the checkbox property and the form Hope this will help some of you. Cheers ! ---
**Author:** ![DomJam](https://avatars.discourse-cdn.com/v4/letter/d/58f4c7/32.png) [@DomJam](https://community.hubspot.com/u/DomJam)\ **Post date:** [July 19, 2022, 11:55am UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/28 "2022-07-19T11:55:00Z")
Hi, our company would appreciate this function. It will save our time and nerves 🙂 ---
**Author:** ![BSong](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/bsong/32/82945_2.png) [@BSong](https://community.hubspot.com/u/BSong)\ **Post date:** [September 21, 2022, 4:06am UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/29 "2022-09-21T04:06:32Z")
Agreed on this! If we could see properties sub-options and the number of values each has when exporting “all properties” it gives us as users better insights to this and a holistic view of our data ---
**Author:** ![JIbarra3](https://avatars.discourse-cdn.com/v4/letter/j/cab0a1/32.png) [@JIbarra3](https://community.hubspot.com/u/JIbarra3)\ **Post date:** [December 6, 2022, 7:23pm UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/30 "2022-12-06T19:23:13Z")
Any update on this? Would love to be able to implement this asap. ---
**Author:** ![JDoherty1](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@JDoherty1](https://community.hubspot.com/u/JDoherty1)\ **Post date:** [January 23, 2023, 5:32pm UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/31 "2023-01-23T17:32:12Z")
Just asked support about this today, the funcationality still doesnt’ exist ---
**Author:** ![FilipBackstrom](https://avatars.discourse-cdn.com/v4/letter/f/48db29/32.png) [@FilipBackstrom](https://community.hubspot.com/u/FilipBackstrom)\ **Post date:** [February 16, 2023, 3:33pm UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/32 "2023-02-16T15:33:39Z")
We need to update the values of a property that consists of 2098 options. If I paste the list of updated values it recognizes 2098 of them as already existing so I will have to clear every duplicate/already existing value in order to make it work. If I just could export the values then I could filter the list of duplicates and only paste the new values. ---
**Author:** ![Daveanas](https://avatars.discourse-cdn.com/v4/letter/d/ba8739/32.png) [@Daveanas](https://community.hubspot.com/u/Daveanas)\ **Post date:** [March 22, 2023, 1:02am UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/33 "2023-03-22T01:02:06Z")
May I know if there is a new update on this request? An option to import and export would be great. ---
**Author:** ![Sharjeel2023](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@Sharjeel2023](https://community.hubspot.com/u/Sharjeel2023)\ **Post date:** [April 13, 2023, 3:03pm UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/34 "2023-04-13T15:03:04Z")
It’s absurd that there’s still no way to export a list of values for a property. ---
**Author:** ![LaurenGB](https://avatars.discourse-cdn.com/v4/letter/l/d07c76/32.png) [@LaurenGB](https://community.hubspot.com/u/LaurenGB)\ **Post date:** [May 18, 2023, 7:15pm UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/35 "2023-05-18T19:15:17Z")
This is especially helpful for property audits with Salesforce. Please make this happen, HubSpot. A past team has several properties with over 100 values and being able to export them would be a huge time saver. ---
**Author:** ![LFielding8](https://avatars.discourse-cdn.com/v4/letter/l/51bf81/32.png) [@LFielding8](https://community.hubspot.com/u/LFielding8)\ **Post date:** [May 21, 2023, 11:55pm UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/36 "2023-05-21T23:55:18Z")
Still nothing HubSpot? It’s been 3 years. ---
**Author:** ![AMacLeod2](https://avatars.discourse-cdn.com/v4/letter/a/82dd89/32.png) [@AMacLeod2](https://community.hubspot.com/u/AMacLeod2)\ **Post date:** [June 12, 2023, 2:30pm UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/37 "2023-06-12T14:30:46Z")
Please make the happen! Such a simple feature I think. I have a list to import into hubspot and I need to make sure the values in a column match the values in the specific property, but it has over 50 options and it’s way too manual. ---
**Author:** ![MMcHugh2](https://avatars.discourse-cdn.com/v4/letter/m/b4bc9f/32.png) [@MMcHugh2](https://community.hubspot.com/u/MMcHugh2)\ **Post date:** [June 13, 2023, 6:58pm UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/38 "2023-06-13T18:58:42Z")
It would be great to be able to export the property label and internal value as a CSV or an XSLX file. ---
**Author:** ![MHusoy](https://avatars.discourse-cdn.com/v4/letter/m/bcef8e/32.png) [@MHusoy](https://community.hubspot.com/u/MHusoy)\ **Post date:** [June 26, 2023, 1:44pm UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/39 "2023-06-26T13:44:25Z")
I don’t know if they made a feature for this yet, however, I found a simple workaround: 1. Open the property where you want to export the values 2. Change “10 per page” to “Show all” 3. Drag the mouse from top to bottom and copy-paste it into ChatGPT 4. Ask ChatGPT to make it into a neat list for excel, word etc. I still would like the export option btw.😊 ---
**Author:** ![Ellesyanna](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ellesyanna/32/55434_2.png) [@Ellesyanna](https://community.hubspot.com/u/Ellesyanna)\ **Post date:** [July 17, 2023, 8:31am UTC](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647/40 "2023-07-17T08:31:32Z")
Very surprised this isn’t a possibility yet! Please create this functionality HubSpot! [Previous page](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647.md?page=1) [Next page](https://community.hubspot.com/t/export-a-single-propertys-sub-values-e-g-dropdowns-checkboxes/24647.md?page=3)