×

Clean List of World Countries, Abbreviations, & Capitals For Spreadsheets

By Chris Newman •  Updated: 03/15/23 •  8 min read
Listing every world country in an Excel list

Purpose Of This Spreadsheet Country Listing

I grew tired of searching for a well-formatted web page where I could easily grab simple lists like U.S. States abbreviations or world countries and drop them into Excel (mostly to make drop-down lists). So I took matters into my own hands and have painstakingly listed out all the countries in the world, their three-letter abbreviations, and their capital cities.

All this data is listed with the intent of copying them from the list and pasting them into Excel. That’s it! No reformatting, no weird spacing, no removing hyperlinks, notta! And yes, you are most certainly welcome :)

How To Copy & Paste Internet Lists Into Microsoft Excel

Here are the steps to paste this data quickly and cleanly into your Microsoft Excel spreadsheet:

  1. Use ctrl + c and ctrl + v to copy/paste the data from this page into your spreadsheet
  2. Use ctrl + m to Match Destination Formatting (you can do this with your mouse as well, as shown below)
    • This method sets the font color to Automatic
    • This method adjusts the font size to your default size
Copying the list of countries into Excel

Next, you can quickly throw this data into an Excel Table object using the shortcut ctrl + t.

Make sure you check the box stating My table has headers before clicking OK in the Create Table dialog box.

List of world countries into an Excel Table

Viola! You now have the country data cleanly into your Microsoft Excel spreadsheet and you can utilize it as you wish.


All World Countries In Alphabetical Order

Country
Afghanistan
Albania
Algeria
Andorra
Angola
Antigua & Barbuda
Argentina
Armenia
Australia
Austria
Azerbaijan
Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bhutan
Bolivia
Bosnia & Herzegovina
Botswana
Brazil
Brunei
Bulgaria
Burkina Faso
Burundi
Cabo Verde
Cambodia
Cameroon
Canada
Central African Republic
Chad
Chile
China
Colombia
Comoros
Congo
Costa Rica
Côte d'Ivoire
Croatia
Cuba
Cyprus
Czech Republic
Denmark
Djibouti
Dominica
Dominican Republic
DR Congo
Ecuador
Egypt
El Salvador
Equatorial Guinea
Eritrea
Estonia
Eswatini
Ethiopia
Fiji
Finland
France
Gabon
Gambia
Georgia
Germany
Ghana
Greece
Grenada
Guatemala
Guinea
Guinea-Bissau
Guyana
Haiti
Holy See
Honduras
Hungary
Iceland
India
Indonesia
Iran
Iraq
Ireland
Israel
Italy
Jamaica
Japan
Jordan
Kazakhstan
Kenya
Kiribati
Kuwait
Kyrgyzstan
Laos
Latvia
Lebanon
Lesotho
Liberia
Libya
Liechtenstein
Lithuania
Luxembourg
Madagascar
Malawi
Malaysia
Maldives
Mali
Malta
Marshall Islands
Mauritania
Mauritius
Mexico
Micronesia
Moldova
Monaco
Mongolia
Montenegro
Morocco
Mozambique
Myanmar
Namibia
Nauru
Nepal
Netherlands
New Zealand
Nicaragua
Niger
Nigeria
North Korea
North Macedonia
Norway
Oman
Pakistan
Palau
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Poland
Portugal
Qatar
Romania
Russia
Rwanda
Saint Kitts & Nevis
Saint Lucia
Samoa
San Marino
Sao Tome & Principe
Saudi Arabia
Senegal
Serbia
Seychelles
Sierra Leone
Singapore
Slovakia
Slovenia
Solomon Islands
Somalia
South Africa
South Korea
South Sudan
Spain
Sri Lanka
St. Vincent & Grenadines
State of Palestine
Sudan
Suriname
Sweden
Switzerland
Syria
Tajikistan
Tanzania
Thailand
Timor-Leste
Togo
Tonga
Trinidad & Tobago
Tunisia
Turkey
Turkmenistan
Tuvalu
Uganda
Ukraine
United Arab Emirates
United Kingdom
United States
Uruguay
Uzbekistan
Vanuatu
Venezuela
Vietnam
Yemen
Zambia
Zimbabwe

