top of page
  • eswasilcoacransoi

Excel Data Types: How to Convert Text to Geography and Get Countries and Continents Information



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


2 views0 comments

Recent Posts

See All

Comments


bottom of page