Batch Geocoding Excel Spreadsheets

If you’ve ever made a week’s worth of meals in one day, paid your bills a stack at a time, or shopped at a membership club like Costco, you understand the concept of “batching.” It’s more efficient than handling each of those activities one at a time. You can wait until you have multiple tasks that are similar and then batch them at a particular time. Just as it makes sense in your personal life, batching is an important concept when working with data, including the stuff you store in Excel.

You may be storing many types of data in Excel, including financial, accounting, and sales data. Any of this may also include locations, such as cities, addresses, and postal codes. These can be converted into geographic coordinates—either one at a time or all at once. Anytime you have more than one location to geocode, that’s where you’ll use batch geocoding. So let’s dive into more about what batch geocoding is and some of the popular ways to batch geocode an Excel spreadsheet.

Batch Geocoding 101

Geocoding is the process of turning text location descriptions into numbered geographic coordinates, usually latitude and longitude. These pairs identify a point on the Earth’s surface. So what type of text-based descriptions can be geocoded?

The most common geocoding task is one or more full addresses, typically including the city and sometimes state or country. However, many geocoders accept several other types of locations. You can send city names (with or without state/country), postal codes, and state or country names. Some batch geocoders can even take common landmarks, business names, or place names, such as the largest houses in the U.S. like Biltmore Estate or Oheka Castle.

Geocoding larger geographic areas (such as entire countries) typically returns the center point of a place. With that overview, let’s take a look at how to geocode addresses in Excel.

Two Ways to Batch Geocode Your Spreadsheets

There are many great methods of batch geocoding your Excel or Google Sheets data, though the options range in price and their limitations. While multiple free ways exist (we’ll show you two), they can have downsides of address limits and difficulty.

Install a Google Sheets Add-On

This method of batch geocoding your spreadsheet works whether your data is stored in Excel or Google Sheets. It’s also free for 1,000 records per day. If you’re interested in this option, here’s how to go about it.

  1. In your web browser, navigate to Google Drive
  2. Click New > Google Sheets > Blank spreadsheet
  3. Either copy (Ctrl+C or Cmd+C) and paste (Ctrl+V or Cmd+V) your data from Excel or add your data directly into Google Sheets
  4. Download the Geocode by Awesome Table plugin for Google Sheets
  5. In the navigation bar, opt for Add-ons > Geocode by Awesome Table > Start Geocoding
  6. Determine if you want to continue working in Google Sheets or copy and paste the newly geocoded data from Google Sheets back into your Excel spreadsheet. Then you’re done!

However, this option has two downsides. First, for those with over 1,000 locations, this isn’t ideal due to its limits. Secondly, this method requires navigation to multiple external platforms depending on the spreadsheet tool you begin with. It isn’t possible to complete the steps all in Excel, nor is it even possible to remain entirely in Google Sheets, as you must install the add-on.

Another method that involves Google Sheets is importing JSON data in Google Sheets.

But let’s move on to a method that allows you to batch geocode more than 1,000 rows of your spreadsheet without switching between too many platforms.

Use Bing’s Free API

Here’s another option, in the event that you have more than 1,000 records and you’d rather not install an add-on.

This is where one of the most popular and the fastest geocoders come in. A Bing API key allows users to geocode 10,000 addresses.

Follow the steps below to take advantage of this option:

  1. Head over to http://excelgeocodingtool.com/
  2. Hit Download Excel File
  3. Open the downloaded file and enable Macros
  4. Create a Bing API key and copy and paste it into the Bing Maps Key field
  5. On the second sheet entitled Geocode, paste your addresses into the location column, opt to Geocode all rows, and you’re done!

Beyond 10,000, you must make a new account to obtain a new key, which can be a hassle. Plus, as you’ve seen, both of these options can be a bit difficult. Let’s check out an easier alternative.

An Easier Alternative

There’s more out there than clever hacks of tools that were never meant for batch geocoding. Instead of low quantity limits, add-on installations, and API keys, it’s easier to use an established tool with the sole purpose of batch geocoding your spreadsheets. BatchGeo enables you to simply copy and paste in any spreadsheet data.

To get started batch geocoding your spreadsheet, follow our simple steps below:

  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