Abbreviation
AFG
ALB
DZA
AND
AGO
ATG
ARG
ARM
AUS
AUT
AZE
BHS
BHR
BGD
BRB
BLR
BEL
BLZ
BEN
BTN
BOL
BIH
BWA
BRA
BRN
BGR
BFA
BDI
CPV
KHM
CMR
CAN
CAF
TCD
CHL
CHN
COL
COM
COG
CRI
CIV
HRV
CUB
CYP
CZE
DNK
DJI
DMA
DOM
COD
ECU
EGY
SLV
GNQ
ERI
EST
SWZ
ETH
FJI
FIN
FRA
GAB
GMB
GEO
DEU
GHA
GRC
GRD
GTM
GIN
GNB
GUY
HTI
VAT
HND
HUN
ISL
IND
IDN
IRN
IRQ
IRL
ISR
ITA
JAM
JPN
JOR
KAZ
KEN
KIR
KWT
KGZ
LAO
LVA
LBN
LSO
LBR
LBY
LIE
LTU
LUX
MDG
MWI
MYS
MDV
MLI
MLT
MHL
MRT
MUS
MEX
FSM
MDA
MCO
MNG
MNE
MAR
MOZ
MMR
NAM
NRU
NPL
NLD
NZL
NIC
NER
NGA
PRK
MKD
NOR
OMN
PAK
PLW
PAN
PNG
PRY
PER
PHL
POL
PRT
QAT
ROM
RUS
RWA
KNA
LCA
WSM
SMR
STP
SAU
SEN
SRB
SYC
SLE
SGP
SVK
SVN
SLB
SOM
ZAF
KOR
SSD
ESP
LKA
VCT
PSE
SDN
SUR
SWE
CHE
SYR
TJK
TZA
THA
TLS
TGO
TON
TTO
TUN
TUR
TKM
TUV
UGA
UKR
ARE
GBR
USA
URY
UZB
VUT
VEN
VNM
YEM
ZMB
ZWE

Capital City
Kabul
Tirana
Algiers
Andorra la Vella
Luanda
St. John's
Buenos Aires
Yerevan
Canberra
Vienna
Baku
Nassau
Manama
Dhaka
Bridgetown
Minsk
Brussels
Belmopan
Porto-Novo
Thimphu
La Paz
Sarajevo
Gaborone
Brasília
Bandar Seri Begawan
Sofia
Ouagadougou
Gitega
Praia
Phnom Penh
Yaoundé
Ottawa
Bangui
N'Djamena
Santiago
Beijing
Bogotá
Moroni
Brazzaville
San José
Yamoussoukro
Zagreb
Havana
Nicosia
Prague
Copenhagen
Djibouti
Roseau
Santo Domingo
Kinshasa
Quito
Cairo
San Salvador
Malabo
Asmara
Tallinn
Mbabane
Addis Ababa
Suva
Helsinki
Paris
Libreville
Banjul
Tbilisi
Berlin
Accra
Athens
St. George's
Guatemala City
Conakry
Bissau
Georgetown
Port-au-Prince
Vatican City
Tegucigalpa
Budapest
Reykjavik
New Delhi
Jakarta
Tehran
Baghdad
Dublin
Jerusalem
Rome
Kingston
Tokyo
Amman
Nur-Sultan
Nairobi
South Tarawa
Kuwait City
Bishkek
Vientiane
Riga
Beirut
Maseru
Monrovia
Tripoli
Vaduz
Vilnius
Luxembourg City
Antananarivo
Lilongwe
Kuala Lumpur
Male
Bamako
Valletta
Majuro
Nouakchott
Port Louis
Mexico City
Palikir
Chisinau
Monaco
Ulaanbaatar
Podgorica
Rabat
Maputo
Naypyidaw
Windhoek
Yaren District
Kathmandu
Amsterdam
Wellington
Managua
Niamey
Abuja
Pyongyang
Skopje
Oslo
Muscat
Islamabad
Ngerulmud
Panama City
Port Moresby
Asunción
Lima
Manila
Warsaw
Lisbon
Doha
Bucharest
Moscow
Kigali
Basseterre
Castries
Apia
San Marino
São Tomé
Riyadh
Dakar
Belgrade
Victoria
Freetown
Singapore
Bratislava
Ljubljana
Honiara
Mogadishu
Cape Town
Seoul
Juba
Madrid
Sri Jayawardenepura Kotte
Kingstown
Ramallah
Khartoum
Paramaribo
Stockholm
Bern
Damascus
Dushanbe
Dodoma
Bangkok
Dili
Lomé
Nuku'alofa
Port of Spain
Tunis
Ankara
Ashgabat
Funafuti
Kampala
Kyiv
Abu Dhabi
London
Washington DC
Montevideo
Tashkent
Port Vila
Caracas
Hanoi
Sana'a
Lusaka
Harare

