List of Countries by Continent Excel Download
Do you need a comprehensive and updated list of all the countries in the world, organized by continent? If so, you are in luck! In this article, we will provide you with a free Excel file that contains the list of countries by continent, along with their capitals, population, area, and other useful information. You will also learn some interesting facts and figures about each continent and its countries. Whether you need this data for your school project, your business, or your personal curiosity, you will find it here.
list of countries by continent excel download
Introduction
What is a continent?
A continent is a large landmass that is separated from other landmasses by oceans or other natural features. There are different ways to classify the continents, but the most common one is the seven-continent model, which divides the world into Asia, Africa, North America, South America, Europe, Oceania (or Australia), and Antarctica. Some countries use other models, such as the six-continent model that combines Europe and Asia into Eurasia, or the five-continent model that excludes Antarctica. In this article, we will follow the seven-continent model.
Why do you need a list of countries by continent?
A list of countries by continent can be very useful for various purposes. For example, you can use it to:
Learn more about the geography, history, culture, and politics of different regions of the world.
Compare and contrast the characteristics and statistics of different countries and continents.
Find out which countries belong to which continent and which ones are transcontinental (spanning more than one continent).
Prepare for quizzes, tests, or trivia games that involve questions about countries and continents.
Create charts, graphs, maps, or reports that require data on countries and continents.
How to download an Excel file with the list of countries by continent
To download an Excel file with the list of countries by continent, all you have to do is click on this link: . The file is in .xlsx format and it contains six worksheets, one for each continent (except Antarctica). Each worksheet has a table with the following columns:
download excel spreadsheet of countries and continents
how to get a list of all countries by continent in excel format
excel file with country names and continent codes
where to find an excel sheet of continents and countries
download free excel data of countries grouped by continent
excel table of countries and their continents
how to create an excel list of countries by continent
excel document with continent and country information
download csv file of country and continent data
excel workbook with list of all countries and continents
how to download an excel file of countries by continent
excel sheet with country codes and continent names
where can I get an excel list of continents and countries
download excel data of countries and their continent regions
excel file with list of countries by continent and population
how to get a csv file of country and continent information
excel spreadsheet with country and continent data for analysis
where to download an excel file of continents and countries for free
excel sheet with list of all countries by continent and capital city
how to create a csv file of country and continent data
excel document with list of countries by continent and area
download free csv data of continents and countries
excel table with country and continent information for mapping
where can I find a csv file of country and continent data
download csv data of countries by continent and GDP
how to download a free excel file of countries by continent
excel workbook with country and continent data for visualization
where to find a free csv file of continents and countries
download excel sheet with list of countries by continent and currency
how to create an excel document with country and continent information
excel file with list of countries by continent and language
download free excel data of continents and countries for education
excel spreadsheet with country and continent information for research
where can I download an excel file of country and continent data
download csv file with list of countries by continent and flag
how to get an excel sheet with country and continent information
excel sheet with list of countries by continent and ISO code
download free csv data of country and continent information for statistics
excel document with country and continent data for comparison
where to get a csv file with list of continents and countries
download csv data of countries by continent and time zone
how to create a free excel file with country and continent information
excel file with list of countries by continent and internet domain
download free excel data of country and continent information for travel
excel table with country and continent data for sorting
where can I find a free excel file with list of continents and countries
Country: The name of the country.
Capital: The name of the capital city.
Population: The estimated population as of 2020.
Area: The total area in square kilometers.
Density: The population density in people per square kilometer.
GDP: The gross domestic product in US dollars as of 2019.
GDP per capita: The gross domestic product per person in US dollars as of 2019.
The data in the file is based on the sources from . The file is free to download and use for any purpose. However, we cannot guarantee the accuracy or completeness of the data, so please use it at your own risk.</ List of Countries by Continent
In this section, we will present the list of countries by continent, along with some facts and figures about each continent and its countries. You can also find the same information in the Excel file that you can download from the link above.
Africa
Africa is the second-largest and second-most populous continent in the world, with about 1.3 billion people living in 54 countries. It covers about 20% of the Earth's land area and has a diverse range of natural resources, cultures, languages, and religions. Africa is also home to some of the world's most iconic wildlife, such as elephants, lions, giraffes, zebras, and rhinos.
Table with countries and capitals
Country
Capital
Population
Area
Density
GDP
GDP per capita
Algeria
Algiers
43,851,044
2,381,741
18.4
$169.99 billion
$3,877
Angola
Luanda
32,866,272
1,246,700
26.4
$94.21 billion
$2,868
Benin
Porto-Novo
12,123,200
114,763
105.7
$14.39 billion
$1,186
Zimbabwe
Harare
14,862,924
390,757
38.0$21.44 billion >$1,464 >Facts and figures about Africa >
The largest country in Africa by area is Algeria, with 2.38 million square kilometers. The smallest country is Seychelles, with 452 square kilometers.
The most populous country in Africa is Nigeria, with about 206 million people. The least populous country is Seychelles, with about 98 thousand people.
The richest country in Africa by GDP per capita is Equatorial Guinea, with $21,056. The poorest country is Burundi, with $261.
The highest point in Africa is Mount Kilimanjaro in Tanzania, with 5,895 meters above sea level. The lowest point is Lake Assal in Djibouti, with 155 meters below sea level.
The longest river in Africa is the Nile, with 6,650 kilometers. The largest lake is Lake Victoria, with 68,800 square kilometers.
Asia >Asia is the largest and most populous continent in the world, with about 4.6 billion people living in 48 countries. It covers about 30% of the Earth's land area and has a diverse range of natural resources, cultures, languages, and religions. Asia is also home to some of the world's oldest civilizations, as well as some of the most modern and dynamic economies.Table with countries and capitals >Country >Capital >Population >Area >Density >GDP >GDP per capita >Afghanistan >Kabul >38,928,346 >652,230 >59.7 >$19.10 billion >$491 >Bahrain >Manama >1,701,575 >765 >2,227.4 $37.74 billion $22,149
Bangladesh Dhaka 164,689,383 147,570 1,116.0 $302.57 billion $1,837
Yemen Sana'a 29,825,964 527,968 56.5 $26.91 billion $904
Facts and figures about Asia
The largest country in Asia by area is Russia, with 13.1 million square kilometers. The smallest country is Maldives, with 298 square kilometers.
The most populous country in Asia is China, with about 1.4 billion people. The least populous country is Maldives, with about 540 thousand people.
The richest country in Asia by GDP per capita is Qatar, with $69,687. The poorest country is Afghanistan, with $491.
The highest point in Asia is Mount Everest in Nepal and China, with 8,848 meters above sea level. The lowest point is the Dead Sea in Israel and Jordan, with 431 meters below sea level.
The longest river in Asia is the Yangtze in China, with 6,300 kilometers. The largest lake is the Caspian Sea in Russia, Iran, Kazakhstan, Turkmenistan, and Azerbaijan, with 371,000 square kilometers.
Europe
Europe is the sixth-largest and third-most populous continent in the world, with about 747 million people living in 44 countries. It covers about 6.8% of the Earth's land area and has a rich and diverse history, culture, and heritage. Europe is also home to some of the world's most influential political and economic organizations, such as the European Union and NATO.
Table with countries and capitals
Country
Capital
Population
Area
Density
GDP
GDP per capita
Albania Tirana >2,877,797 >28,748 >100.2 >$15.28 billion >$5,307 >
Andorra Andorra la Vella >77,265 >468 165.0 $3.15 billion $40,674
Armenia Yerevan 2,963,243 29,743 99.6 $13.67 billion $4,609
Vatican City Vatican City 825 0.44 1,877.3 N/A N/A
Facts and figures about Europe
The largest country in Europe by area is Russia, with 3.96 million square kilometers. The smallest country is Vatican City, with 0.44 square kilometers.
The most populous country in Europe is Russia, with about 146 million people. The least populous country is Vatican City, with about 800 people.
The richest country in Europe by GDP per capita is Luxembourg, with $114,705. The poorest country is Moldova, with $2,289.
The highest point in Europe is Mount Elbrus in Russia, with 5,642 meters above sea level. The lowest point is Caspian Sea in Russia, Kazakhstan, Turkmenistan, Azerbaijan, and Iran, with 28 meters below sea level.
The longest river in Europe is the Volga in Russia, with 3,531 kilometers. The largest lake is Lake Ladoga in Russia and Finland, with 17,700 square kilometers.
North America
North America is the third-largest and fourth-most populous continent in the world, with about 592 million people living in 23 countries. It covers about 16.5% of the Earth's land area and has a diverse range of natural resources, cultures, languages, and religions. North America is also home to some of the world's most powerful and influential countries, such as the United States and Canada.
Table with countries and capitals
Country
Capital
Population
Area
Density
GDP
GDP per capita
Antigua and Barbuda Saint John's >97,929 >442 221.4 $1.61 billion $16,476
Bahamas Nassau 393,244 13,943 28.2 $12.16 billion $30,883
Barbados Bridgetown 287,375 430 668.3 $5.20 billion $18,110
United States Washington, D.C. 331,002,651 9,833,520 33.7 $21.43 trillion $64,767
Facts and figures about North America
The largest country in North America by area is Canada, with 9.98 million square kilometers. The smallest country is Saint Kitts and Nevis, with 261 square kilometers.
The most populous country in North America is the United States, with about 331 million people. The least populous country is Montserrat, with about 5 thousand people.
The richest country in North America by GDP per capita is Bermuda, with $117,089. The poorest country is Haiti, with $756.
The highest point in North America is Denali in Alaska, United States, with 6,190 meters above sea level. The lowest point is Death Valley in California, United States, with 86 meters below sea level.
The longest river in North America is the Mississippi-Missouri in the United States, with 6,275 kilometers. The largest lake is Lake Superior in Canada and the United States, with 82,100 square kilometers.
Oceania
Oceania is the smallest and second-least populous continent in the world, with about 43 million people living in 14 countries. It covers about 8.5% of the Earth's land area and consists of thousands of islands scattered across the Pacific Ocean. Oceania has a diverse range of natural resources, cultures, languages, and religions. Oceania is also home to some of the world's most unique and endangered wildlife, such as kangaroos, koalas, kiwis, and coral reefs.
Table with countries and capitals
Country
Capital
Population
Area
Density
GDP
GDP per capita
Australia Canberra 25,499,884 7,741,220 3.3 $1.39 trillion $54,907
Fiji Suva 896,445 18,272 49.1 $5.49 billion $6,131
Kiribati Tarawa 119,449 811 147.3 $0.19 billion $1,588
Tuvalu Funafuti 11,792 26 453.5 $0.05 billion $4,198
Facts and figures about Oceania
The largest country in Oceania by area is Australia, with 7.74 million square kilometers. The smallest country is Nauru, with 21 square kilometers.
The most populous country in Oceania is Australia, with about 25.5 million people. The least populous country is Tuvalu, with about 12 thousand people.
The richest country in Oceania by GDP per capita is Australia, with $54,907. The poorest country is Kiribati, with $1,588.
The highest point in Oceania is Puncak Jaya in Indonesia, with 4,884 meters above sea level. The lowest point is Lake Eyre in Australia, with 15 meters below sea level.
The longest river in Oceania is the Murray-Darling in Australia, with 3,672 kilometers. The largest lake is Lake Eyre in Australia, with 9,500 square kilometers.
South America
South America is the fourth-largest and fifth-most populous continent in the world, with about 430 million people living in 12 countries. It covers about 12% of the Earth's land area and has a diverse range of natural resources, cultures, languages, and religions. South America is also home to some of the world's most spectacular natural wonders, such as the Amazon rainforest, the Andes mountains, and the Galapagos islands.
Table with countries and capitals
Country
Capital
Population
Area
Density
GDP
GDP per capita
Argentina Buenos Aires 45,195,774 2,780,400 16.3 $449.66 billion $9,951
Bolivia Sucre (constitutional), La Paz (administrative) 11,673,021 1,098,581 10.6 $40.90 billion $3,508
Brazil Brasília 212,559,417 8,515,767 24.9 $1.84 trillion $8,717
Venezuela Caracas 28,435,940 916,445 31.0 $70.14 billion $2,471
Facts and figures about South America
The largest country in South America by area is Brazil, with 8.52 million square kilometers. The smallest country is Suriname, with 163,820 square kilometers.
The most populous country in South America is Brazil, with about 212 million people. The least populous country is Suriname, with about 586 thousand people.
The richest country in South America by GDP per capita is Chile, with $14,896. The poorest country is Venezuela, with $2,471.
The highest point in South America is Aconcagua in Argentina, with 6,962 meters above sea level. The lowest point is Laguna del Carbón in Argentina, with 105 meters below sea level.
The longest river in South America is the Amazon in Brazil, Peru, Colombia, Ecuador, Bolivia, and Venezuela, with 6,992 kilometers. The largest lake is Lake Titicaca in Peru and Bolivia, with 8,372 square kilometers.
Conclusion
Summary of the main points
In this article, we have provided you with a free Excel file that contains the list of countries by continent, along with their capitals and other relevant information. We have also given you some facts and figures about each continent and its countries. You can use this data for various purposes, such as learning more about the world's geography and diversity, comparing and contrasting different regions and statistics, preparing for quizzes or tests, creating charts or maps, or satisfying your curiosity.
Call to action to download the Excel file
If you want to download the Excel file with the list of countries by continent, you can do so by clicking on this link: . The file is free and easy to use. You can also share it with your friends or colleagues who might find it useful. We hope you enjoyed this article and learned something new today!
Frequently Asked Questions (FAQs)
Q: How many countries are there in the world?
A: There is no definitive answer to this question, as different sources may have different criteria for defining what constitutes a country. However, one widely accepted source is the United Nations (UN), which currently has 193 member states and two observer states (the Holy See and Palestine). Therefore, according to the UN, there are 195 countries in the world as of 2020.
Q: How many continents are there in the world?
A: There is also no definitive answer to this question, as different sources may have different ways of classifying the continents. However, one common model is the seven-continent model, which divides the world into Asia, Africa, North America, South America, Europe, Oceania (or Australia), and Antarctica. Some countries use other models, such as the six-continent model that combines Europe and Asia into Eurasia, or the five-continent model that excludes Antarctica. In this article, we have followed the seven-continent model.
Q: What is the difference between a country and a state?
A: A country is a political entity that has sovereignty over its territory and population. A state is a political subdivision of a country that has some degree of autonomy and self-government. For example, the United States is a country that consists of 50 states, such as California, Texas, and New York. However, some countries are also called states, such as the State of Israel or the State of Qatar. This can cause some confusion, but it does not change the fact that they are sovereign countries.
Q: What is the difference between a capital and a largest city?
A: A capital is the city where the government of a country or a state is located. A largest city is the city that has the most population in a country or a state. Sometimes, the capital and the largest city are the same, such as Tokyo in Japan or Paris in France. However, sometimes they are different, such as Canberra and Sydney in Australia or Brasília and São Paulo in Brazil.
Q: What is the difference between GDP and GDP per capita?
A: GDP stands for gross domestic product, which is the total value of all the goods and services produced in a country or a region in a given year. GDP per capita is the GDP divided by the population, which gives an average measure of the income or wealth of each person in a country or a region. GDP per capita is often used as an indicator of the standard of living or the economic development of a country or a region.
44f88ac181