Our web-based tool’s free version is more than enough for most users while our Pro option enables the quick mapping of 20,000 addresses at a time. For even more on how to batch geocode addresses quickly and easily, check out our page on the subject.

A Step Further: Mapping Addresses From Excel

With an understanding of batch geocoding and some options to utilize it for your spreadsheets—including our always easy geocoder— it’s time to take it one step further. Note that our tool also enables you to create custom maps, like the one below.

View Largest houses in the U.S. in a full screen map

We mapped this Wikipedia list of the 100 largest houses in the U.S. in seconds thanks to our mapping tool. Batch geocode and map your own spreadsheets today at batchgeo.com.

Largest Spacecraft and Satellite Reentry

You may have heard about a recent re-entering rocket—or part of one, anyway. The 39,200 lbs Long March 5B core fell, uncontrollably, into the ocean on May 9, 2021, nine days after its launch from China. And it’s not the first spacecraft or component to re-enter the Earth’s atmosphere. So how much space junk is orbiting Earth? There are several thousand pieces that are large enough to be tracked. Of these, 26 have returned from space to a launchpad—or hit the water.

With names like Apollo, Cosmos, Pegasus, and even another Long March, it’s clear these objects are out of this world. And yet…they found their way back to Earth. We highlight the largest of these re-entering spacecraft or components, along with the controlled and uncontrolled entries—plus, the countries that launched them on the map below.

View Spacecraft and Satellite Reentry in a full screen map

We used Wikipedia’s table of the heaviest re-entering debris list and paired the data with each object’s splash coordinates. Click through the interactive map to view the space debris field—or where these 26 objects fell. Then, sort by reentry type, reentry timeline, owner, launch information, and more or read on as we launch into the most massive of these spatial objects.

Most Massive Objects Fallen From Space

First things first, let’s go over the size of these falling objects. The 26 spacecraft or their components range in size from 5,300 lbs (a little larger than a rhino) to 260,000 lbs, which is nearly the size of the Statue of Liberty. As for the largest of these already large returning spatial objects? They’re all over 40,000 lbs, as you’ll note on the table below.

Object Mass (lb) Mass (kg) Reentry type Owner Reentry year
Mir 260,000 120,000 Controlled Russia 2001
Skylab 152,000 69,000 Partially Controlled USA 1979
Salyut 7 88,000 40,000 Uncontrolled USSR 1991
S-II Stage / Skylab 79,700 36,200 Uncontrolled USA 1975
Salyut 6 77,000 35,000 Controlled USSR 1982
STS external tank (Standard Tank) 77,000 35,000 Partially Controlled USA 1981
STS external tank (Lightweight Tank) 66,000 30,000 Partially Controlled USA 1983
Cosmos 557 42,800 19,400 Uncontrolled USSR 1973
Salyut 5 42,000 19,000 Controlled USSR 1977
Salyut 4 41,700 18,900 Controlled USSR 1977

The most massive re-entering spacecraft was Russia’s Mir. More than half again as big as the second-largest, the space station’s deorbit was meticulously planned in three stages before ultimately landing in the ocean near Nadi, Fiji. The space station had spent 15 years in service, though its orbit decay and presence of the International Space Station led to its controlled reentry in 2001.

Photo of Mir by NASA & Thegreenj

That second-largest returning object was the U.S.’s Skylab. As it was the first American space station, its Earthly return turned into an international media event in 1979, with T-shirts and hats with bullseyes and “Skylab Repellent” with a money-back guarantee, wagering on the time and place of re-entry, and nightly news reports.

The rest of these massive spacecraft or components all weigh in at 88,000 lbs or less. With an idea of the size of these returning objects, let’s move on to the type of re-entry.

Controlled & Uncontrolled Space Debris Re-Entry

Regardless of mass, another important factor of re-entering spacecraft or components is whether their re-entry is controlled or not. During a controlled re-entry, the object may be navigated or follow a preset course. The opposite is true for an uncontrolled entry. Uncontrolled entries have the (albeit slim) chance of crashing somewhere dangerous. Of the 26 spacecraft or components to have re-entered the Earth’s atmosphere, some were controlled, while others ended up uncontrolled or partially controlled.

  • Uncontrolled (14)
  • Controlled (9)
  • Partially Controlled (3)

