Have you ever wondered how much of the world you've actually seen? A countries visited tracker answers that in seconds. Type in the states, countries, and cities you've visited, and this Google Sheets travel tracker colors in a map of everywhere you've been, counts your top destinations, and shows the percent of the world you've traveled.
In this guide, I'll walk you through how to use the Palm & Grace Travel Tracker Spreadsheet for Google Sheets, step by step, plus a few travel goal ideas to track. Prefer to watch? The full video tutorial is right below.
Want to follow along? Grab the Travel Tracker Spreadsheet and fill in your own travels as you read.
In this guide
What's inside the travel tracker
The spreadsheet has four tabs for tracking where you've been:
- Places Traveled – track the states and countries you've visited
- By Year Places Traveled – see your states and countries for any single year
- Places Traveled With Cities – everything above, plus the cities you've visited
- By Year Places Traveled With Cities – your states, countries, and cities for any single year
Together they include 8+ fully automated charts, including map charts that color in each place as you add it. There's nothing to calculate yourself.
How to track your travels in Google Sheets
Step 1: Decide whether you want to track cities
Before you start, decide whether you only want to track states and countries, or cities too.
- States and countries only? Use the Places Traveled tab.
- Cities too? Use the Places Traveled With Cities tab.

Step 2: Add the states and countries you've visited
The center of the tab is where you enter your travels. As you add places, the maps and charts update on their own.
- To add a state, type the state's name, then the year you visited (optional).
- To add a country, first choose its continent from the dropdown, then type the country's name and the year (optional).

Tip: Spelling matters. Make sure each state, country, and city is spelled correctly so the maps can find it. The year is optional, but add it if you'd like to use the By Year tabs later.
Step 3: Explore your maps and stats
Once a few places are in, the fun part starts. At the top, you'll see how many of the world's 195 countries you've visited and what percent that is, plus the same count for states. A states visited map and a countries visited map shade in every place you've been.

In the left sidebar, you can:
- Search any state or country to see how many times you've visited it
- See your travel by continent in a pie chart
- View your top states and top countries, including your top countries on each continent

Scroll to the right and you'll find a map for each continent, showing the countries you've visited there.

See your travels on a map
8+ automated charts and maps that color in every state, country, and city you've been to. Just type and watch it fill in.
Step 4: Look back at a single year
The By Year Places Traveled tab shows just one year at a time. Choose a year from the dropdown, and every map and chart updates to show only the places you visited that year. It makes a fun year-in-review at the end of December.

Step 5: Track the cities you've visited
The Places Traveled With Cities tab works the same way for states and countries, and it has four maps instead of two.
- US cities: type the city name, then its state. Adding the state matters because some cities share a name, like Springfield.
- Cities around the world: type the city name, then its country, like Lima, Peru. If a country has two cities with the same name, you can include the state or region too.


Just like the other tab, there's a By Year version of the cities tab, so you can see every city you visited in a given year.
Why use a spreadsheet instead of an app?
There are plenty of countries visited apps, so why a spreadsheet? Your travel history lives in your own Google Drive, there's no extra app or subscription, and you can add notes, years, and cities however you like. It's a one-time purchase, and the maps and stats update automatically.
Good to know before you start
- Spelling counts. The maps match place names exactly, so a typo can keep a place from showing up.
- A few map limits come from Google Sheets. For example, regions within some countries (like Australia's states) can't be mapped, and there's no map for Antarctica. You'll still get plenty of charts and stats.
- It works best on a computer. You can use it on a tablet or phone, but a desktop is easiest for entering places.
Travel goal ideas to track
A travel tracker is even more fun with a goal in mind. A few ideas:
- Visit all 50 US states. Watch the US map fill in, state by state.
- See every continent, or at least six of the seven.
- Visit a new country every year, and use the By Year tab to check off each one.
- Explore your home state by tracking the cities and towns you visit.
- Hit a number by a birthday, like 30 countries by 30.
Planning the next trip? The Travel Planner Spreadsheet keeps your bookings, budget, and packing in one place, and the Travel Itinerary Templates help you map out each day.
Shopping for a traveler this holiday season? A travel tracker makes a thoughtful gift for anyone who loves to explore. You can also give a Palm & Grace gift card and let them choose.
Frequently asked questions
How many countries have I been to?
Add each country you've visited to the Places Traveled tab, and the tracker counts them for you. The top of the tab shows your total out of the world's 195 countries and the percent you've seen, along with a map of every country you've been to.
Can I track cities as well as states and countries?
Yes. Use the Places Traveled With Cities tab to track US cities and cities around the world, each with their own map.
Do I have to enter the year I visited?
No, the year is optional. Add it only if you'd like to see your travels by year.
How does it work out the percent of the world I've traveled?
It counts the countries you've entered out of 195 countries and shows the number and percent at the top of the tab, updating as you go.
Does it work in Excel?
No, it's made for Google Sheets only. It works on desktop, tablet, and mobile, and works best on a desktop computer.
Is it part of a bundle?
Yes. The Travel Tracker is included in the Travel Spreadsheet Bundle at a discounted price, and in the Travel Agent Planner.
Start mapping your travels
Whether you've been to five states or fifty countries, seeing it all on a map is a great way to remember your trips and plan where to go next. I hope this helps you celebrate how far you've come.
Travel Tracker Spreadsheet Template for Google Sheets
Instant access after purchase. Track states, countries, and cities with automated maps.
Have questions about setting it up? Reach out anytime. I'm always happy to help!