Continent
Asia
Europe
Africa
Europe
Africa
N. America
S. America
Asia
Australia
Europe
Asia
N. America
Asia
Asia
N. America
Europe
Europe
N. America
Africa
Asia
S. America
Europe
Africa
S. America
Asia
Europe
Africa
Africa
Africa
Asia
Africa
N. America
Africa
Africa
S. America
Asia
S. America
Africa
Africa
N. America
Africa
Europe
N. America
Asia
Europe
Europe
Africa
N. America
N. America
Africa
S. America
Africa
N. America
Africa
Africa
Europe
Africa
Africa
Australia
Europe
Europe
Africa
Africa
Asia
Europe
Africa
Europe
N. America
N. America
Africa
Africa
S. America
N. America
Europe
N. America
Europe
Europe
Asia
Asia
Asia
Asia
Europe
Asia
Europe
N. America
Asia
Asia
Asia
Africa
Australia
Asia
Asia
Asia
Europe
Asia
Africa
Africa
Africa
Europe
Europe
Europe
Africa
Africa
Asia
Asia
Africa
Europe
Australia
Africa
Africa
N. America
Australia
Europe
Europe
Asia
Europe
Africa
Africa
Asia
Africa
Australia
Asia
Europe
Australia
N. America
Africa
Africa
Asia
Europe
Europe
Asia
Asia
Australia
N. America
Australia
S. America
S. America
Asia
Europe
Europe
Asia
Europe
Europe
Africa
N. America
N. America
Australia
Europe
Africa
Asia
Africa
Europe
Africa
Africa
Asia
Europe
Europe
Australia
Africa
Africa
Asia
Africa
Europe
Asia
N. America
Asia
Africa
S. America
Europe
Europe
Asia
Asia
Africa
Asia
Asia
Africa
Australia
N. America
Africa
Asia
Asia
Australia
Africa
Europe
Asia
Europe
N. America
S. America
Asia
Australia
S. America
Asia
Asia
Africa
Africa


The Continent of North America

North America is a vast and diverse continent located in the Northern Hemisphere, covering an area of approximately 24 million square kilometers. It is home to 23 countries and over 580 million people, making it the third-largest continent by both land area and population. North America is known for its rich history, diverse cultures, and stunning natural beauty, with famous landmarks such as the Grand Canyon, Niagara Falls, and the Rocky Mountains.

Country
Antigua and Barbuda
Bahamas
Barbados
Belize
Canada
Costa Rica
Cuba
Dominica
Dominican Republic
El Salvador
Grenada
Guatemala
Haiti
Honduras
Jamaica
Mexico
Nicaragua
Panama
Saint Kitts & Nevis
Saint Lucia
St. Vincent & Grenadines
Trinidad & Tobago
United States

Abbreviation
ATG
BHS
BRB
BLZ
CAN
CRI
CUB
DMA
DOM
SLV
GRD
GTM
HTI
HND
JAM
MEX
NIC
PAN
KNA
LCA
VCT
TTO
USA

Capital City
St. John's
Nassau
Bridgetown
Belmopan
Ottawa
San José
Havana
Roseau
Santo Domingo
San Salvador
St. George's
Guatemala City
Port-au-Prince
Tegucigalpa
Kingston
Mexico City
Managua
Panama City
Basseterre
Castries
Kingstown
Port of Spain
Washington DC

Continent
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America
N. America


The Continent of South America

South America is a vast and diverse continent located in the Western Hemisphere, covering an area of approximately 17 million square kilometers. It is home to 13 countries and over 420 million people, making it the fourth-largest continent by both land area and population. South America is known for its rich history, diverse cultures, and breathtaking natural beauty, with landmarks such as the Amazon rainforest, the Andes Mountains, and the Galapagos Islands.

Country
Argentina
Bolivia
Brazil
Chile
Colombia
Ecuador
Guyana
Paraguay
Peru
Suriname
Uruguay
Venezuela

Abbreviation
ARG
BOL
BRA
CHL
COL
ECU
GUY
PRY
PER
SUR
URY
VEN

Capital City
Buenos Aires
La Paz
Brasília
Santiago
Bogotá
Quito
Georgetown
Asunción
Lima
Paramaribo
Montevideo
Caracas

Continent
S. America
S. America
S. America
S. America
S. America
S. America
S. America
S. America
S. America
S. America
S. America
S. America


The Continent of Europe

