+ Start a Discussion

Picklist export/extract

I want to extract the valid Picklist values for table Account field Industry for comparison to the values currently used. How can I extract these values? Are they stored in a table that I can download?
Ron HessRon Hess
check out the docs for DescribeSObject(), there is a list of fields, which contain a list of picklist values if they are picklist fields.
maninder singh 50maninder singh 50
you can use this chrome extension to export picklist values of any standard/custom object in salesforce. salesforce data/metadata utility (https://chrome.google.com/webstore/detail/salesforce-datametadata-u/jkmajpplbomebfegjjagbeoblheeehld) . the user should have API Enabled for this feature.
Nhung NguyenNhung Nguyen

The "Salesforce Data/Metadata Utility" chrome extension mentioned is great.  I use it every day.

The noly problem with the picklist value export is that it only exports Active values.  I want to do a clean up of the inactive values and was hoping to assess which fields had the most inactive values, so I can focus on them first.