Author: Adam DuVander

Mapping the Most Electricity Use by Country

Understanding the world’s electricity consumption can be a daunting task. However, here at BatchGeo, we find that maps make it easier to view lots of information all at once. This map is helpful in getting a sense of which country uses the most electricity, and if there are any geographical reasons for why that may be. Where do world leaders like China, the U.S., and Canada fall when it comes to how much electricity they use, and how do the rest of the 219 countries on our list stack up? The map below holds all of that information, and more.

View Most Electricity Use by Country Map in a full screen map

Check out your country’s electricity consumption versus the competition on the map above, or read on for insights into the world’s electricity use.

Most Electricity-Consuming Countries

Rank Country/Region Electricity consumption (kW·h/yr)
1 China 5,920,000,000,000
2 United States 3,911,000,000,000
3 India 1,408,624,400,000
4 Russia 1,065,000,000,000
5 Japan 934,000,000,000
6 Germany 533,000,000,000
7 Canada 528,000,000,000
8 Brazil 518,000,000,000
9 South Korea 495,000,000,000
10 France 431,000,000,000

China, the world’s number one most electricity-consuming country, uses a whopping 5,920,000,000,000 Kilowatt hours per year. Now that’s a lot of zeros! The electricity-monopolizing country also has the highest population of all of the countries on our list with 1,373,541,000 people, and those people are all in need of electricity, so the high number makes sense. Before 2011, the United States actually used up the most electricity per year, but China surpassed the U.S. after steadily growing from the 1990s onward. Most of China’s electricity comes from coal, as the country happens to be the largest producer and consumer of coal in the world.

While China may have passed the U.S. in electricity consumption, the U.S. is still the second-largest electricity-consumer in the world. Most of the U.S.’s electricity comes from natural gas, which is used to heat water for steam. Just like China, the U.S. also has lots of people who need electricity with a population of 323,995,528, the third highest populated country on our list. Another factor in the U.S.’s extensive electricity use may be the U.S.’s love of cars. Electric fuel pumps, cooling fans, starters, and power steering all use up electricity, and seeing as over 360 U.S. cities have a drive alone percentage of over fifty percent that may be a large contributing factor to its second-place status.

Least Electricity-Consuming Countries

Photo by NOAA Photo Library

The first and second place titles for the least electricity-consuming countries belong to the Northern Mariana Islands and the Gaza Strip respectively.

The Northern Mariana Islands are located in the northwest Pacific Ocean and consist of 15 islands in total. With a combined total population of 53,467, these small islands come in at #219 on our list of electricity consumers, only consuming a mere 48,300 Kilowatt hours per year. Compare that to our number one electricity consumer, China, and the Northern Mariana Islands’ 48,300 kW·h/yr is over 120,000,000 times less than China’s thirteen figure number of 5,920,000,000,000 kW·h/yr.

The Northern Mariana Islands import nearly all of their largest energy source: petroleum, which fuels the islands’ electric plants. The islands have no reserves of their own. Because the cost of petroleum changes in accordance with the world’s diesel fuel price, the price of electricity in the Northern Mariana Islands is between three to four times higher than the price of electricity in the U.S. Due to the high cost of running electric plants in the Northern Mariana Islands, many big-ticket businesses such as hotels have generators and use them make their own electricity, especially when diesel fuel prices skyrocket worldwide.

The Gaza Strip, the second least electricity consumer worldwide, or #218 on our list consumes only 202,000 Kilowatt hours per year, which is the second and last electricity consumption under six digits. The Gaza Strip, with a population of 1,753,327, has a tumultuous history when it comes to accessing electricity, and in 2017 many residents were lucky to get four hours of electricity a day.

Gaza’s issues with accessing electricity began in 1967 with the Arab-Israeli War, which left Gaza under the control of Israel. Until 1993, Israel provided the Strip with electricity, but upon removal of Israeli forces in 2005, Gaza was left with an only sometimes functioning power plant and a fast-rising population. Gaza’s one and only power plant was bombed repeatedly by Israel in 2006, 2008, and again in 2009. Only about 60 percent of Gaza’s population has intermittent electricity while the other 40 percent are forced to completely forgo what some may deem a necessity for daily life. To this day, hospitals in Gaza are unable to function fully.

Highest Electricity Usage Per Capita

