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.
🔒 Your data stays in your sheet • 🗺 The flagship trick: turn any sheet into a live map • ✅ Free tier, no card
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.
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.
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.
Rename the Tab
Name your data tab starting with layer_ — for example layer_Stores. Then open the InstaMaps add-on and click Load Map.
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.
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.
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 Map
24,000+ US pickleball courts — find courts near you, by state.
Dog Parks Map
8,000+ US off-leash dog parks — find one near you, by state.
Padel Courts Map
12,000+ padel courts worldwide, by country — Spain to Sweden.
US Lighthouse Map
800+ US lighthouses, from Maine to the Great Lakes to the Pacific.
National Parks Map
Every US national park, with year founded and annual visitors.
NFL Teams Map
All 32 NFL teams and their stadiums.
Get mapping tips — no spam
One email when we publish a new playbook. That's it.