Use the =INSTAMAP() function to generate a live, hosted map URL directly inside a cell. Provide a range of coordinates or geocoded addresses as the argument, and the add-on outputs a clickable link that renders a web map. This link updates automatically whenever the underlying sheet data changes.
This tool is built for operations managers, logistics coordinators, and field team leads tracking a 200-home farm, 5 crews, or 47 delivery stops. The end state is a static shareable URL you can paste into an email or Slack channel, giving stakeholders a live view of your spreadsheet locations without requiring them to open the file.
- →=INSTAMAP turns a range of spreadsheet coordinates or addresses into a hosted, shareable map URL inside a single cell.
- →The generated map is dynamic: if you edit, add, or delete rows in the source range, the hosted map updates automatically.
- →Syntax requires only a range of locations (e.g., A2:A500); optional arguments control map titles and default views.
- →If the cell returns #NAME?, the InstaMaps add-on is not installed or enabled.
- →This formula is the final step in location analysis chains, typically placed after =GEOCODE or =SORT_BY_DISTANCE.
Syntax and arguments
=INSTAMAP(location_range, [label_range], [zoom_level])
The =INSTAMAP function accepts a range of cells containing location data and returns a string containing a hosted URL. This URL renders an interactive web map that reads directly from your spreadsheet. Any structural changes to the source data, such as adding rows to a property portfolio or updating coordinates, automatically reflect on the hosted map when the link is refreshed. The function processes arrays natively, meaning it accepts outputs from other InstaMaps functions directly without requiring manual copying or pasting.
location_range (Required): Range. The cells containing decimal coordinates (latitude/longitude pairs), physical street addresses, or geographical outputs from functions like =GEOCODE to be plotted on the map.
[label_range] (Optional): Range. A corresponding array of cells containing text strings to display as marker titles when a user clicks a pin on the hosted map.
[zoom_level] (Optional): Number. An integer defining the default zoom scale (0 to 21) of the hosted map when the URL is first opened in a browser.
How to add =INSTAMAP to your sheet
You can insert the formula directly into any empty cell. Select your target cell, such as D1, and type =INSTAMAP(B2:B100). Press Enter. The cell populates with a https://get-instamaps.com/m/... URL. Because this operates as a dynamic formula, the URL string remains constant in the cell, but the map it renders pulls the live state of column B every time the link is opened. If you delete rows or correct coordinates in the source range, the hosted map requires no manual updating or recopying of links.
To eliminate syntax errors and speed up deployment, use the InstaMaps sidebar. Navigate to Extensions > InstaMaps > Enable formulas to open the panel. Highlight your intended data range in the sheet. The sidebar detects the selected range and provides an interface to generate the map link without typing.
For complex chains combining multiple functions, the Build-the-workflow button generates the entire sequence automatically. This is useful when preparing large datasets that require geocoding before mapping.
1. Highlight your source data, such as a column of 200 street addresses in A2:A201.
2. Open the sidebar via Extensions > InstaMaps > Enable formulas.
3. Click the Build-the-workflow button.
4. The system writes the =GEOCODE helper columns to convert the addresses into coordinates, then inserts the final =INSTAMAP formula into your target cell, properly referencing the generated coordinate data.
Worked examples
Scenario 1: 200-home property portfolio. A regional property manager oversees a spreadsheet of 200 residential homes. The street addresses are typed into A2:A201. To generate coordinates for the map, the manager runs =GEOCODE(A2:A201) in columns B and C (Latitude and Longitude). In cell E1, the manager enters =INSTAMAP(B2:C201, A2:A201). This generates a URL mapping all 200 properties. The optional second argument (A2:A201) ensures the hosted map markers display the exact street address when clicked. If the manager acquires two new properties and appends them to rows 202 and 203, changing the formula to =INSTAMAP(B2:C203, A2:A203) instantly updates the hosted map to display 202 pins.
Scenario 2: 47-stop delivery sequence. A local courier needs to map an optimised delivery route. The destination addresses sit in A2:A48. Column B uses =VISIT_ORDER(A2:A48) to sequence the stops numerically based on driving proximity, outputting ordered coordinates. The dispatcher needs the map to reflect this exact sequence. By placing =INSTAMAP(B2:B48) in cell E1, the resulting URL plots the 47 stops in the calculated order. If a customer cancels and row 15 is deleted, the sheet shifts the data up, =VISIT_ORDER recalculates the new shortest path, and the hosted map immediately reflects the new 46-stop sequence.
Scenario 3: 5 closest technicians. An operations manager dispatches field technicians across a city. Their live locations are pinged to the sheet and stored in C2:C51. An emergency request originates from coordinates listed in cell H1 (51.5074, -0.1278). Column D uses =CLOSEST_TO(C2:C51, H1, 5) to list the five nearest technicians' coordinates. The manager wants to map only these specific five resources. In cell G1, they input =INSTAMAP(D2:D6). The map generates a view of just those five coordinates. If a technician drives out of range and their coordinates update in column C, their position shifts on the hosted map in real time as the sheet recalculates.
Common errors
The most frequent issue is the #NAME? error in the cell. This occurs when Google Sheets does not recognise INSTAMAP as a valid function. It indicates the InstaMaps add-on is not installed, is disabled, or lacks permission to run. Ensure you have installed the add-on and activated it via Extensions > InstaMaps > Enable formulas. You can read more about resolving custom function failures in our dedicated google-sheets-geocode-formula guide.
You may encounter quota messages such as "Daily limit exceeded" returned inside the cell. The free tier of InstaMaps permits 100 lookups per day (1,000/day with a free email unlock). If your range requires processing new, ungeocoded addresses beyond this limit, the map will fail to render the new pins. Mapping existing coordinates via =INSTAMAP does not consume lookups, but the underlying functions like =GEOCODE generating those coordinates do.
If source cells contain invalid coordinates instead of valid decimal pairs or map links, =INSTAMAP drops those markers from the hosted map. However, if your range points to #VALUE! errors produced by a failed execution due to a malformed address, the hosted map ignores the broken cell. You must ensure your source columns strictly contain numerical coordinate pairs (e.g., 40.7128, -74.0060) separated by commas, or properly formatted addresses, for the map to plot them accurately.
Composes with
You rarely pass raw text directly into =INSTAMAP(). The function is designed to read a prepared range of coordinates and labels. The sidebar (Extensions > InstaMaps > Enable formulas) includes a Build-the-workflow button that writes these chains for you, or you can type them manually.
Chain 1: Address cleansing and geocoding pipeline. Start with raw addresses in column A (A2:A200). First, standardise the text in column B: =CLEAN_ADDRESS(A2:A200). Next, generate coordinates in column C: =GEOCODE(B2:B200). Finally, publish the map in cell E1: =INSTAMAP(C2:C200, B2:B200). When a new address is typed into A201, the CLEAN_ADDRESS and GEOCODE columns calculate automatically. Because the INSTAMAP cell points at C2:C200, the hosted map URL updates with the new markers without requiring you to regenerate the link. This chain processes up to 1,000 rows per day if you have unlocked the free 1,000 lookups/day tier via email.
Chain 2: Distance sorting and visualisation. Assume you have 47 potential delivery stops with coordinates in B2:B48 and your depot's location in cell H1. Calculate driving distances in column D: =DISTANCE_MATRIX(H1, B2:B48). Rank the stops by driving time in column E: =SORT_BY_DISTANCE(B2:B48, D2:D48, "ascending"). Map the optimised route in cell G1: =INSTAMAP(E2:E48). By pointing INSTAMAP at the sorted output in column E rather than the raw input in column B, your live map displays markers in exact driving order. If a stop is cancelled and deleted from row 14, DISTANCE_MATRIX recalculates, SORT_BY_DISTANCE reorders the list, and the hosted INSTAMAP link immediately reflects the new 46-stop sequence.
Limits and honest alternatives
=INSTAMAP() renders up to 5,000 markers per hosted map URL. Processing large coordinate arrays requires the sheet to recalculate, which can take several seconds on older machines. While the function generates a standalone web map, it does not provide turn-by-turn navigation within the hosted environment. For navigation, you should use =ROUTE_LINK() instead.
=ROUTE_LINK(A2:A12) uses Google Maps' official URL scheme to generate a standard Google Maps link containing a maximum of 11 stops. You can click this link from a mobile device to load the route directly in the Google Maps app. Use ROUTE_LINK for a field crew driving a specific sequence; use INSTAMAP for a desktop dashboard overview of an entire 200-home farm.
Alternatively, Google My Maps remains a strong choice for static data. If you need to draw custom polygon boundaries over your markers or permanently store historical trip data, exporting your Google Sheet as a CSV and importing it into Google My Maps is preferable. However, My Maps does not update dynamically. Any change to your spreadsheet data requires a manual re-import. INSTAMAP exists specifically to bridge this gap, providing a shareable URL that reflects live sheet edits.
Who this is for
Operations managers tracking a 50-vehicle fleet: You need a central dashboard that reflects live location updates without paying for enterprise mapping software. By logging coordinates in a Google Sheet and publishing =INSTAMAP(), you generate a URL that dispatchers can monitor throughout the day.
Logistics coordinators optimising delivery zones: You are segmenting a 5-crew roster across a metropolitan area. By chaining =SORT_BY_DISTANCE() into =INSTAMAP(), you can generate five distinct map URLs-one for each crew's specific assigned cluster-ensuring drivers see only their relevant stops. Pre-built versions of these setups are available at get-instamaps.com/templates.
Data analysts visualising spatial spreadsheets: You are mapping 2,000 customer records to identify density clusters. Rather than exporting CSVs to third-party GIS software, you use =INSTAMAP() to render the data directly from your working spreadsheet. When you filter or clean the sheet, the hosted map updates immediately.
Who this is not for: Users who require offline mapping, custom-drawn polygon overlays (use Google My Maps), or turn-by-turn voice navigation for more than 11 stops (use a dedicated routing application).
Map your Salesforce accounts in under 5 minutes — no admin setup.
Common Questions
Type =INSTAMAP(A2:A50) in any cell, replacing the range with your latitude and longitude columns. Press Enter to generate a clickable, hosted URL that renders your data on a web map. You can also use open-ended arrays like =INSTAMAP(A2:A) to capture future sheet additions. The add-on must be installed from the Google Workspace Marketplace for the function to execute properly.
The #NAME? error indicates that Google Sheets cannot find the InstaMaps custom function, meaning the add-on is not installed in your current document. You must install it from the Google Workspace Marketplace or activate it via Extensions > InstaMaps > Enable formulas. Once the add-on is active, refresh the sheet to allow the script permissions to load. You can learn more about this specific issue in our related guide on resolving the name-error.
The =INSTAMAP() formula itself does not enforce a strict row limit, allowing you to map hundreds of coordinate pairs simultaneously. However, browser performance may degrade if you attempt to plot thousands of rows on a single web map. If your points rely on address geocoding, remember the free tier limit of 100 lookups per day, which increases to 1,000 with a free email unlock. For massive datasets, consider filtering your sheet to display only active rows.
Yes, the hosted map URL dynamically reflects changes made to your spreadsheet. If you add new rows to a range referenced by =INSTAMAP(A2:A100), or use an open-ended range like =INSTAMAP(A2:A), the map will include the new coordinates. The URL remains identical, so you do not need to distribute a new link to your 5 crews or stakeholders. Changes typically reflect on the web map within moments of saving the cell.
While you can pass addresses, it is highly recommended to use the google-sheets-geocode-formula function to convert them to coordinates first. Passing raw text addresses forces the map to process geocoding requests on the fly, which can quickly exhaust your daily quota. By placing =GEOCODE(A2) in an adjacent column and pointing =INSTAMAP() at the output, you cache the coordinates. This ensures your 47 stops load instantly on the hosted map without redundant daily calculations.
Install the free InstaMaps add-on to start turning your spreadsheet rows into shareable, hosted map URLs.
Install InstaMaps free