Rank: Electricity Usage Per Capita Country/Region Population Average energy per capita (kWh per person per year) Electricity consumption (kW·h/yr)
1 Iceland 335,878 50,613 17,000,000,000
2 Liechtenstein 37,937 35,848 1,360,000,000
3 Norway 5,265,158 24,006 126,400,000,000
4 Kuwait 2,832,776 19,062 54,000,000,000
5 Bahrain 1,378,904 18,130 25,000,000,000
6 United Arab Emirates 5,927,482 16,195 96,000,000,000
7 Qatar 2,258,283 15,055 34,000,000,000
8 Canada 35,362,905 14,930 528,000,000,000
9 Finland 5,498,211 14,732 81,000,000,000
10 Sweden 9,880,604 12,853 127,000,000,000

While China, the United States, and the rest of the top ten electricity-consuming countries of the world may need to start rethinking how much electricity they use, both China and the U.S.’s electricity usages aren’t as unbelievable if we look at electricity consumption per capita. With population size taken into account, China actually moves from #1 to #64 on our list and the U.S. just narrowly misses being in the top ten with its #11 spot.

However, one country ends up in the top ten electricity-consuming countries with or without a noted population size. Canada is in the top ten for both overall electricity consumption and electricity consumption per capita.

Lowest Electricity Usage Per Capita

While we saw the #1 electricity-consuming country move all the way down to #64 when population size was added to the equation, not much changes for the lowest electricity consumers. Once again, both the Gaza Strip and the Northern Mariana Islands are the lowest of the low when it comes to electricity consumption, even once population is noted.

However, there is one slight change. Per capita, the Northern Mariana Islands move down from the lowest electricity-consuming country to the second-lowest electricity-consuming country. With population size taken into account, Gaza wins the title of least-electricity consuming country. The Northern Mariana Islands may have a much smaller population of 53,467 than the Gaza Strip, which has a population of 1,753,327, (nearly 33 times larger than the Northern Mariana Islands), but the islands don’t struggle with political issues impacting their power plants like Gaza does. The Northern Mariana Islands’ small population size and subsequent lower electricity usage explain why they were #219 for overall electricity-consumption, but compared to Gaza’s significantly larger population size, and their relatively similar electricity usage, Gaza comes out as using less electricity per capita.


How did your country come out in terms of electricity consumption? If you feel like turning off all of your lights and unplugging your computer charger after seeing just how high those electricity numbers went, we don’t blame you. Hopefully, your computer is charged enough that you can make your own interactive map like this one with BatchGeo.

If not, you can also get your map data to go on any iPhone or iPad.

FIFA World Cup Finals Winners and Runners Up

With the 2018 FIFA World Cup Final upon us, we thought we’d take a look at World Cup Final’s past. This year, the final soccer match will be held for the first time at Luzhniki Stadium in Moscow, Russia. However, while this is Russia’s first time hosting the World Cup Final, there are some countries that have been hosts multiple times. Find out which countries have hosted the final multiple times, which stadiums have attracted the largest audiences, and most importantly, which national team has won the most cups. Discover the World Cup’s past before you tune in to watch the 21st FIFA World Cup Final, which we hear is going to be quite the matchup.

View FIFA World Cup Winners & Runners Up in a full screen map

Check out the map above to get a sense of which national teams have won the World Cup time and time again, and which teams just can’t beat the runners-up status, or read on for more insights into FIFA World Cup history.

Goooaaal: World Cup’s Top Winners

Of the 20 World Cup tournaments that have been played since 1930, only eight national teams have won the coveted cup. Of those eight World Cup holders, only three have more than three wins.

National team Wins Years won
Brazil 5 1958,  1962,  1970,  1994,  2002
Germany 4 1954,  1974,  1990,  2014
Italy 4 1934,  1938,  1982,  2006

As you can see, Brazil is the ultimate champion with five World Cup wins. Brazil’s first two wins were in consecutive World Cups in 1958 and immediately after in 1962. In addition to Brazil’s five wins, the team has also been runner-up in two final matches, the first in 1950 and again in 1998. In total, Brazil has played in seven World Cup finals.

Germany and Italy have both been World Cup champions four times throughout the years. However, Germany has played in two more World Cup finals than Italy, having been runner-up four times. In total, Germany has been to the World Cup more often than any other country with a total of eight times. They are also the current World Cup champions, having won the most recent World Cup in 2014.

Like Germany, Italy has four World Cup wins under its belt, and like Brazil, Italy’s first two wins were consecutive, the first in 1934 and the second in ‘38. Italy has also been the runner-up in two final matches, with a total of six final appearances.

