Category: mapping

Starting from scratch is hard. There’s a reason Betty Crocker cake mix flies off supermarket shelves: to save you time and help you get started. The same should be said about your favorite internet tools. This is where templates can come in handy, especially for things you find yourself repeating more than once, like making a spreadsheet of customers, identifying the locations of your leads, and mapping your geographic data.

Our Excel spreadsheet template points you in the right direction on your mapping journey, ensuring your data is perfectly formatted for our mapping tool. Of course, you’ll want to replace the location data (address, city, state, and ZIP) with your own. But the template even contains suggestions on how to organize any additional data like phone number, group, URL, and email for your custom map.

Spreadsheet Template Basics: Location

You can download the Excel spreadsheet template or copy and paste it into the spreadsheet tool of your choice (like Google Sheets). Upon opening up the template, you’ll note the first four columns are entirely dedicated to location data.

These key fields include:

• Address
• City
• State
• Zipcode

You’ll want to replace the template data with your own—copy (Ctrl+C or Cmd+C) and paste (Ctrl+V or Cmd+V) it in.

However, don’t feel obligated to fill in everything; not all the address fields are required. Most mapping tools can accurately plot your points with just one location detail, though the more you have, the more accurate your geocoding will be. You can delete entire unwanted columns from the template by right-clicking the column letter and opting for “Delete.”

As you’ll also note in the template, it’s best if each part of the location has its own column. For example, if your data is in the form of 1 Crossgates Mall Road Albany, NY 12203, most tools will do their best to interpret it. However, you can separate it into individual columns to be explicit, which reduces errors. To learn how to do that, see our article Simplify Complicated Data in Excel. Otherwise, continue on for how to use the template to prepare your data for mapping.

Include Your Location’s Name

Column E of the template is the name of your places that people will recognize. That way you don’t have to remember locations by their address. You’ll be able to use this information later to identify your locations on your map. For example, you could put a customer name or company name in this field.

You can copy (Ctrl+C or Cmd+C) and paste (Ctrl+V or Cmd+V) your own location names in place of the examples. The name of your location(s) is the last of the essential info you’ll need, though there is still some information that’s extremely helpful to have.

Add or Delete Additional Information

In addition to the necessary information about your locations, there’s additional data you may wish to include. Some suggested options are included in the template, such as:

• Phone number
• Group
• URL
• Email
• Deal value
• Sales volume

You can easily remove ones you don’t need by right-clicking the column letter and selecting “Delete.” You can also add your own columns to the spreadsheet (right-click → Insert). Say, Store Manage or whatever suits your data.

What happens to this additional data on your map? In addition to appearing in the info window, you’ll be able to group and filter what’s visible by any of your data once you make your map.

Make Your Custom Map

By using the Excel spreadsheet template, you’ve avoided starting from scratch, saving you ample time. Your spreadsheet is now perfectly primed to make a custom map just like the one below.

View Apple Stores Example in a full screen map

You can follow the simple steps below to make your own:

1. Open your spreadsheet
2. Select (Ctrl+A or Cmd+A) and copy (Ctrl+C or Cmd+C) your data
3. Open your web browser and navigate to batchgeo.com
4. Click on the location data box with the example data in it, then paste (Ctrl+V or Cmd+V) your own data
5. Check to make sure you have the proper location data columns available by clicking “Validate and Set Options”
6. Select the proper location column from each drop-down
7. Click “Make Map” and watch as the geocoder performs its process

Find our Excel spreadsheet template on the homepage. You can refer to it each time you want to make a new map to ensure you’re on the right track.

Now that you know how to manipulate the template for your use, turn your own data into a customizable map with our spreadsheet template today.

London, Paris, and Los Angeles don’t have much in common. The three cities are many miles apart (London to Paris is 214 miles, London to L.A. is 5,440 miles, and L.A. to Paris a bit more.) They have different cultures and traditions. But one thing the cities do have in common is the number of times they’ve hosted the Olympic Games.

