How do I export the standard pick lists for country and state from salesforce? - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Tom ThomasTom Thomas 

How do I export the standard pick lists for country and state from salesforce?

I would like to export the country code and state used in saleforce to create a look up table used for intergration.  Has anyone have a source for the same values used in salesforce?
Vamsi GosuVamsi Gosu
one option i can think of is i
  • go to Setup -> Data Management -> State & Country picklists
  • and click on Configure link
  • in the configuration page , right click and select View Source
then you will 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>
.........

there could be other better options as well..