Runners Up: Teams that Competed but Failed to Score the W

Not all teams can be as fortunate as the top three winning teams. The following national teams have been runners-up at the FIFA World Cup, but are yet to be winners.

National team Wins Runners-up Years runners-up
Netherlands 0 3 1974,  1978,  2010
Czechoslovakia 0 2 1934,  1962
Hungary 0 2 1938,  1954
Sweden 0 1 1958

While the Netherlands team does hold a record, it’s not a very good one. The Dutch are known for having competed in the most World Cup finals without ever winning.

Hold the Field for Hosts

As for where the FIFA World Cup Finals take place, 16 countries have had the honor of hosting the world’s best soccer players, and some countries have hosted more than once. Hosting the FIFA World Cup is a pretty sweet deal because the host country is automatically entered to be one of the 32 teams set to compete for the World Cup.

View FIFA World Cup Locations & Attendance in a full screen map

Only three soccer or fútbol stadiums around the world can say they’ve gotten the chance to host the FIFA World Cup more than once. Estadio Azteca, Estádio do Maracanã, and Olympiastadion all have hosted the championships two times each. Estadio Azteca, located in Mexico City, Mexico hosted the World Cup in 1970 and then again in 1986. Estádio do Maracanã, in Rio de Janeiro, Brazil, has also hosted the World Cup twice, the first time in 1950 and the second time in the most recent past World Cup of 2014. Olympiastadion, in Germany, hosted twice in 1974 and 2006.

Both Italy and France have been the host country more than once, although the location of the stadiums varied. Italy hosted the 1934 World Cup at the Stadio Nazionale PNF, and again hosted the World Cup in 1990, this time at the Stadio Olimpico. The World Cup was played in Paris, France in 1938 at the Stade Olympique de Colombes and in Saint-Denis, France sixty years later in 1998 at the Stade de France.

Home-Field Advantage

If you’re curious if the hosts of the World Cup have a home-field advantage, six out of eight teams won the World Cup when the final game was played on their home turf. Brazil and Sweden are the only two teams who have lost while the game was played at home. Notably, England and France have only ever won the World Cup when it was played at home.

Attendance for the Win: Highest Attended World Cup Finals

Some World Cup Finals are better attended than others. Here is a list of the top three most-attended World Cup Finals:

  • 199,854, Estádio do Maracanã, Rio de Janeiro, Brazil, 1950
  • 114,600, Estadio Azteca, Mexico City, Mexico, 1986
  • 107,412, Estadio Azteca, Mexico City, Mexico, 1970

The 1950 World Cup, which was Brazil’s first time ever hosting, was unlike all other World Cups past and future in that there was no final game. Instead, the year saw a 4-team round robin tournament, the last match of which Uruguay beat Brazil on Brazil’s home turf. This round robin tournament could explain the extremely high attendance.

As for the Estadio Azteca in Mexico City? The reason for this stadium’s high attendance during two World Cups could be because spectators were dying to see Brazil vs. Italy in the 1970 final or because Argentina vs. West Germany seemed to be an interesting matchup in 1986. Or the high attendance could be because the stadium is said to be one of the most famous and highly regarded stadiums in the world.

On the other hand, France’s 1938 World Cup at in Paris at the Stade Olympique de Colombes had the lowest turnout of all of the World Cups with only 45,000 people, which is nearly ¼ the size of the highest attended World Cup. The game featured Italy versus Hungary.


Tune in to the 2018 World Cup Final in July to see if one of the teams that have never won a World Cup wins this year, or if it goes to one of the eight teams who already got a shot at holding the trophy. Speaking of shots, if you’re less of a soccer fan and more into basketball, be sure to check out all of the NBA Finals on a Map.

How do I import addresses into Google Maps?

There’s a good reason why most of us use smart phones to get to a new place. Unless you know a city or area really well, an address doesn’t immediately enter your mind spatially. When we can see a place—and the route to get there—on a map, it becomes clearer.

The problem grows when you have many addresses—potentially hundreds. When you want to visualize all of your holiday cards on a map or create a customer sales map you need a way to import all those addresses into Google Maps or some mapping tool.

Below you’ll find three simple steps to use when importing addresses into a map.

1. Make Sure Your Address List is in Excel or Other Spreadsheet

The spreadsheet and its similar file formats (CSV, tab-delimited, as two examples) is a universal way to move data between systems. You can share spreadsheets with almost anyone, often for free. There are also online services, like Google Sheets (part of the Google Docs Suite), that can help you quickly store and share your data.