Fans flock to host cities to watch live as top athletes from hundreds of countries compete in the events. More than entertainment and the chance for athletes to get awarded for their skills (Olympics Prize Money: Do Olympians Get Paid?), the Games offer host cities a unique tourism opportunity, with millions of new visitors in need of lodging, food, etc.

But not every city has the capacity to host the Olympics. The cities that do must have large enough stadiums and a climate well-suited for seasonal sports.

So which are the most frequent Olympic host cities and countries? The map below holds the answers.

View Olympics Hosts in a full screen map

Most Frequent Olympic Host Cities

To start, let’s look at the cities with the most Olympic hosting under their belt. By this point, some of these cities should get a gold medal in hosting.

City	Number of Olympics hosted
Paris, France	3
Los Angeles, U.S.	3
London, U.K.	3
St. Moritz, Switzerland	2
Lake Placid, U.S.	2
Innsbruck, Austria	2
Beijing, China	2
Athens, Greece	2

London, Paris, and Los Angeles are the only cities in the world that have hosted the Olympic Games three times. All of the Games hosted in London were the summer version, first in 1908, again in 1948, and most recently in 2012.

Like London, Paris’ stints as host have all been for the Summer Games, the first of which occurred in 1900. After that, Olympic athletes returned to City of Light in 1924 and they’ll do so again in 2024.

As for Los Angeles, California, the city first hosted the Summer Olympics in 1932. Los Angeles hosted the Games once again in the summer of 1984 and L.A. is also set to host the 2028 Summer Games.

But Los Angeles isn’t the only U.S. city to host the Olympics multiple times. While not thrice, Lake Placid, New York has twice played host to the Winter Games, making the U.S. the only country in the world to have two cities hosting more than once each. In addition to Lake Placid, Athens (Summer), Beijing (Summer and Winter Games), Innsbruck (Winter), and St. Moritz (Winter) have each hosted the Games twice.

Now let’s take a look at the bigger picture: countries.

Most Frequent Olympic Host Countries

Cities aside, which countries have hosted the most games?

• United States: 9
• France: 6
• Italy: 4
• United Kingdom: 3
• Japan: 3
• Canada: 3
• Australia: 3

The U.S. has hosted the most Olympic Games of all other countries. Aside from the previously mentioned multi-host cities of Los Angeles and Lake Placid, other host cities include Atlanta, Palisades Tahoe (formerly Squaw Valley in California), and St. Louis. Plus, the last Olympics in USA was held in Salt Lake City in 2002. As for when will the Olympics be in the US next, L.A. will once again welcome Olympic enthusiasts in 2028.

In addition to the countries above, Austria, China, Germany, Greece, Norway, South Korea, and Switzerland have each hosted the Games twice.

Both in Beijing: Seasonal Games Hosts

As for which countries have hosted both the Summer and Winter Games: You may think of Canada as a winter-only wonderland, but the country has not only hosted two Winter Olympics (in Calgary in 1988 and Vancouver in 2010) but one summer version in Montreal in 1976.

And while Paris may have been the site of three summer games, Albertville, Chamonix, and Grenoble, France have each hosted the Winter Games in 1992, ’24, and ’68.

Other countries to host the Olympic Games for both seasons include Germany (Berlin in the summer of ’36 and Garmisch-Partenkirchen in the winter of the same year).

Plus, West Germany’s Munich hosted the Summer Games in 1972.

Italy, Japan, South Korea, the U.S., and China also have similar dual-season hosting backgrounds. Speaking of China, Beijing is the only city to have hosted both the summer (2008) and winter (2022) versions of the Olympics.

For more on the games this Olympic season, check out Every Country’s Olympic Wins (& Losses) or The 500 Largest Stadiums in the World, which includes at least 19 Olympic structures.

At any competition, whether it be a spelling bee, chess tournament, or wrestling match, the intent is to win. Very few spend hours practicing their craft with the hopes of being second-best.