Europe is a continent located in the Northern Hemisphere, consisting of approximately 44 countries and covering an area of around 10 million square kilometers. It is the second smallest continent in terms of land area but is home to over 750 million people, making it the third most populous continent in the world after Asia and Africa. Europe is known for its rich history, diverse cultures, and stunning architecture, with famous landmarks such as the Eiffel Tower, the Colosseum, and Big Ben.

Country
Albania
Andorra
Austria
Belarus
Belgium
Bosnia & Herzegovina
Bulgaria
Croatia
Czech Republic
Denmark
Estonia
Finland
France
Germany
Greece
Holy See
Hungary
Iceland
Ireland
Italy
Latvia
Liechtenstein
Lithuania
Luxembourg
Malta
Moldova
Monaco
Montenegro
Netherlands
North Macedonia
Norway
Poland
Portugal
Romania
Russia
San Marino
Serbia
Slovakia
Slovenia
Spain
Sweden
Switzerland
Ukraine
United Kingdom

Abbreviation
ALB
AND
AUT
BLR
BEL
BIH
BGR
HRV
CZE
DNK
EST
FIN
FRA
DEU
GRC
VAT
HUN
ISL
IRL
ITA
LVA
LIE
LTU
LUX
MLT
MDA
MCO
MNE
NLD
MKD
NOR
POL
PRT
ROM
RUS
SMR
SRB
SVK
SVN
ESP
SWE
CHE
UKR
GBR

Capital City
Tirana
Andorra la Vella
Vienna
Minsk
Brussels
Sarajevo
Sofia
Zagreb
Prague
Copenhagen
Tallinn
Helsinki
Paris
Berlin
Athens
Vatican City
Budapest
Reykjavik
Dublin
Rome
Riga
Vaduz
Vilnius
Luxembourg City
Valletta
Chisinau
Monaco
Podgorica
Amsterdam
Skopje
Oslo
Warsaw
Lisbon
Bucharest
Moscow
San Marino
Belgrade
Bratislava
Ljubljana
Madrid
Stockholm
Bern
Kyiv
London

Continent
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe
Europe


The Continent of Australia/Oceania

Oceania is a region consisting of thousands of islands spread across the Pacific Ocean. It includes the Australian continent, New Zealand, and various island groups such as Micronesia, Melanesia, and Polynesia. Oceania covers an area of approximately 8.5 million square kilometers and is home to over 41 million people. The region is known for its diverse cultures, unique flora and fauna, and stunning natural landscapes, including coral reefs, volcanoes, and tropical rainforests.

Country
Australia
Fiji
Kiribati
Marshall Islands
Micronesia
Nauru
New Zealand
Palau
Papua New Guinea
Samoa
Solomon Islands
Tonga
Tuvalu
Vanuatu

Abbreviation
AUS
FJI
KIR
MHL
FSM
NRU
NZL
PLW
PNG
WSM
SLB
TON
TUV
VUT

Capital City
Canberra
Suva
South Tarawa
Majuro
Palikir
Yaren District
Wellington
Ngerulmud
Port Moresby
Apia
Honiara
Nuku'alofa
Funafuti
Port Vila

Continent
Australia/Oceania
Australia/Oceania
Australia/Oceania
Australia/Oceania
Australia/Oceania
Australia/Oceania
Australia/Oceania
Australia/Oceania
Australia/Oceania
Australia/Oceania
Australia/Oceania
Australia/Oceania
Australia/Oceania
Australia/Oceania


The Continent of Africa

Africa is a vast and diverse continent located in the Southern Hemisphere, with a land area of approximately 30 million square kilometers. It is home to over 1.3 billion people and is the second most populous continent in the world after Asia. Africa is known for its rich cultural diversity, fascinating history, and unique natural landscapes, including deserts, rainforests, savannas, and mountains.

Country
Algeria
Angola
Benin
Botswana
Burkina Faso
Burundi
Cabo Verde
Cameroon
Central African Republic
Chad
Comoros
Congo
Côte d'Ivoire
Djibouti
DR Congo
Egypt
Equatorial Guinea
Eritrea
Eswatini
Ethiopia
Gabon
Gambia
Ghana
Guinea
Guinea-Bissau
Kenya
Lesotho
Liberia
Libya
Madagascar
Malawi
Mali
Mauritania
Mauritius
Morocco
Mozambique
Namibia
Niger
Nigeria
Rwanda
Sao Tome & Principe
Senegal
Seychelles
Sierra Leone
Somalia
South Africa
South Sudan
Sudan
Tanzania
Togo
Tunisia
Uganda
Zambia
Zimbabwe

