WAZE_LINK Function: Generate Waze Links and Street View from Google Sheets

The =WAZE_LINK() formula in Google Sheets turns location data into clickable navigation URLs formatted specifically for Waze. Provide a cell reference or an address string, and InstaMaps outputs a https://waze.com/ul?... link, allowing drivers to bypass manual address entry entirely.

Built for dispatchers, delivery drivers, and field service crews, this function connects spreadsheet planning to in-cab navigation. Instead of copy-pasting coordinates into a phone, your team clicks a generated URL to drop a pin directly into their preferred turn-by-turn app.

Syntax and Arguments

Syntax: =WAZE_LINK(location)

Generates a direct navigation URL formatted for the Waze routing engine. This function outputs a standard hyperlink string that triggers turn-by-turn driving directions when selected on a mobile device or desktop browser.

When passed an array of cells, such as =WAZE_LINK(A2:A50), the function automatically expands, returning a spilled array of individual navigation URLs matching the range's height.

1. location (required): The destination address, place name, or coordinate pair.

2. Accepted data types: String literals enclosed in quotation marks (e.g., "10 Downing Street, London"), numerical coordinates, or standard cell references.

3. Coordinate format: Expects decimal degrees structured as "Latitude, Longitude" (e.g., "51.5034, -0.1276").

Step-by-Step: Inserting WAZE_LINK

1. Open your Google Sheet and click Extensions > InstaMaps > Enable formulas in the top menu.

2. Highlight the target cell where you want the navigation link to appear.

3. In the right-hand InstaMaps sidebar, scroll to the Navigation section.

4. Select WAZE_LINK from the function list.

5. Highlight the cell containing your target destination (for instance, B2) to automatically populate the formula argument.

6. Click Insert to place =WAZE_LINK(B2) into your sheet.

For larger datasets, manual typing leads to syntax errors. Instead, use the Build-the-workflow button located at the bottom of the sidebar. This tool writes whole chains for you. If you have a column of addresses in A2:A201 and need to generate Waze links alongside them, the workflow builder automatically applies the array logic and manages the row referencing.

This builder is particularly useful for joining formulas. You can instruct the builder to run [the geocoding formula](/google-sheets-geocode-formula) in column B, generate =WAZE_LINK(B2:B201) in column C, and compile =INSTAMAP(C2:C201) to host a live map of all your destinations. This ensures every bracket and comma is placed correctly.

Worked Examples: Real-World Scale

Example 1: 47-Stop Delivery Route

A regional courier needs to distribute a daily manifest of 47 drop-offs. Column A lists the order numbers (A2:A48), and Column B contains the destination street addresses. To generate a list of individual Waze links for the driver's mobile device, enter the following formula in cell C2:

=WAZE_LINK(B2:B48)

This outputs a vertical array of 46 distinct URLs. Because =ROUTE_LINK() uses Google Maps' official URL scheme and restricts routes to a maximum of 11 stops, generating individual links via =WAZE_LINK() provides a more reliable fallback for dense manifests exceeding that limit.

Example 2: 200-Home Survey Farm

A field operations team is assessing a 200-home neighbourhood. The raw addresses are stored in D2:D201. The surveyors require both driving directions and a visual reference of the property before arrival. In cell E2, you can concatenate the Waze link with the family function =STREETVIEW_LINK() using an array formula:

=ARRAYFORMULA(WAZE_LINK(D2:D201) & " | " & STREETVIEW_LINK(D2:D201))

This generates a two-part string in each row of column E. Clicking the first half routes the driver, and clicking the second half drops them into the street-level panorama. To visualise this entire farm geographically, pass the original addresses into the mapping function: =INSTAMAP(D2:D201), which returns a live hosted shareable map URL that updates when the sheet changes.

Example 3: Dispatching 5 Service Crews

A municipality dispatches 5 plumbing crews across a county. Column F (F2:F6) contains the raw latitude and longitude coordinates for the morning jobs, previously generated by =GEOCODE(). Because Waze natively accepts coordinates, you do not need to reverse the data back into text addresses. In cell G2, input:

=WAZE_LINK(F2:F6)

This produces five distinct URLs. If the morning priorities shift, apply =SORT_BY_DISTANCE() or =VISIT_ORDER() to reorganise the coordinates in column F before passing them to =WAZE_LINK(), ensuring the dispatch list reflects the most efficient path.

Common Errors and Troubleshooting

