Turn a column of addresses into latitude and longitude, right inside your spreadsheet.
Zápis aktualizován:19. srpna 2026
Podporuje:
Žádné recenze
21
Přehled
Pinpoint turns a column of addresses into Latitude and Longitude columns, right inside Google Sheets™.

Pick the column that holds the addresses, check what the panel says will happen, press Geocode. That is
the whole flow.

WHAT YOU GET, FREE
• Addresses → coordinates, using the Google Maps™ geocoder built into Google Apps Script™.
• Two-pass search: a precise pass biased to your sheet's country, then a wider pass for what the first
  one missed. Anything the wider pass found is marked APPROX — never passed off as exact.
• Incremental by default: rows that already have coordinates are skipped, so a second run only geocodes
  the new rows. No more redoing the whole sheet.
• A dry run before anything is written: how many addresses will be geocoded, how many are skipped, and
  exactly which columns the results go to.
• Your data is never overwritten. Results go into three new columns — Latitude, Longitude and Geocode
  status — inserted next to your address column. Rows where those cells already contain your own text
  are left untouched and reported as such.
• Honest failures: an address Google cannot resolve is marked NOT_FOUND and can be retried with one
  button; a rate limit or an exhausted allowance stops the run and says so, instead of poisoning your
  rows with a wrong answer.
• A visible usage counter over the real 24-hour window, plus the first result shown on a map.

PRO — $29/year or $69 once, per user
• Your own Google Maps Platform API key: geocoding runs on your key, with no daily cap.
• Reverse geocoding: coordinates → the nearest address.
• Country bias and result language.
• The same licence unlocks every tool we publish next.
The free features stay free forever, and if a licence lapses you simply drop back to them — never
locked out.

PERMISSIONS
One permission, and the narrowest one there is: "See, edit, create, and delete only the specific Google
Sheets™ spreadsheet this application is used in". Pinpoint cannot see your other spreadsheets, your
Drive or your mail. There is no server of ours anywhere in the flow — geocoding is done by Google Apps
Script™'s built-in service, running as you. Nothing about you or your sheets is sent to us, and there is
no analytics. Details: https://legal.syncerp.work/pinpoint/privacy

Google Sheets™, Google Maps™, Google Apps Script™ and Google Workspace™ are trademarks of Google LLC.
Pinpoint is an independent product of Going Stellar SRL and is not affiliated with or endorsed by Google.
Další informace
CenyBez dalších poplatků s placenými funkcemi
Zásady ochrany soukromí
Pinpoint požádá o oprávnění uvedená níže. Další informace
Pinpoint bude potřebovat přístup k vašemu účtu Google
Aplikaci Pinpoint tím umožníte:
Zobrazení a správa tabulek, do kterých byla tato aplikace nainstalována
Zjištění vaší primární e-mailové adresy účtu Google
Zobrazení vašich osobních informací včetně jakýchkoli osobních informací, které jste veřejně zpřístupnili
Recenze
Jazyk:
Řadit podle:
Společnost Google recenze ani hodnocení neověřuje. Další informace o recenzích
Žádné komentáře
Vyhledávání
Vymazat vyhledávání
Zavřít vyhledávání
Aplikace Google
Hlavní nabídka