Csv list of country codes/names?

Question

Where can I get a list of easily parseable country codes and names? Note: 2 letter codes wanted. Examples:

au,Australia

uk,United Kingdom

us,United States

etc

thanks for this question and answer both. but i wonder why someone so called expert from SO argue this question as a dumb question.This is very useful question and answer for me i also upvote it, but there are so many idiots and boasty people on so who always find such a question to criticize.I am boarded of it and this post is answer to them all nonsense so called expert. after all the final goal of SO and its post to become a useful to their user.thanks again . — Mihir, Jun 14 '13 at 09:25
update there are so many so called experts on the so who did it several times for my questions and some one others question on so .god bless them all. — Mihir, Jun 16 '13 at 12:46
@Mihir. I commiserate. Every once in a while I too am the victim of the "drive-by" downvoter and question closer. SO is great. The fact that people can elect to downvote and close without offering a single word of explanation is unfortunate. — DroidOS, Oct 18 '15 at 06:02

Ali · Accepted Answer · 2015-03-08T07:14:34.257

The ISO 3166-1 list of country codes is what I was looking for.

For more information you can also find general information about country codes on Wikipedia and a - possibly more up to date list - ISO 3166-1 list as well.

Edit: Posting it here:

Country Name;ISO 3166-1-alpha-2 code

