To create a store locator from a Google Sheet, format your addresses in one column and use =GEOCODE(A2:A150) to generate coordinates. Then, use =INSTAMAP(C2:C150, B2:B150) in another cell to produce a live, hosted URL linking to an interactive map of those coordinates.
This workflow is for local businesses, franchise operators, and regional managers who need a customer-facing map without maintaining a dedicated database or paying for an embedded widget subscription. The end state is a shareable URL that automatically reflects sheet edits within seconds.
TL;DR
- →Embedded store locator widgets often charge monthly fees and lock you into rigid designs, whereas a Google Sheet provides a flat, easily updatable database.
- →InstaMaps is a free Google Sheets add-on that converts your address data into a live hosted shareable map URL using the =INSTAMAP() formula.
- →You can access a free tier of 100 lookups per day, which increases to 1,000 per day with a free email unlock.
- →The InstaMaps sidebar (Extensions > InstaMaps > Enable formulas) inserts formulas without typing, and its Build-the-workflow button writes whole chains.
- →=INSTAMAP() returns a hosted URL that automatically updates when you add new rows or change addresses in your sheet.
- →Templates are available at get-instamaps.com/templates to help you structure your location data immediately.
Embedded store locator widgets vs Google Sheets
Most dedicated store locator vendors charge a monthly subscription fee to host a JavaScript widget on your domain. You upload a CSV file to their portal, and they provide an