Of course, when it comes to the Olympic Games, that desire increases ten-fold, both from the athlete and their team. Every country from Argentina to Zimbabwe has the same goal: go for gold. In total, 150 countries have succeeded in winning at least one medal at the Summer or Winter Games, though many have placed at the top multiple times. Take a look at the map to see how many gold, silver, and bronze all-time Olympic medals each country has accumulated throughout their years participating in the Olympic Games.

View Every Country’s Olympic Wins in a full screen map

The data displayed on the is from the All-time Olympic Games medal table in Wikipedia. Sort it by one of the groups or read on to uncover the most successful countries overall, the top gold, silver, and bronze, and the 76 countries without Olympic medals.

Most Successful Countries at the Olympic Games

While everyone dreams of winning Olympic gold, at this level of athletics a second-place silver medal or bronze for third is nothing to sniff at. So let’s take a look at the top 10 most successful countries at the Olympic games, all of which have earned at least 500 medals apiece.

1. United States: 2,980 Olympic medals
2. Soviet Union: 1,204
3. Great Britain: 948
4. Germany: 892
5. France: 874
6. Italy: 742
7. China: 696
8. Sweden: 661
9. Australia: 562
10. Japan: 555

At just under 3,000 total gold, silver, and bronze medals at the time of writing, the U.S. comes out on top of Olympic wins. Of the 2,980 medals, 2,673 were won during the Summer Olympics, the most medals of all Summer Games participants. That leaves 307 from the Games that take place in the Winter, second-most to Norway. Most impressively, to answer how many gold medals does the US have, 1,180 are gold, while silver adds up to 959 and bronze: 841.

The Soviet Union’s 1,204 total medals can be broken down into 473 gold, 376 silver, and 355 bronze. This is impressive for a nation that only competed in the Olympic Games 18 times between ​​1952–1988 before it disbanded. What was previously included in the Soviet Union team now participates in the Olympics as 15 individual countries.

Then there’s Great Britain. It’s the first top 10 team to have won more bronze and silver medals than gold. The country has won 332 bronze, 320 silver, and 296 gold. Of course, Great Britain has the benefit of many territories. They can choose athletes from England, Northern Ireland, Scotland, and Wales. Athletes from Guernsey, Isle of Man, and Jersey and 11 territories like Anguilla, Gibraltar, and Turks and Caicos Islands can also represent them.

Just narrowly missing the top 10: Russia with 547 medals, although if you combined them with the Soviet Union’s wins, it would be far greater (though still not surpassing the U.S.) With the top winners (and Russia) in mind, let’s answer some questions about participation.

Most Participating Places

Now, how do practice and opportunity affect an Olympic outcome? Let’s see if the most successful countries at the Olympic games like the U.S., Soviet Union, and Great Britain are those that have participated the most.

• United States (307 Olympic Games in total)
• Great Britain (52)
• France (52)

Summer vs Winter

Breaking it down by Summer vs. Winter Games, 12 countries have participated 23 times in the Winter Games, including Norway and the U.S. As for which country has won the most winter Olympic medals? Norway beats out every other country with a total of 368. It seems those freezing temperatures and a constant blanket of snow have come in handy.

Of Norway’s medals, 132 are gold (the most gold medals of all Winter Games participants). Norway also takes the cake for the most silver Winter medals (125) and most bronze (111). That just leaves the less athletically-inclined countries without a single medal.

Countries Without Olympic Medals

Several countries have only a single Olympic medal to their name (sort the map by Total to see for yourself). But then there are those without even one medal to call their own.

Of the 76 medal-less countries out there, many have tried multiple times (some more than 20!) to place at the games. The countries without medals with most attempts include:

• Monaco – 31-time Olympic Games participant
• Andorra – 24
• Bolivia – 21

In addition to these three countries with more than 20 tries, Malta, Myanmar, Nepal, Bosnia and Herzegovina, and Madagascar have each attempted to win a medal at the Olympics at least 15 times.

---

For more on the Olympics, be sure to check out how much Olympians get paid. Plus, our post on the world’s 500 Largest Stadiums includes the 40,000 max capacity Wuhu Olympic Stadium.