How to Find the Nearest Location for Each Address in Google Sheets
Find the closest store, technician or office for every address in a list, using real drive times in Google Sheets with no API key or code.
Tutorials
How to Make a Distance Matrix in Google Sheets (No API Key)
Build a grid of distances or drive times from every starting location to every ending location in Google Sheets, with no API key or code.
How to Find the Driving Distance Between Two Addresses in Google Sheets
The short answer: Google Sheets has no built-in function for driving distance. A formula can only work out the straight-line distance between two sets of coordinates, so the distance by road has to come from Google Maps, through an add-on or a script. The quickest way is the Travel Formulas add-on: with the start address … Read more
How to Calculate the Total Distance and Time for a List of Addresses in Google Sheets
The short answer: Google Sheets has no built-in function for driving distance, so the total distance and time for a list of addresses has to come from Google Maps through an add-on. Which one depends on your list. If the addresses are the stops of one trip, RouteTally gives you the distance and time of … Read more
How to Plan a Route With More Than 25 Stops in Google Sheets
The short answer: Google plans at most 25 stops per route request, the start and the destination included. To plan a longer route you split the list into legs of 25 that join end to end. RouteTally, a Google Sheets add-on, does that splitting for you: put up to 100 addresses in a column, click … Read more