Best Google Sheets geocoding add-ons in 2026

Google Sheets geocoding add-ons: quick comparison

“Bulk geocoding” can mean two different things. Some tools accept a selected range but require the spreadsheet or sidebar to remain active. A managed background job can continue after the sidebar closes. The table keeps those concepts separate and uses not publicly stated when a vendor does not publish a firm number.

Apps Script quotas are per user and can change. Google says quotas reset 24 hours after the first request. See the current Apps Script quotas.

Which option is the best fit?

Best for managed, no-key batch geocoding

Sheets Geocoder handles forward and reverse jobs, lets you choose the destination and fields, and publishes a 75,000-row monthly Pro allowance.

Best when the map is the final product

Geocode for Sheets & Mapping Sheets combines batch geocoding with interactive maps that can be shared, embedded, or printed.

Best for a broad mapping toolbox

Maps for Sheets covers maps, routes, places, address components, boundaries, GeoJSON, KML, and more, with additional API-key setup for several functions.

Best published daily free allowance

ezGeocode advertises 250 address geocodes per day and returns rich structured address information. Its public listing focuses on forward geocoding.

Best for a shareable Awesome Table map

Geocode by Awesome Table is designed to add latitude and longitude and create a map view. Its Marketplace listing was last updated in April 2024, so test current compatibility first.

Best for developers who want full control

Apps Script exposes forward and reverse geocoding without an add-on subscription, but you own the code, quota handling, retries, scheduling, and support.

Compare spreadsheet permissions before installing

A permission does not by itself prove how a vendor uses data, but it defines what Google allows the add-on to access. Google's Marketplace permission panels are the best current source. Always read the live consent screen and privacy policy before approving access.

Product-by-product notes

Sheets Geocoder

Sheets Geocoder is purpose-built for forward and reverse geocoding rather than map design. It accepts a combined address column or adjacent address fields, lets the user select only the output columns needed, and writes to a chosen starting cell. Free jobs use Google's built-in Maps service; Pro jobs use a managed provider workflow and can continue in the background. The tradeoff is that the one-time free allowance is smaller than ezGeocode's published daily allowance.

See the forward-geocoding workflow or the reverse-geocoding workflow.

Geocode for Sheets & Mapping Sheets

This add-on combines address-to-coordinate and coordinate-to-address conversion with a custom interactive map. The listing says no Google Maps API key is required and documents country, province, county, city, sub-city, and postcode output for reverse geocoding. Its Marketplace panel requests access to all spreadsheets. A fixed row allowance and managed-background-job behavior were not stated in the sources reviewed.

Geocode by Awesome Table

Awesome Table's listing describes forward geocoding, two added coordinate columns, error management, and a shareable map with clustering and filters. Reverse geocoding, a fixed quota, and public pricing are not documented there. The listing was last updated April 1, 2024; that does not prove the product is inactive, but it makes a live compatibility test sensible before committing a production workflow.

Maps for Sheets

Maps for Sheets is substantially broader than a geocoder. It supports static maps, street views, places, routes, isolines, boundaries, address components, and geographic exports. Its listing says several functions require a user-provided Google Maps API key, while boundaries or isolines can require Bing or HERE keys. That gives technical users flexibility, but provider setup, quotas, and usage charges remain part of the workflow.

ezGeocode

ezGeocode has the clearest published recurring free allowance in this group: 250 addresses per day. It focuses on forward geocoding and rich address cleanup, including normalized and split components, precision, regional fields, status, and a one-click flow for ambiguous results. The vendor page shows packages from $15 for 1,000 addresses through $99 for 10,000; verify the current package terms before buying.

Google Apps Script

The built-in Maps service provides geocode(address) and reverseGeocode(latitude, longitude). It is the most flexible option because you decide how to read cells, transform responses, cache, retry, schedule, and write results. It is also the most engineering-heavy. Google currently publishes 1,000 daily geocode calls for consumer accounts and 10,000 for Workspace accounts, along with execution-time and trigger limits. Those limits are quotas, not a production queue.

How this comparison was researched

We included tools with an established Marketplace listing or an official first-party implementation path. Each row was checked against primary sources, not copied from another comparison article. Where a source used language such as “free with paid features” without a numerical allowance, we did not invent one.

• Sheets Geocoder Marketplace listing, plus this site's pricing and privacy policy.
• Geocode for Sheets & Mapping Sheets Marketplace listing.
• Geocode by Awesome Table Marketplace listing.
• Maps for Sheets Marketplace listing and vendor documentation.
• ezGeocode Marketplace listing and vendor pricing page.
• Apps Script Geocoder reference and Google service quotas.

Comparison pages from other publishers also appear for these searches. For example, BatchGeo's article on geocoding thousands of Google Sheets rowsrecommends Geocode for Sheets & Mapping Sheets as its add-on example. That recommendation is not evidence for a feature row above; it simply shows why a current, source-linked comparison is useful.

Common questions