26 location formulas for Google Sheets™. =GEOCODE fills coordinates for a whole column, =INSTAMAP turns it into a live map, plus drive times, routes and territories. Free — no API key, no setup.
Listing updated:August 9, 2026
Works with:
573
Overview
Your spreadsheet can geocode now. And route. And map.

InstaMaps adds 26 location formulas to Google Sheets™ — spreadsheet functions that work like the ones you already know:

=GEOCODE(A2:A50) — addresses become latitude + longitude, spilled in next to your data
=INSTAMAP(A2:D50, "My map") — a live, shareable map appears in the cell, and it updates whenever your sheet changes
=TRAVEL_TIME(A2, B2) — real driving minutes on actual roads, not straight lines
=DISTANCE, =CLOSEST_TO, =WITHIN_RADIUS, =SORT_BY_DISTANCE — measure and rank anything by location
=VISIT_ORDER(A2:A20) — your stops in the right driving order; =ROUTE_LINK opens the whole run in Google Maps™
=TERRITORY(A2:A99, 4) — split any list into fair geographic zones
…plus address cleaning, postcode/city/state extraction, reverse geocoding, Street View™ and Waze™ links.

Because they're formulas, they compose: chain GEOCODE into DISTANCE into INSTAMAP and your sheet becomes a living dispatch board, farm map or delivery plan that rebuilds itself when a row changes. The sidebar's one-click "Build the workflow" writes the whole chain for you.

Built for people who run their day from a spreadsheet: field service dispatch, real estate farming and comps, sales territories, delivery runs, store locators.

Free to use — no API key, no billing account, no setup. Generous free tier; formulas like GEOCODE work on whole ranges. Your data stays in your sheet: maps you create are unlisted and only visible to people you give the link.

Install, type =GEOCODE( in any cell, and watch your sheet learn geography.

Additional information
PricingFree of charge
Privacy policy
Terms of service
InstaMaps will ask for the permissions shown below. Learn more
InstaMaps will need access to your Google account
This will allow InstaMaps to :
View and manage spreadsheets that this application has been installed in
See, edit, create, and delete only the specific Google Drive files you use with this app
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Dyson Davies
July 20, 2026
Using it for the first time today and I realized at some point that the distance it was calculating was off by up to a few miles. Also, the territories created didn't always make sense according to the map. For example, one territory had a site 12 miles from me in one direction and another 25 miles from me in the opposite direction.
Is this review helpful?
Yes
No
Profile Picture
Probir Sengupta
August 26, 2026
I am a new user So far it is great
Is this review helpful?
Yes
No
Profile Picture
Oreva
July 29, 2026
Formulas work really well
Is this review helpful?
Yes
No
1-3 of 3
Search
Clear search
Close search
Google apps
Main menu