Single Task Tools

Address to Coordinates: Latitude & Longitude

This add-on writes the latitude and longitude of a column of addresses in Google Sheets™, from any country, using the geocoder Google™ builds into Sheets scripts. It also works the other way round: two columns of coordinates become addresses. It is free: 1,000 addresses a day on personal accounts and 10,000 on Google Workspace™ accounts, with no API key and no account to create.

Install it from the Google Workspace Marketplace™, or from Extensions › Add-ons › Get add-ons inside Google Sheets™.

How to use it

  1. Select the cells with your addresses (one column). The two columns to the right must be empty: that is where the coordinates go.
  2. Open the Extensions menu, find Address to Coordinates and choose Get latitude and longitude, or Get latitude, longitude and matched address to also write the address Google recognised in a third column.
  3. For the reverse, select two columns (latitude, longitude) and choose Get address from coordinates. Ctrl+Z (Cmd+Z on Mac) takes it all back.

What it takes care of

Languages

The menus and messages follow the language of your Google account: English, Spanish, Portuguese, French, German and Italian. Any other language shows English.

Questions

Where do the coordinates come from, and where do my addresses go?
Each address is sent to the geocoder that Google™ builds into Google Sheets™ scripts, the same engine behind Google Maps™. Nothing else leaves your spreadsheet: no servers of ours, no tracking. See the privacy policy.
How many addresses can I do?
Google™ allows 1,000 geocoding calls per day for personal accounts and 10,000 for Google Workspace™ accounts. When the limit is reached the add-on stops, keeps the rows it has done and tells you; run it again the next day and it continues where it stopped.
Does it work with addresses from my country?
Yes: street addresses, postcodes, cities and place names from any country Google Maps™ covers. Writing the city and country in the cell helps with ambiguous street names.
Can I undo?
Yes. Ctrl+Z (Cmd+Z on Mac) puts the previous values back.
Does it work in the mobile app?
No. Google Sheets™ add-ons run in the web version only.

Anything else: support@singletasktools.com.