How to create a Waze link from spreadsheet data

To create a Waze link from spreadsheet data, install the InstaMaps add-on for Google Sheets and use the =WAZE_LINK(A2) formula, replacing A2 with your address cell. The cell outputs a clickable URL that opens the Waze app directly on your phone for immediate turn-by-turn navigation.

This workflow is designed for field sales representatives, delivery drivers, and real estate agents who manage daily routes in spreadsheets. By the end of this guide, you will have a mobile-friendly sheet that transforms static addresses into tap-to-navigate cells, allowing you to chain multiple stops together without retyping data into your phone.

What you need to generate navigation links

You need a Google Sheet containing your addresses and the InstaMaps add-on installed. InstaMaps provides 100 free daily lookups for mapping and routing functions. If you require higher volume, you can reach 1,000 lookups per day with a free email unlock.

Once installed via the Google Workspace Marketplace, you access the tools through the sidebar (Extensions > InstaMaps > Formulas). This menu inserts formulas without typing, ensuring syntax is always correct. You can also grab pre-built sheets from get-instamaps.com/templates to skip the setup phase entirely.

Step 1: Clean address formatting

Address data copied from CRMs or typed manually is often inconsistent, containing formatting errors or missing postcodes. Before generating navigation links, standardise your data. The CLEAN_ADDRESS function processes raw text and returns a properly formatted address.

If you have raw addresses in column A, place the formula in column B. The output ensures mapping services accurately pinpoint the location, preventing drivers from being routed to the wrong part of town due to a missing directional suffix or abbreviation.

1. Formula: =CLEAN_ADDRESS(A2)

2. Example input (A2): 10 downing st, westminster

3. Result (B2): 10 Downing Street, London SW1A 2AA

Step 2: Create a single-destination Waze link

To generate a single destination link, use the WAZE_LINK formula. If your cleaned address sits in cell B2, applying =WAZE_LINK(B2) generates a standard waze.com URL. This creates a direct tap-to-navigate cell for mobile users.

Many field workers operate primarily from their mobile devices. Typing complex addresses into small touchscreens leads to errors and wasted time at the wheel. With this formula, you simply open the Google Sheets app on your phone, tap the cell containing the link, and the operating system hands off the destination directly to the Waze application.

1. Formula: =WAZE_LINK(B2)

2. Example input (B2): 10 Downing Street, London SW1A 2AA

3. Result (C2): https://waze.com/ul?q=10%20Downing%20Street%2C%20London%20SW1A%202AA

Step 3: Build an 11-stop route link

For days with multiple stops, creating individual links is inefficient. The ROUTE_LINK formula accepts a range of cells and uses the official Google Maps URL scheme to build a multi-stop route.

If your addresses are in cells B2 through B12, applying =ROUTE_LINK(B2:B12) produces a single URL that plots all 11 addresses in order. Google Maps officially caps multi-stop routes at 10 intermediate stops plus a final destination. The formula adheres strictly to this limit, ensuring the link never breaks. The link respects the exact order of the cells in your range.

1. Formula: =ROUTE_LINK(B2:B12)

2. Example input (B2:B12): A vertical list of 11 addresses

3. Result: A single clickable URL that opens Google Maps with all 11 stops queued for navigation

Worked example: A 47-stop property maintenance route

Let us look at a realistic scenario involving a regional property maintenance company. They manage a farm of 200 homes and coordinate 5 different maintenance crews. Today, Crew A is assigned 47 different properties to service across the city. They use a single Google Sheet to track all assignments.

First, the dispatcher lists the 47 raw addresses for Crew A in column A, then uses =CLEAN_ADDRESS(A2:A48) to standardise the formatting in column B. Because 47 stops exceed the 11-stop route limit for a single navigation link, they must break the journey into legs.

They use the =VISIT_ORDER(B2:B48) function in column C. This function evaluates the proximity of the locations and reorders the 47 addresses into a logical, optimised driving sequence. Next, they break the optimised list into manageable chunks. They use =ROUTE_LINK(C2:C12) to create Leg 1 (stops 1 through 11), =ROUTE_LINK(C13:C23) for Leg 2, and so on until all 47 stops have a dedicated route link.

Finally, they use =INSTAMAP(C2:C48) to generate a live, hosted shareable map URL. The dispatcher monitors this map from the office, which updates automatically if a property is marked as complete or skipped in the spreadsheet.

Limits and honest alternatives

Spreadsheet mapping is highly effective but has specific technical constraints. InstaMaps caps free usage at 100 daily lookups (expandable to 1,000/day with a free email unlock). Processing thousands of rows simultaneously will exceed these limits and cause formula errors.

Furthermore, ROUTE_LINK relies on Google Maps, which strictly limits multi-stop routes to 11 stops. If you attempt to pass 20 addresses to the formula, the link will fail or truncate the list. For solving complex travelling salesperson problems with zero limits, dedicated routing software like Onfleet or RouteXL is genuinely better.

Those dedicated platforms use proprietary algorithms to calculate drive times with far more variables, like vehicle capacity or time windows, than a spreadsheet can handle. Use InstaMaps for rapid, cost-free deployment and standard daily workflows. Use dedicated software when you are running a massive national logistics operation.

Common Questions