For many people, your list of addresses may already live in Excel or another spreadsheet. That’s great! However, if you don’t yet have the data in spreadsheet form, there’s likely a way to export your contact addresses from wherever they are stored.

Export Outlook Contacts to Excel or CSV

While Outlook is best known for storing email addresses, you can also put additional contact information, such as addresses. If that’s the case, you’ll want to export them from Outlook so you can get them into a spreadsheet format.

The exact instructions will vary based on the version/edition of Outlook you own, so you’ll want to follow the Microsoft instructions. Regardless of which Outlook you have, you’ll want to look for an “Export” option in the file menu or search the program’s help option.

The best file type for your export is likely a CSV, the abbreviation of “Comma Separated Values.” This type of file is a plain text file with individual fields separated by commas. Plain text means it can be read in by any spreadsheet application, such as Excel, Numbers, or Google Sheets.

Export Apple Contacts to Excel or CSV

Apple’s application for storing addresses and other information is called Contacts. It is a Mac app that comes on your computer. If you have an iPhone, those contacts are likely synced to this application.

There is not a direct way to export from Contacts to a spreadsheet file. Instead, you need to export as Apple’s vCard format. Go to the File menu, then select Export, and then the vCard option. Once that is saved to your computer, you can use a service like this Online vCard Converter to get a CSV of your contacts.

This CSV file will include comma separated values (that’s where the acronym comes from) in a normal text file. You can then read that file with any spreadsheet application.

Export Google Contacts to Excel or CSV

Outlook and Apple Contacts are both primarily computer software, whereas Google Contacts only exists as a website. Regardless, you’ll still find an export option within the tool under the “More” menu option.

As with the others, the goal is to get a spreadsheet file. You’ll get two options for CSV, a comma separated values format that is plain text. Choose either of these and download the google.csv to your computer. You can now use that file to open your contacts in any spreadsheet application.

Export Addresses from Any Application

Your contacts may be stored in another application, such as a CRM (customer relationship management) tool, sales tracker, or similar. If you can retrieve contacts in CSV format, you’ll be set. Most of these tools support CSV (comma separated values), which is a plain text file that any spreadsheet application should be able to open.

If you aren’t sure how to export your contacts, try searching the application’s help document, search using Google, or reach out to the company’s support team.

2. Remove Contacts Without Addresses

Now that you have all your contacts in a spreadsheet format like CSV, open up the file in your spreadsheet application. If you don’t use Excel or Numbers, you can add it to Google Sheets by uploading it to Google Drive. Once uploaded, there will be an option to open in Google Sheets.

Depending where your list came from, there may be contacts without addresses. For example, you may have many records with only email address stored if you export from Outlook. Similarly, your Apple Contacts may be filled with only telephone numbers if it came from your iPhone. The key in this step is to remove contacts without street addresses, because those won’t show up on a map.

In Google Sheets, click the address column and sort it:

Then you’ll be able to see all your contacts with addresses in one place:

You can copy these to their own sheet, delete the contacts without addresses, or simply leave out the non-address contacts in the next step.

3. Copy and Paste All Contacts

Your spreadsheet is now sorted with your contact addresses grouped together. Now comes the part where we put them on a map! Using address import mapping tool it’s as easy as copy and paste:

  1. Select all of your contact columns from your spreadsheet, including the headers
  2. Copy the selection using the keyboard shortcut Ctrl+C (Command+C on Mac)
  3. Click into the location data box in BatchGeo and paste with Ctrl+V (Command+V on Mac).

Click the “Map Now” button and you’re done.

And in seconds, here’s the map created from my contacts:

View Import CSV Example Map in a full screen map

You’ll probably have more than just a handful, maybe even hundreds of sales leads, customers, friends, or other contacts. BatchGeo is the fastest, easiest tool to create a map from a spreadsheet of addresses. Use your own data to try it today for free!

How do I use my address map?

Once you’ve created your map, you’ll want to put it to use. Maps tell a story, and there are unlimited interpretations within them. That said, here are some things to consider for your map of contacts in your address book:

  • Visualize your customers or friends: do you know what regions or neighborhoods where many of them live? Maps make these clusters stand out.
  • Visit your customers or friends: search your map for nearby contacts and always be able to find those that are closest.
  • Export Google Earth KML to move your geolocated contacts to other geographic systems.

These and many other possibilities are on the other side of your contact map!