google-sheets-geocoding-macro

by nuket

Geocode from addresses to latitude / longitude, and vice versa using Google Sheets

222 Stars 125 Forks Last release: Not found 20 Commits 0 Releases

Available items

No Items, yet!

The developer of this repository has not created any items for sale yet. Need a bug fixed? Help with integration? A different license? Create a request here:

Google Sheets Geocoding Macro

How It Works

Geocode from addresses to latitude / longitude, and vice versa using Google Sheets.

Test Sheet

Try the macro out on a Test Sheet with sample address data.

You need to be logged into a Google Account before the Geocode menu will appear.

Google Sheets Add-On

Unfortunately, you've got to add this script to each sheet you are using.

Multicolumn Addresses → Latitude, Longitude

Now it supports geocoding using address data spread across multiple columns.

The way this works is: You select a set of columns containing the data, and the geocoding process puts the latitude, longitude data in the rightmost two columns. It will overwrite any data in those two columns.

Some care is needed, as it will concatenate all columns except the rightmost two columns to create the address string.

Multicolumn Address Geocoding

Latitude, Longitude → Nearest Address

It also supports reverse geocoding.

Simply select the latitude, longitude columns and it will place the nearest address data in the rightmost column. It will overwrite any data in that column.

Less care is needed, as it will automatically use the leftmost two columns as the latitude, longitude pair.

Reverse Geocoding

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.