Offbeat Travelling

Fascinating travel adventures in 'difficult' countries

  • Destinations
    • Africa
    • Balkans
    • Middle East
    • Post-Soviet
    • Other destinations
  • Latest Posts
  • Photos
  • About
  • Contact
  • More…
    • Publications
    • Travel Tips
    • Countries spreadsheet
Home Inspiration

March 3, 2022

Counting Countries like a Pro with This Awesome Excel Spreadsheet

Top
Counting countries globe
495
SHARES
ShareTweet
[wysija_form id="4"]

How many countries are there in the world? The answer to this simple question is more complicated than most people think. Throughout the years I have seen travellers, organisations and governments all use different definitions, ranging from 193 up to well over 200. So I spent a lot of time creating a countries spreadsheet to explain the differences.

With over 50 hours of research it shows a compiled list of 361 countries, de facto states, regions, territories and unrecognised states. Each of those is categorised to show who is counting which: from the United Nations and FIFA to the world’s most elite travel clubs.

With this spreadsheet (version 8.0 already!) you can therefore start counting countries like a pro. It offers full transparency and you can modify it yourself any way you want. If you cannot wait to start, head straight for that download button below. If you are eager for some context, then keep reading.

Download the spreadsheet (.xlsx) here!

UN member states

The generally accepted minimum number of countries in the world is derived from the United Nations member states, of which there are 193. Many travellers use this definition as a baseline when counting countries.

Travelling to all countries is EXTREMELY HARD. There are only about 260 people in the world who claim to have visited them all. They are listed as so-called UN Masters on Nomad Mania, a global authority and well organised community of travellers counting countries.

More people have been to outer space than have (really) travelled to every country in the world

Chances are though that some of those people may not qualify because certain visits (1) cannot be verified or (2) are only counted as a minimum visit. A common phenomena is travellers ‘stepping’ from South Korea into North Korea inside a cabin in the demilitarised zone. Others might count a country simply when catching a connecting flight inside an airport. Also, to set a Guinness World Record there is no need to visit Syria. Simply stepping into the Golan Heights (controlled by Israel) is apparently enough.

One thing is for sure. More people have been to outer space than have (really) travelled to every country in the world!

Korea Demilitarised Zone
Me posing with a South Korean soldier inside a cabin within the demilitarised zone with North Korea. Personally I do not count this as a visit to North Korea.

Going beyond UN

Despite the UN members being a rather clear-cut definition, there are a lot of travellers who use a wider definition on travelling to countries. Palestine and Vatican city for example (both non-member UN observer states) are often counted as well. Adding the disputed territories of Taiwan, Western Sahara and Kosovo brings the total figure of ‘countries’ in the world to 198.

READ MORE: I Got Arrested by the KGB in a Country That Doesn’t Officially Exist

But it does not end there. According to my own spreadsheet there are numerous of disputed and contested regions in the world. Abkhazia, Transnistria, Tibet, Northern Cyprus and Kashmir are just a few mentioned there. This way you can easily reach over 210.

Counting countries

Then there is a wide range of institutions all using different methods to count countries and territories. A brief yet non-exhaustive overview:

  • NomadMania created a UN+ list with 266 countries and territories. It adds de facto countries that are not officially recognised as sovereign, as well as autonomous territories such as Hong Kong and Gibraltar.
  • The British Foreign and Commonwealth office says there are 226 countries or territories in the world
  • The elite Traveler’s Century Club keeps a list of 330 countries and territories in the world that are worth visiting
  • FIFA recognises 211 national associations (of which 26 are no UN member states)
  • The ISO 3166 country code standard lists a total of 249 countries
  • Travel apps, bloggers and map apps usually list anywhere between 195 and 303 countries, territories and places

This is where it gets complicated. Different lists might not only use different definitions, some also use different names for similar countries. This way, mapping the differences between the definitions becomes a real puzzle.

NomadMania