AFGHANISTAN;AF
ÅLAND ISLANDS;AX
ALBANIA;AL
ALGERIA;DZ
AMERICAN SAMOA;AS
ANDORRA;AD
ANGOLA;AO
ANGUILLA;AI
ANTARCTICA;AQ
ANTIGUA AND BARBUDA;AG
ARGENTINA;AR
ARMENIA;AM
ARUBA;AW
AUSTRALIA;AU
AUSTRIA;AT
AZERBAIJAN;AZ
BAHAMAS;BS
BAHRAIN;BH
BANGLADESH;BD
BARBADOS;BB
BELARUS;BY
BELGIUM;BE
BELIZE;BZ
BENIN;BJ
BERMUDA;BM
BHUTAN;BT
BOLIVIA, PLURINATIONAL STATE OF;BO
BONAIRE, SINT EUSTATIUS AND SABA;BQ
BOSNIA AND HERZEGOVINA;BA
BOTSWANA;BW
BOUVET ISLAND;BV
BRAZIL;BR
BRITISH INDIAN OCEAN TERRITORY;IO
BRUNEI DARUSSALAM;BN
BULGARIA;BG
BURKINA FASO;BF
BURUNDI;BI
CAMBODIA;KH
CAMEROON;CM
CANADA;CA
CAPE VERDE;CV
CAYMAN ISLANDS;KY
CENTRAL AFRICAN REPUBLIC;CF
CHAD;TD
CHILE;CL
CHINA;CN
CHRISTMAS ISLAND;CX
COCOS (KEELING) ISLANDS;CC
COLOMBIA;CO
COMOROS;KM
CONGO;CG
CONGO, THE DEMOCRATIC REPUBLIC OF THE;CD
COOK ISLANDS;CK
COSTA RICA;CR
CÔTE D'IVOIRE;CI
CROATIA;HR
CUBA;CU
CURAÇAO;CW
CYPRUS;CY
CZECH REPUBLIC;CZ
DENMARK;DK
DJIBOUTI;DJ
DOMINICA;DM
DOMINICAN REPUBLIC;DO
ECUADOR;EC
EGYPT;EG
EL SALVADOR;SV
EQUATORIAL GUINEA;GQ
ERITREA;ER
ESTONIA;EE
ETHIOPIA;ET
FALKLAND ISLANDS (MALVINAS);FK
FAROE ISLANDS;FO
FIJI;FJ
FINLAND;FI
FRANCE;FR
FRENCH GUIANA;GF
FRENCH POLYNESIA;PF
FRENCH SOUTHERN TERRITORIES;TF
GABON;GA
GAMBIA;GM
GEORGIA;GE
GERMANY;DE
GHANA;GH
GIBRALTAR;GI
GREECE;GR
GREENLAND;GL
GRENADA;GD
GUADELOUPE;GP
GUAM;GU
GUATEMALA;GT
GUERNSEY;GG
GUINEA;GN
GUINEA-BISSAU;GW
GUYANA;GY
HAITI;HT
HEARD ISLAND AND MCDONALD ISLANDS;HM
HOLY SEE (VATICAN CITY STATE);VA
HONDURAS;HN
HONG KONG;HK
HUNGARY;HU
ICELAND;IS
INDIA;IN
INDONESIA;ID
IRAN, ISLAMIC REPUBLIC OF;IR
IRAQ;IQ
IRELAND;IE
ISLE OF MAN;IM
ISRAEL;IL
ITALY;IT
JAMAICA;JM
JAPAN;JP
JERSEY;JE
JORDAN;JO
KAZAKHSTAN;KZ
KENYA;KE
KIRIBATI;KI
KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF;KP
KOREA, REPUBLIC OF;KR
KUWAIT;KW
KYRGYZSTAN;KG
LAO PEOPLE'S DEMOCRATIC REPUBLIC;LA
LATVIA;LV
LEBANON;LB
LESOTHO;LS
LIBERIA;LR
LIBYA;LY
LIECHTENSTEIN;LI
LITHUANIA;LT
LUXEMBOURG;LU
MACAO;MO
MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF;MK
MADAGASCAR;MG
MALAWI;MW
MALAYSIA;MY
MALDIVES;MV
MALI;ML
MALTA;MT
MARSHALL ISLANDS;MH
MARTINIQUE;MQ
MAURITANIA;MR
MAURITIUS;MU
MAYOTTE;YT
MEXICO;MX
MICRONESIA, FEDERATED STATES OF;FM
MOLDOVA, REPUBLIC OF;MD
MONACO;MC
MONGOLIA;MN
MONTENEGRO;ME
MONTSERRAT;MS
MOROCCO;MA
MOZAMBIQUE;MZ
MYANMAR;MM
NAMIBIA;NA
NAURU;NR
NEPAL;NP
NETHERLANDS;NL
NEW CALEDONIA;NC
NEW ZEALAND;NZ
NICARAGUA;NI
NIGER;NE
NIGERIA;NG
NIUE;NU
NORFOLK ISLAND;NF
NORTHERN MARIANA ISLANDS;MP
NORWAY;NO
OMAN;OM
PAKISTAN;PK
PALAU;PW
PALESTINE, STATE OF;PS
PANAMA;PA
PAPUA NEW GUINEA;PG
PARAGUAY;PY
PERU;PE
PHILIPPINES;PH
PITCAIRN;PN
POLAND;PL
PORTUGAL;PT
PUERTO RICO;PR
QATAR;QA
RÉUNION;RE
ROMANIA;RO
RUSSIAN FEDERATION;RU
RWANDA;RW
SAINT BARTHÉLEMY;BL
SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA;SH
SAINT KITTS AND NEVIS;KN
SAINT LUCIA;LC
SAINT MARTIN (FRENCH PART);MF
SAINT PIERRE AND MIQUELON;PM
SAINT VINCENT AND THE GRENADINES;VC
SAMOA;WS
SAN MARINO;SM
SAO TOME AND PRINCIPE;ST
SAUDI ARABIA;SA
SENEGAL;SN
SERBIA;RS
SEYCHELLES;SC
SIERRA LEONE;SL
SINGAPORE;SG
SINT MAARTEN (DUTCH PART);SX
SLOVAKIA;SK
SLOVENIA;SI
SOLOMON ISLANDS;SB
SOMALIA;SO
SOUTH AFRICA;ZA
SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS;GS
SOUTH SUDAN;SS
SPAIN;ES
SRI LANKA;LK
SUDAN;SD
SURINAME;SR
SVALBARD AND JAN MAYEN;SJ
SWAZILAND;SZ
SWEDEN;SE
SWITZERLAND;CH
SYRIAN ARAB REPUBLIC;SY
TAIWAN, PROVINCE OF CHINA;TW
TAJIKISTAN;TJ
TANZANIA, UNITED REPUBLIC OF;TZ
THAILAND;TH
TIMOR-LESTE;TL
TOGO;TG
TOKELAU;TK
TONGA;TO
TRINIDAD AND TOBAGO;TT
TUNISIA;TN
TURKEY;TR
TURKMENISTAN;TM
TURKS AND CAICOS ISLANDS;TC
TUVALU;TV
UGANDA;UG
UKRAINE;UA
UNITED ARAB EMIRATES;AE
UNITED KINGDOM;GB
UNITED STATES;US
UNITED STATES MINOR OUTLYING ISLANDS;UM
URUGUAY;UY
UZBEKISTAN;UZ
VANUATU;VU
VENEZUELA, BOLIVARIAN REPUBLIC OF;VE
VIETNAM;VN
VIRGIN ISLANDS, BRITISH;VG
VIRGIN ISLANDS, U.S.;VI
WALLIS AND FUTUNA;WF
WESTERN SAHARA;EH
YEMEN;YE
ZAMBIA;ZM
ZIMBABWE;ZW

