# InstaMaps — Location Formulas for Google Sheets | Geocode, Route & Map, Free

> 26 location formulas for Google Sheets: =GEOCODE fills coordinates, =INSTAMAP returns a live map, plus routes, distances and territories. Free — no API key, no billing account.

Source: https://get-instamaps.com

[InstaMaps](/)

[Features](#features)[How It Works](#how-it-works)[Tools](/tools)[Store Locator](/store-locator)[Blog](/blog)[Support](/support)

[ Get Started ](https://workspace.google.com/marketplace/app/instamaps/103204565785?utm%5Fsource=get-instamaps&utm%5Fmedium=site&utm%5Fcampaign=header)

 Free · No API key · No login to try 

#  Location Formulas for Google Sheets 

 Clean addresses, geocode, measure distances, plan routes, and make live maps — with 26 formulas that live in your sheet. No API key, no billing account, no new software to learn. 

\=GEOCODE(A2:A50) → coordinates fill in next to your data

\=INSTAMAP(A2:D50) → a live, shareable map lands in the cell

\=VISIT\_ORDER(A2:A20) → your stops, in driving order

[ Get the formulas — Free ](https://workspace.google.com/marketplace/app/instamaps/103204565785?utm%5Fsource=get-instamaps&utm%5Fmedium=site&utm%5Fcampaign=index)[ Try it first — no install, no login ](/tools/geocoder)

 🔒 Your data stays in your sheet • 🗺 The flagship trick: turn any sheet into a live map • ✅ Free tier, no card 

![InstaMaps — turn any Google Sheet of addresses into a filterable map](/images/instamaps_hero.png)

📍 **74,000+** addresses geocoded🌍 used in **85+** countries🔒 **Free** · no login · no API key🗺️ [**2,222 UK pubs** mapped in one click](/blog/closed-pubs-uk-map)

New · Works in Claude

## InstaMaps inside Claude

 Ask Claude to geocode a list, plan routes, find the nearest A&E or count what's around every site, and get a map you can share. One connector, fourteen location tools, free. 

[ Add it to Claude → ](/mcp-server)

Free

To try — no login, no card

No trial timer that flips to paid. No credit card on file.

5 min

Spreadsheet to map

Name the tab → open add-on → your rows are on the map

0

Setup required

No IT project. No API key. No config.

##  Everything you need to turn a list of places into a map 

 Map it, filter it, route it, share it — all from the Google Sheet you already have. 

### See It All on a Map

 Every row on Google Maps instantly. Spot clusters, gaps, and outliers in seconds — whether they're customers, stores, delivery stops, or sites to visit. 

### Free Salesforce Maps Alternative

 Export any Salesforce or CRM report to Google Sheets and see your accounts by owner, stage, or region. Salesforce Maps charges $75/user/month for that view — here it's free. 

### AI Address Detection

 AI finds your address columns automatically — street, city, state, ZIP, or lat/lng. No manual column mapping. Works with any sheet structure out of the box. 

### Real-Time Filters

 Filter by owner, status, category, region — any column in your sheet. Zoom into a city and see only the rows in that viewport. Results update instantly on the map. 

### Multiple Map Layers

 One tab per team, region, store type, or route. Each layer gets its own color-coded markers matching your Google Sheets tab color. See them all on one map or toggle layers. 

### Route Planning

 Select stops on the map and generate a route through 50–100 of them. See drive times and distances — built for delivery, install, and field-visit days. Export the route back to Sheets. 

##  The 4-Step Prospecting Loop 

 Pull → Visualize → Filter → Push. Complete the entire workflow in minutes and repeat continuously to refine your prospecting strategy. 

 Continuous  
Optimization 

### 1\. Open Google Sheet™

Open any Google Sheet™ with addresses—instant connection, no CSV exports or imports

### 2\. Visualize Territory

AI automatically detects addresses and maps all locations with clustering in seconds

### 3\. Plan Routes & Filter

Optimize multi-stop routes, filter by location/industry/criteria, see travel times and distances

### 4\. Export to New Tab

Create new Google Sheets™ tab with filtered list and route—ready to use immediately

### 1\. Open Google Sheet™

Open any Google Sheet™ with addresses—instant connection, no CSV exports or imports

### 2\. Visualize Territory

AI automatically detects addresses and maps all locations with clustering in seconds

### 3\. Plan Routes & Filter

Optimize multi-stop routes, filter by location/industry/criteria, see travel times and distances

### 4\. Export to New Tab

Create new Google Sheets™ tab with filtered list and route—ready to use immediately

### Google Sheets™-Native Workflow

 The key insight: Data flows FROM Google Sheets™ → InstaMaps → BACK to Google Sheets™. This creates a continuous prospecting and routing cycle that takes minutes, not hours. Perfect for commercial real estate, traveling sales reps, and field service teams. 

##  Spreadsheet to map in 5 minutes 

 No IT project. No admin setup. If you can open a Google Sheet, you can do this. 

01

### Open Your Sheet

 Any Google Sheet with a column of addresses — customers, stores, stops, sites. Export from your CRM or just type them in. No CSV file. 

02

### Rename the Tab

 Name your data tab starting with `layer_` — for example `layer_Stores`. Then open the InstaMaps add-on and click Load Map. 

03

### Filter Your Map

 Your rows appear as map markers in seconds. Filter by owner, status, category, or region. Zoom into an area to see only the locations there. 

04

### Share or Embed It

 Screenshot the map for a deck. Export the filtered rows to a new sheet tab. Share the Google Sheet, or embed the live map on your site. All your columns preserved. 

Under 5 minutes from a sheet to a filterable map(no plugin, no API key, no IT project)

## Explore ready-made maps

Every one is just a spreadsheet of places — proof of what you can build in one click. Explore them, then make your own free.

[🥒Pickleball Courts Map24,000+ US pickleball courts — find courts near you, by state.](/maps/pickleball-courts)[🐕Dog Parks Map8,000+ US off-leash dog parks — find one near you, by state.](/maps/dog-parks)[🎾Padel Courts Map12,000+ padel courts worldwide, by country — Spain to Sweden.](/maps/padel-courts)[🗼US Lighthouse Map800+ US lighthouses, from Maine to the Great Lakes to the Pacific.](/maps/lighthouses)[🏞️National Parks MapEvery US national park, with year founded and annual visitors.](/maps/national-parks)[🏈NFL Teams MapAll 32 NFL teams and their stadiums.](/maps/nfl-teams)

[See all maps →](/maps)

##  Get mapping tips — no spam 

 One email when we publish a new playbook. That's it. 

##  Your spreadsheet is already a map. You just can't see it yet. 

 Customers, stores, delivery stops, sites to visit — if it's a list of addresses, InstaMaps puts it on a filterable map in about 5 minutes. No API key, no setup. Free to try. 

[ Map Your Google Sheet — Free ](https://workspace.google.com/marketplace/app/instamaps/103204565785?utm%5Fsource=get-instamaps&utm%5Fmedium=site&utm%5Fcampaign=index)

 Free to try • No login • Works with any Google Sheet 

InstaMaps

 Territory mapping and routing for Google Sheets™. 

### Product

* [Features](#features)
* [How It Works](#how-it-works)
* [Sheets Formulas](/formulas)
* [100-Stop Route Planner](/tools/multi-stop-route-planner)
* [Dispatch Software](/blog/dispatch-software)
* [Route Optimization](/blog/route-optimization-software)

### Company

* [About](#)
* [Blog](/blog)
* [Free Tools](/tools)
* [Store Locator](/store-locator)
* [Careers](#)
* [Contact](#)

### Resources

* [Setup Guide](/docs/setup)
* [Help Center](/docs/help)
* [Documentation](/docs)
* [Press Map: Closed UK Pubs](/press/closed-pubs)
* [Free Batch Geocoder](/tools/geocoder)
* [HUBZone Checker](/tools/hubzone-checker)
* [Census Tract Lookup](/tools/census-tract-lookup)
* [Opportunity Zone Checker](/tools/opportunity-zone-checker)
* [USDA Eligibility Checker](/tools/usda-eligibility-checker)
* [Flood Zone Checker](/tools/flood-zone-checker)
* [Flood Zones Explained](/flood-zones)
* [Population Within a Radius](/tools/population-within-radius)
* [Conservation Area Checker](/tools/conservation-area-checker)
* [Flood Zone Checker (England)](/tools/uk-flood-zone-checker)
* [UPRN Lookup](/tools/uprn-lookup)
* [Service Area Map](/tools/service-area-map)
* [Multi-Driver Route Planner](/tools/multi-driver-route-planner)
* [Postcode Distance (UK)](/tools/postcode-distance-calculator)
* [ZIP Codes in a Radius](/tools/zip-codes-in-radius)
* [Sales Route Planner](/blog/sales-route-planner-free)
* [Territory Mapping](/blog/free-territory-mapping-software)
* [Report Issue](mailto:hello@get-instamaps.com?subject=Something%20isn%27t%20working)

### Legal & Support

* [Privacy Policy](/privacy)
* [Terms of Service](/terms)
* [Support](/support)
* [Admin Config](/dashboard/settings/admin)

### [InstaMaps by use case](/for)

[Lead distance](/for/lead-distance)[Circle prospecting](/for/circle-prospecting)[Door knocking](/for/door-knocking)[Cleaning schedules](/for/cleaning-business-scheduling)[Field service routes](/for/field-service-routes)[Sales territories](/for/sales-territory-mapping)[Driving for dollars](/for/driving-for-dollars)[Site verification](/for/site-verification)[Store locators](/for/store-locator)[Property listings](/for/real-estate-listings)[Address cleanup](/for/property-data-cleanup)[Delivery routes](/for/delivery-routes)[Field service](/for/field-service-jobs)[Trip planning](/for/travel-itinerary)[School mapping](/for/school-mapping)[field service](/for/home-care)

 © 2026 InstaMaps. All rights reserved.