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

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.

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

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.

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.

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.

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.

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.

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.

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.

• World Countries (Excel File)
• World Countries (Excel File) – Stored in Table Object
• World Countries (PowerPoint File)
• World Countries (Microsoft Word File)
• World Countries (CSV File)
• World Countries (Text File)

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!

Format Excel Charts Like a Pro!!!

Learn my best Excel chart design hacks. These will turn your ugly charts into professionally crafted graphics, leaving your boss speechless!!!

Get These Hacks Now For Free!

Keep Learning

Explore more →

Pull Historical Stock Price Data in Excel

Get Stock Price History Directly From Excel! Stock Prices used to be a hassle to pull into Excel. I can...

Free Example Data Sets For Spreadsheets [Instant Download]

Spreadsheet Sample Data in Excel & CSV Formats I have put this page together to provide everyone with data that...

A Guru State Of Mind

I Finally Did It! I’ve thought long and hard about what epic topic I would cover for my very first...

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.