GitHub repo with humanized country names in multiple languages in multiple formats: https://github.com/umpirsky/country-list/blob/master/country/cldr/en/country.csv (see my answer below) — David Hu, Mar 23 '13 at 00:00
Thanks for posting here, because ISO well is now selling this list, lol — George Chalhoub, Feb 20 '15 at 20:17
Be warned that countries only seem static because we humans live so shortly, the number and name of countries varies all the time. This answer and your script may live on after your life but certainly that of countries as well. — Maarten Bodewes, Mar 07 '15 at 19:29

score 46 · Answer 2 · edited Jan 15 '16 at 13:09

46

Here's a maintained repo of country codes with friendly country names in multiple languages and in many formats, including text, CSV, JSON, YAML, XML, SQL, and others:

https://github.com/umpirsky/country-list

The English CSV dump from the above repo: https://github.com/umpirsky/country-list/blob/master/data/en_US/country.csv

edited Jan 15 '16 at 13:09

philmaweb

514
7
13

answered Mar 13 '13 at 06:57

David Hu

3,076
24
26

Seems not to be so maintained anymore... – Dio F Feb 27 '17 at 09:12
@DioF The owner responded to a pull request mid Feb. 2017. He might not have committed for a while, but I would hardly call this repo "not so maintained". – T.C. Proctor Jun 07 '17 at 20:51

score 12 · Answer 3 · answered Apr 20 '12 at 01:48

12

In case it can help anyone, I just took the list of ISO 3166 country codes and names in English and French and put them together in CSV and SQL format: http://blog.plsoucy.com/2012/04/iso-3166-country-code-list-csv-sql/

While doing that, I fixed the capitalization so names aren't all uppercase, and renamed a few countries to the name that is used on Wikipedia, so "MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF" became "Macedonia" for example. That should allow for shorter lists.

Feel free to use these if you want.

answered Apr 20 '12 at 01:48

Pierre-Luc Soucy

131
1
4

2

There's a GitHub repo with humanized country names in multiple languages in multiple formats: https://github.com/umpirsky/country-list/blob/master/country/cldr/en/country.csv (see my answer below) – David Hu Mar 23 '13 at 00:03
If you just want the English ISO dump along with table definitions, I maintain this here: http://kejser.org/resources/free-data/free-data-countries-world/ – Thomas Kejser Jun 27 '14 at 01:28

SQLMenace · Answer 4 · 2012-10-03T15:04:57.823

8

Take a look at ISO http://www.iso.org/iso/home/standards/country_codes/country_names_and_code_elements.htm It is not CSV but you can easily copy and paste it into a file, or you can buy the file from ISO

updated the link

edited Oct 03 '12 at 15:04

answered Mar 22 '11 at 18:04

SQLMenace

132,095
25
206
225

Csv list of country codes/names?

4 Answers4

Linked