We’ll begin with the good news: nearly 35% of all re-entries have been controlled. The USSR’s Salyut 1 was the first to intentionally crash, in October of 1971. And when it comes to the need for a “Partially Controlled” category, we can thank the U.S. All three that re-entered between 1979 to 1983 belonged to the country.

Photo of Long March 5B core by 篁竹水声

The first of many uncontrolled reentries took place in 1964. The U.S.’s Apollo SA-7 CSM BP-15 went into the Indian Ocean. Since then, a total of 14 have followed suit, including the recent uncontrolled re-entry of Long March 5B core (5B-Y2 flight) on May 9, 2021. This wasn’t even the first of its name to re-enter uncontrollably. Almost exactly one year earlier, on May 11, 2020, Long March 5B core (5B-Y1 flight) came back to Earth. Both were launched by China, which leads us to which countries owned these massive controlled—or uncontrolled—objects.

Countries That Launched These Space Objects

While the recent uncontrolled re-entries may make it seem as though China’s space program is always launching something that comes back to the atmosphere, it’s astro-not the country with the most re-entering spacecrafts. Here’s an overview of the countries that launched these heavy objects, only to have them come back to Earth.

  • USA (10)
  • USSR (9)
  • China (3)
  • Russia (2)
  • NASA (1)
  • DLR (1)

As you can see, most of the 26 re-entering spacecrafts or components came from the U.S. Only one of those 10 was controlled: CGRO, which returned to Earth in June 2000 after launching back in April 1991. And as we previously mentioned, the only three partially controlled re-entries came from here as well.: STS external Lightweight Tank, STS external Standard Tank, and Skylab. This makes the other six U.S. re-entries uncontrolled, the names of which you can find on the map.

As for the USSR, seven of the nine total were controlled re-entries, arguably making the socialist state the most responsible when it comes to space object re-entry. The two that were uncontrolled? Salyut 7 and Cosmos 557, both from decades past.

There you have it: the largest space objects to re-enter the Earth, those that were controlled or uncontrolled, and the countries that launched them. Get more insight into your data with custom-made maps. And to continue your exploration of space Earth-side, check out Space Stations with Most Rocket Launches.

The Largest House in America… & 99 More Mansions

What’s better than a resort feel combined with the comfort of a home? While not the biggest house in the world, no lavishness was spared during the construction of 100 of the biggest houses in the U.S. The massiveness of these mansions is based on the square footage of the main house (you read that right, some of these properties have multiple houses).

Still standing or not, these homes are worth remembering. And when it comes to 100 of the largest homes in the country, inquisitive minds want to know about the 10 biggest of 80,000 square feet or above. As for where most of these massive homes are located and who they were built for? Go window shopping for this information and more on the map below.

View Largest houses in the U.S. in a full screen map

According to Wikipedia’s list, these are the 100 largest houses in the United States. We mapped them in seconds via our online mapping tool, enabling us (and you!) to sort by the additional data like square footage, year completed, who the home was built for, architectural style, and the owner and architect. Let’s jump into what we can learn from our mapped data.

Biggest of Already Big Houses

The 100 houses on the map range in size from 39,648 to 178,926 square feet. But the biggest of these already big homes? They’re all 80,000 square feet or above.

  1. Biltmore Estate
  2. Oheka Castle
  3. Whitemarsh Hall
  4. Arden House
  5. Winterthur
  6. Shadow Lawn (tied with Cornelius Vanderbilt II House)
  7. Cornelius Vanderbilt II House (tied with Shadow Lawn)
  8. Meadow Brook Hall
  9. Versailles
  10. Florham (tied with Harbor Hill)
  11. Harbor Hill (tied with Florham)
Photo of Biltmore Estate by 24dupontchevy

Of the largest U.S. houses, Biltmore Estate is #1. This Asheville, North Carolina residence sprawls across 178,926 square feet and was built in 1895 for George Washington Vanderbilt II. The second-largest home in the U.S. also happens to be the last one above 100,000 square feet. It’s the West Hills, New York Oheka Castle, also known as the Otto Kahn Estate (109,000 square feet).

