LatLong Fill

A free Google Sheets add-on. Pick your address column and get latitude, longitude and match accuracy, in your own sheet. No API key, no account.

How it works

  1. Install LatLong Fill from the Google Workspace Marketplace.
  2. In your sheet, open Extensions > LatLong Fill > Open LatLong Fill.
  3. Tick your address column (or street, city, state and ZIP columns) and click Geocode.

LatLong Fill adds Latitude, Longitude, Accuracy and Matched address columns. If your sheet already has Latitude and Longitude columns, for example from another geocoding add-on, it fills those instead. Rows that already have coordinates are left alone, and a rerun only geocodes new or changed addresses.

Free, with a daily limit

LatLong Fill is free for up to 100 found addresses per user per day. Addresses that can't be found don't count. Google's own geocoding quota also applies (1,000 lookups a day on a personal Google account, 10,000 on Google Workspace).

Your data

LatLong Fill only opens the spreadsheet you use it in. It has no server: addresses go straight from Google Apps Script to the geocoders and the results go back into your sheet. Read the privacy policy and terms of service.

Support

Questions, bugs or a feature request? Email support@dullfix.com. Replies usually come within one business day.