The world according to NM in 1301 regions (“big enough to be challenging, small enough to be achievable”)

Finally there is NomadMania (formerly known as The Best Travelled), an awesome website home to the mother of all travel lists. NM divides the world into 27 mega-regions and subsequently into 1301 regions to visit. No one has ever travelled to all of them, yet there are about twenty people who reached over a 1000(!).

To save myself a lot of hassle I did not include the NM list in the Excel sheet. If you want to learn more about these definitions, then just head over to that website and sign up for a member account!

Start counting like a pro

I hope I got you excited to start counting your visited countries like a pro. Just download my Excel spreadsheet through this link, preferably using a laptop or computer to avoid errors. Read the instructions as you go through the different worksheets in the file.

If you liked this article please leave a reply and share it with your travelling buddies! How many countries have you been? Which definition do you like most?

495
SHARES
ShareTweet
[wysija_form id="4"]
Previous ArticleYear in Review: revisiting Iraq and other exciting places in 2021

Also Popular on the Blog:

  • The longest distance overland in a straight line is 13,589 kilometers long and crosses 18 countries and territories in 9 different time zones.The Longest Overland Route in a Straight Line
  • ChristianiaChristiania: An Obscure, Self-Proclaimed Micronation in the Heart of Copenhagen

Newsletter

Never miss a thing!

Here is the best way to stay connected:

Make a selection, hit subscribe and confirm through the link in your mailbox! Check your spam folder if cannot find it.

Your data is safe. By subscribing you agree with my privacy policy. You can unsubscribe anytime. No spam, I promise!

WAIT! Almost done! Check your inbox (or spam folder) now to confirm your subscription. Don't forget or you will still be missing out!

About Bart

"My name is Bart and I travel to some of the world’s most fascinating places"

Follow me on my social media pages (below) if you want to tag along!

  • Facebook
  • Instagram
  • Twitter
  • YouTube

Top Posts & Pages

  • The Longest Overland Route in a Straight Line
  • 12 Kick-Ass Route Ideas to Travel the World
  • I Watched The Bizarre India Pakistan Border Closing Ceremony
  • Riding the Iron Ore Train across the Sahara in Mauritania
  • 11-day Travel Itinerary for Iraqi Kurdistan (and Epic Photos)

Instagram

I’m stepping out of the spot light! It’s bee I’m stepping out of the spot light! 

It’s been a wonderful and eventful three months of travelling around Africa and Saudi Arabia and a pleasure to share it all with you guys! But it’s time to get back to normal (working) life again, so that’s why I’m posting this from the comforts of my home in the Netherlands.

I might create some reels of my past adventures, but the pace of me using social media will drop significantly. As you might know, I don’t use Instagram that much when I’m not travelling. So the moment I will, you will be the first to know! 

Thanks all once again for following me and tagging along on my journeys around the world!

.
.
.

#travel #instatravel #fuji_travel #wanderlust #picoftheday #travelphotography #exploretheworld #worldtraveller #everycountry #everypassportstamp #beautifuldestinations #traveldestination #backpacker #solotravel #adventure #adventuretravel #natgeotravel #passionpassport #nomadmania #aroundtheworld #jeddah #visitsaudiarabia #saudiarabia
What a great party at the 2023 Grand Prix Formula What a great party at the 2023 Grand Prix Formula One in Jeddah!

.
.
#swedishhousemafia #saudiarabiangp #concert #performance #dj #visitsaudi #jeddah #travel #party #mood #disco #edm #dancemusic #electronicmusic #holiday #grandprix #saudiarabia #shm #mdlbeast #formula1jeddah
Saudi Arabia 🇸🇦 in 2023 Travelling to Saudi Saudi Arabia 🇸🇦 in 2023

Travelling to Saudi Arabia all by yourself? No tour guides or sponsored trips? Totally possible! I hired a car and drove 3.000 km from Riyadh to Jeddah!

