Mastering Pivot Tables in Google Sheets
If you’ve ever found yourself lost in a sea of spreadsheet data and trying to make sense of rows and columns that blur together, pivot tables might be your new…
The Fastest Way to Map Data
From spreadsheet to map in three simple steps. Batchgeo is the fastest way to turn your data into interactive maps.
Helpful How-to Posts
How to Enter Latitude and Longitude into Google Maps
How to Enter Latitude and Longitude into Google Maps
Every point on the earth can be described by two numbers, neither larger than 180. Most of us even have devices that will tell us the exact point where we’re st…
How to Format Addresses for BatchGeo
How to Format Addresses for BatchGeo
Part of the magic of BatchGeo is that we create maps from your existing Excel files and other spreadsheets. Just copy-paste and you’re done. That said, th…
How to Plot Latitude and Longitude on a Map
How to Plot Latitude and Longitude on a Map
For hundreds—maybe thousands—of years, it was hard to make maps. People dedicated their entire lives to the craft. While that’s still true today, now there are…
Recent Posts
Mastering Pivot Tables in Google Sheets
Mastering Pivot Tables in Google Sheets
If you’ve ever found yourself lost in a sea of spreadsheet data and trying to make sense of rows and columns that blur together, pivot tables might be your new…
Where the World’s Largest Rough Diamonds Were Found
Where the World’s Largest Rough Diamonds Were Found
As Marilyn Monroe famously sang in Gentlemen Prefer Blondes, “diamonds are a girl’s best friend.” But before they sparkle in display cases, the worldR…
A Map of EGOT Winners’ Birthplaces
A Map of EGOT Winners’ Birthplaces
One of the highest honors in show business is achieving an EGOT. The acronym was coined by actor Philip Michael Thomas in late 1984 and refers to individuals w…
What Are The Best Mapping Apps in 2025? 5 Top Options.
What Are The Best Mapping Apps in 2025? 5 Top Options.
Bringing location data to life is now simpler than ever, thanks to the many online mapping applications available. Whether you’re a seasoned cartographer or jus…
A Map Of Cities Straddling The Equator
A Map Of Cities Straddling The Equator
The equator, an imaginary line circling the Earth at 0 degrees latitude and divides the planet into the Northern and Southern Hemispheres, plays a crucial role…
Geocode Thousands of Google Sheets Rows in Seconds
Geocode Thousands of Google Sheets Rows in Seconds
Geocoding is the process of turning addresses into geographic coordinates, like latitude and longitude. Instead of just knowing an address as a street name and…
Speed Up Your Data Analysis with ChatGPT
Speed Up Your Data Analysis with ChatGPT
If you spend any amount of time working with information, such as addresses or sales numbers, you’ll know that this information isn’t always perfectly nea…
Make a Boundary Map With Spreadsheet Data
Make a Boundary Map With Spreadsheet Data
In an increasingly data-driven world, understanding geographical patterns can reveal insights that spreadsheets simply can’t. Whether it’s population dens…
A Map of the Tallest Waterfalls in the World
A Map of the Tallest Waterfalls in the World
What comes to mind when you imagine a waterfall? Maybe it’s the sound of the rushing water, or the droplets of mist hitting your skin leaving you damp in second…