As for Wyndmoor, Pennsylvania’s Whitemarsh Hall, it added up to exactly 100,000 square feet before it was torn down in 1980. Additionally, Arden House takes up 97,188 square feet while Winterthur resides on 96,582. Both West Long Branch, New Jersey’s Shadow Lawn and N.Y.C.’s Cornelius Vanderbilt II House weighed in at 90,000 square feet, though the Vanderbilt home was demolished in 1926. Meadow Brook Hall in Rochester Hills, Michigan sits atop 88,000 square feet.

And while not the actual palace, Versailles comes pretty close at 85,000 square feet in Windermere, Florida. This leaves Florham in Florham Park, New Jersey and Harbor Hill in Roslyn, New York to tie with 80,000 square feet. And even though Harbor Hill was demolished in 1947, these two homes are representative of where most of the hundred are located.

A Large Number of Large Homes Are Here

Photos of Felix M. Warburg House, Otto H. Kahn House, & Henry Clay Frick House

You’ll find pins representing these 100 large homes all across the country. However, most are located in the Eastern states of New York, New Jersey, or Pennsylvania.

City-wise, six are—or were—in New York City alone. This includes the Cornelius Vanderbilt II House (demolished in 1926), Andrew Carnegie Mansion, Felix M. Warburg House, Otto H. Kahn House, Riverside (demolished in 1948), and Henry Clay Frick House.

On the other side of the country, The Manor, The Pritzker Estate, 457 Bel Air Road, Château des Fleurs, and 10697 Somma Way are all located in Los Angeles. Then there’s the White House, one of five tens-of-thousands square feet homes in Washington D.C.

Additional estates in the capital city include Dumbarton Oaks, the Perry Belmont House, Townsend House, and Anderson House. Three mansions can also be found in Palm Beach, Florida along with Newport, Rhode Island, but let’s see what other insights can be illuminated from the map.

Who Were These Huge Homes Built For?

More than the biggest or the cities home to quite a few, it’s notable that nine of the people these houses were built for are named William (including one of six Vanderbilts). Even more, the following folks had two of these large homes built for them:

  • Alfred I. du Pont
  • Cornelius Vanderbilt II
  • Edward T. Stotesbury
  • George Crocker
  • Otto Hermann Kahn

Of the five, you may most easily recognize Cornelius Vanderbilt II thanks to his connection to the famous family (and that his namesake home was one of the 10 largest and located, among five others, in the Big Apple). This particular Vanderbilt became the Chairman and President of the New York Central and related railroad lines after his father in 1885. In addition to being the goal of the sixth-largest home in the U.S., the Cornelius Vanderbilt II House, The Breakers, a 62,482 square foot home, was also built for him in Newport, Rhode Island.

As for the other four names, Alfred Irénée du Pont was an industrialist, financier, philanthropist, and member of the influential du Pont family until his death in 1935. His two houses included the 65th largest, dubbed Nemours in Wilmington, Delaware and #88 NYIT de Seversky Mansion in New York. Interestingly, family member Henry Francis du Pont was the architect of the fifth-largest home, Winterthur. And prominent investment banker Edward T. Stotesbury owned the previously mentioned third-largest home in the country: Whitemarsh Hall. That along with El Mirasol (60,000 square feet) were his.

George Crocker, the second vice president of the Southern Pacific Railroad, had both the Crocker-McMillin Mansion (50,000 square feet) and Darlington (45,000 square feet) built for him in Mahwah, New Jersey. As for Otto Hermann Kahn, the man was a German-born American investment banker, collector, philanthropist, and patron of the arts with the second largest home in America: Oheka Castle along with the Otto H. Kahn House (50,316 square feet).

Architectural Style, Owner, Architect & More

You can also sort the map by the 30+ different architectural styles of these homes—and it’s clear Châteauesque is the most popular. Do the same with the owners of these homes or the brilliant architects like Carrère and Hastings (who had a hand in at least eight of these homes) and Horace Trumbauer (the architect of seven). Get to grouping your additional data like this now with BatchGeo. Or, if you’re in the market for the biggest house in the world, learn how to make an open house map. Or if you’re not quite there yet, apartment hunt visually with a custom map.