.
.
.

#adventure #tourism #visitsaudiarabia #travel #travelblogger #wanderlust #worldtrip #aroundtheworldpics
Wealth is not measured by how much money you have. Wealth is not measured by how much money you have. Neither by how much you travelled and the experiences you gathered. It’s determined by the number of camels you own.

How many camels do you have?

#camelmarket #saudiarabia #visitsaudi #visitsaudiarabia #market #animals #souq #travel #instatravel #fuji_travel #wanderlust #picoftheday #travelphotography #exploretheworld #worldtraveller #everycountry #everypassportstamp #beautifuldestinations #traveldestination #backpacker #solotravel #adventure #adventuretravel #natgeotravel #passionpassport #nomadmania #aroundtheworld
Where the road ends, is where the adventure starts Where the road ends, is where the adventure starts.

#saudiarabia #visitsaudi #visitsaudiarabia #independenttravel #tourist #travel #instatravel #fuji_travel #wanderlust #picoftheday #travelphotography #exploretheworld #worldtraveller #everycountry #everypassportstamp #beautifuldestinations #traveldestination #backpacker #solotravel #adventure #adventuretravel #natgeotravel #passionpassport #nomadmania #aroundtheworld #travelquotes
Is it safe to travel in West and Central Africa? W Is it safe to travel in West and Central Africa? Well, after two months travelling using public transport I came a long way and made it to my final destination!

Yes, I did get malaria twice and road transport is not always the safest. But never did I encounter crime, hate, violence, etc. Just smiles and curiosity.

It’s been mostly solitary travel though. I did not meet many other like-minded people on the road. In these regions, solo travel really means solo. Eating out alone almost every day. Going on hikes all by yourself. Staying in a hospital without anyone visiting you. Always paying for a double room by yourself.

But in the end, my two months here have been full of nice and memorable encounters. The tea guy at the bus station, selling amazing ginger lemon tea. The Ghanian woman who crossed the border into Togo with me. The young boy selling ice cream for absolutely no money. The local kid who offered me water when I was totally thirsty.

Soon I will leave this continent once again, but for sure the continent will not leave me. I’ll be back!

#ghana #togo #benin #saotome #gabon #cameroon #westafrica #centralafrica #africa #travel #instatravel #selfie #wanderlust #picoftheday #travelphotography #exploretheworld #worldtraveller #everycountry #everypassportstamp #beautifuldestinations #traveldestination #backpacker #solotravel #adventure #adventuretravel #natgeotravel #passionpassport #nomadmania #aroundtheworld #peoplephotography
São Tomé and the iconic Cão Grande. I guess you São Tomé and the iconic Cão Grande. I guess you all liked this photo from my stories, so why not post it here as well?

Have you been to Sao Tome? Did you do a self drive like me, on a motor? Or by car? With a guide? Let me know how you travelled around the island so others can read and learn about the different options! 

#saotome #paradiseisland #paradise #mountain #island #principe #saotomeprincipe #travel #instatravel #fuji_travel #wanderlust #picoftheday #travelphotography #exploretheworld #worldtraveller #everycountry #everypassportstamp #beautifuldestinations #traveldestination #backpacker #solotravel #adventure #adventuretravel #natgeotravel #passionpassport #nomadmania #aroundtheworld
People of Togo ❤️ #travel #instatravel #iphon People of Togo ❤️

#travel #instatravel #iphone11 #apple #iphonephotography #africa #westafrica #facesofafrica #humans #humansofafrica #wanderlust #picoftheday #travelphotography #exploretheworld #worldtraveller #everycountry #everypassportstamp #beautifuldestinations #traveldestination #backpacker #solotravel #adventure #adventuretravel #natgeotravel #passionpassport #nomadmania #aroundtheworld
Follow on Instagram

© 2016–2023 Offbeat Travelling - All rights reserved PRIVACY POLICY | COPYRIGHT | CONTACT