Abbreviation
DZA
AGO
BEN
BWA
BFA
BDI
CPV
CMR
CAF
TCD
COM
COG
CIV
DJI
COD
EGY
GNQ
ERI
SWZ
ETH
GAB
GMB
GHA
GIN
GNB
KEN
LSO
LBR
LBY
MDG
MWI
MLI
MRT
MUS
MAR
MOZ
NAM
NER
NGA
RWA
STP
SEN
SYC
SLE
SOM
ZAF
SSD
SDN
TZA
TGO
TUN
UGA
ZMB
ZWE

Capital City
Algiers
Luanda
Porto-Novo
Gaborone
Ouagadougou
Gitega
Praia
Yaoundé
Bangui
N'Djamena
Moroni
Brazzaville
Yamoussoukro
Djibouti
Kinshasa
Cairo
Malabo
Asmara
Mbabane
Addis Ababa
Libreville
Banjul
Accra
Conakry
Bissau
Nairobi
Maseru
Monrovia
Tripoli
Antananarivo
Lilongwe
Bamako
Nouakchott
Port Louis
Rabat
Maputo
Windhoek
Niamey
Abuja
Kigali
São Tomé
Dakar
Victoria
Freetown
Mogadishu
Cape Town
Juba
Khartoum
Dodoma
Lomé
Tunis
Kampala
Lusaka
Harare

Continent
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa
Africa


The Continent of Asia

Asia is the world's largest and most populous continent, covering approximately 44 million square kilometers and home to over 4.6 billion people. It is located primarily in the Eastern Hemisphere, with borders shared by Europe to the west and Africa to the southwest. Asia is known for its rich history, diverse cultures, and stunning natural beauty, with famous landmarks such as the Great Wall of China, the Taj Mahal, and Mount Everest.

Country
Afghanistan
Armenia
Azerbaijan
Bahrain
Bangladesh
Bhutan
Brunei
Cambodia
China
Cyprus
Georgia
India
Indonesia
Iran
Iraq
Israel
Japan
Jordan
Kazakhstan
Kuwait
Kyrgyzstan
Laos
Lebanon
Malaysia
Maldives
Mongolia
Myanmar
Nepal
North Korea
Oman
Pakistan
Philippines
Qatar
Saudi Arabia
Singapore
South Korea
Sri Lanka
State of Palestine
Syria
Tajikistan
Thailand
Timor-Leste
Turkey
Turkmenistan
United Arab Emirates
Uzbekistan
Vietnam
Yemen

Abbreviation
AFG
ARM
AZE
BHR
BGD
BTN
BRN
KHM
CHN
CYP
GEO
IND
IDN
IRN
IRQ
ISR
JPN
JOR
KAZ
KWT
KGZ
LAO
LBN
MYS
MDV
MNG
MMR
NPL
PRK
OMN
PAK
PHL
QAT
SAU
SGP
KOR
LKA
PSE
SYR
TJK
THA
TLS
TUR
TKM
ARE
UZB
VNM
YEM

Capital City
Kabul
Yerevan
Baku
Manama
Dhaka
Thimphu
Bandar Seri Begawan
Phnom Penh
Beijing
Nicosia
Tbilisi
New Delhi
Jakarta
Tehran
Baghdad
Jerusalem
Tokyo
Amman
Nur-Sultan
Kuwait City
Bishkek
Vientiane
Beirut
Kuala Lumpur
Male
Ulaanbaatar
Naypyidaw
Kathmandu
Pyongyang
Muscat
Islamabad
Manila
Doha
Riyadh
Singapore
Seoul
Sri Jayawardenepura Kotte
Ramallah
Damascus
Dushanbe
Bangkok
Dili
Ankara
Ashgabat
Abu Dhabi
Tashkent
Hanoi
Sana'a

Continent
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia


Free Downloadable Files Of Country Data

If you are searching for a specific file format with the countries, their three-letter abbreviations, and their corresponding capital city, below I’ve compiled a variety of file formats you can click and instantly download.

If there are other file formats you want to see, please let me know in the comments section towards the end of this article.


Any Other Lists You Would Like to See?

Let me know in the comments section if there are other common listings you’d like me to generate for ease of use. In this day and age, it shouldn’t be this complicated to grab these listings cleanly from the internet!

Keep Learning

Chris Newman

Chris Newman

Chris is a finance professional and Excel MVP recognized by Microsoft since 2016. With his expertise, he founded TheSpreadsheetGuru blog to help fellow Excel users, where he shares his vast creative solutions & expertise. In addition, he has developed over 7 widely-used Excel Add-ins that have been embraced by individuals and companies worldwide.