Print this page

How do I export Country values for State and Country picklists?

Knowledge Article Number 000212234
Description Is there a way to Export Country Picklist values for my organization?

Resolution There is no standard functionality that would allow you to export State and Country Picklist values since they are classified as Metadata. It is not possible to use reports or Data Loader to export this information since this is not data.

As a workaround you may use IDE to retrieve the metadata or follow these steps:
  •  Navigate to Setup, Data Management | State & Country picklists
  • Click on the Configure states and countries link
  • In the configuration page, right click in your browser and select View Source
If you scroll down in the resulting source code you should see something like:

<option value="AF">Afghanistan</option>
<option value="AX">Aland Islands</option>
<option value="AL">Albania</option>
<option value="DZ">Algeria</option>
<option value="AD">Andorra</option>
<option value="AO">Angola</option>
<option value="AI">Anguilla</option>
<option value="AQ">Antarctica</option>
<option value="AG">Antigua and Barbuda</option>
<option value="AR">Argentina</option>
<option value="AM">Armenia</option>
<option value="AW">Aruba</option>
<option value="AU" selected="selected">Australia</option>
<option value="AT">Austria</option>
<option value="AZ">Azerbaijan</option>
<option value="BS">Bahamas</option>
<option value="BH">Bahrain</option>

Copy and Paste the results into Excel where you can format them to desired results.


promote demote