Exporting picklist values to a CSV file
You can download values from a picklist into a local CSV file.
To export values from a picklist to a CSV file:
- Click Settings .
- Click Manage Picklists in the Database Setup area.
- Open an existing picklist, or create a new one.
- Click the Picklist drop-down menu in the upper-right corner, then click Export Picklist To CSV.A download prompt for the CSV file appears.
- Select whether to open the file immediately, or to save the file to a specific location.
You now have a local copy of the picklist with values appropriately separated in an Option Value column and an Option Name column, respectively.
You can edit the file by adding, removing, or editing values, then re-upload the file into picklists as needed.