The #NAME? Error

If your cell displays #NAME?, Google Sheets does not recognise the formula. This occurs when the InstaMaps add-on is not installed or enabled in the current document. The add-on is free, but it must be linked to the workbook. See our dedicated #NAME? error resolution post to install the extension and activate the custom functions. Once installed, the #NAME? error will disappear upon page refresh.

Quota Messages

The =WAZE_LINK() function itself is a string constructor and does not consume API credits. However, if the location argument relies on another function, such as =GEOCODE() or =REVERSE_GEOCODE(), you are bound by daily lookup limits.

On the free tier, the limit is 100 lookups/day. When you process the 101st address, the cell will return a specific quota message: "Daily limit reached (100/100). Verify email for 1,000/day." Registering with a free email unlock raises this ceiling to 1,000 lookups/day. If you attempt to process a 1,500-row sheet, the first 1,000 coordinates will calculate, and the remaining 500 will display the quota message until the 24-hour limit resets.

Coordinate Formatting Errors

If you pass raw coordinates into =WAZE_LINK() and the resulting URL points to the middle of the ocean, check the data order. The function expects "Latitude, Longitude" (e.g., "51.5074, -0.1278"). If your sheet separates coordinates into two columns, combine them using an ampersand: =WAZE_LINK(H2 & ", " & I2). For postcode-based errors, run =CLEAN_ADDRESS() to verify the formatting before generating the link.

Composes With: Building Navigation Chains

InstaMaps functions are designed to pass outputs directly into the next formula's inputs. You do not need to copy and paste values between columns. If a workflow requires generating precise driver navigation, you can pipe raw address text through =GEOCODE() into =WAZE_LINK().

Consider a sheet tracking 5 service crews across 200 daily job sites. Column A holds raw customer addresses (A2:A201). In Column B, you convert these to coordinates to resolve any formatting ambiguities using =GEOCODE(A2:A201). In Column C, you generate the routing links by referencing the coordinates: =WAZE_LINK(B2:B201). The dispatcher now has clickable URLs mapped perfectly to verified latitude and longitude data, avoiding errors from misspelt street names.

For complete dispatch packets, combine =WAZE_LINK() with =STREETVIEW_LINK(). When managing a 47-stop inspection route, text addresses lack visual context for drivers unfamiliar with the drop-off points. You can provide both drive-to navigation and arrival visuals side by side.

Assuming addresses sit in A2:A48, Column B contains =WAZE_LINK(A2:A48) and Column C contains =STREETVIEW_LINK(A2:A48). The output provides two distinct URLs: one opens the Waze app to begin turn-by-turn routing, and the second opens Google Street View at the exact location so the driver can identify parking constraints or gate codes before they arrive. Using the InstaMaps sidebar (Extensions > InstaMaps > Enable formulas), you can click the Build-the-workflow button to write these multi-column chains automatically.

Limits and Honest Alternatives

=WAZE_LINK() is optimised for single-stop, driver-initiated navigation. It takes a destination address or coordinate and generates a URL that opens the Waze app directly. It does not string multiple stops together into a single turn-by-turn sequence.

If your use case requires sending a driver a sequence of stops along a predetermined path, use =ROUTE_LINK() instead. The =ROUTE_LINK() function uses Google Maps' official URL scheme, which supports a maximum of 11 stops (one origin, one destination, and up to 9 waypoints). It builds a single URL that opens Google Maps with the entire route pre-loaded.

Use =WAZE_LINK() when drivers select their own order from a list of 20 available pickups. Use =ROUTE_LINK() when you have already optimised a sequence using =VISIT_ORDER() or =SORT_BY_DISTANCE() and need to send the driver a rigidly structured route. Both formulas operate within the free tier, which permits 100 lookups per day (increasing to 1,000 lookups per day with a free email unlock).

Who This Is For

This formula fits specific operational needs within Google Sheets.

1. Logistics dispatchers: Managers routing 50+ daily freight pickups who need fast, one-click URL generation for drivers navigating via the Waze app.

2. Field service coordinators: Teams scheduling 5 to 10 daily maintenance stops where drivers prefer Waze traffic routing but require accurate coordinate data sourced from =GEOCODE().

3. Real estate agents: Professionals managing 30 to 40 daily property showings who need to generate both =WAZE_LINK() and =STREETVIEW_LINK() columns to send clients immediate drive-to and arrival visuals.

Common Questions