Examples

Customers by zone

=GEOCODE(A2:A200, "ES", "latlng")
=ARRAYFORMULA(IFS(B2:B200>41.2, "North", B2:B200>39.9, "Centre", TRUE, "South"))

With Spanish or European settings (semicolon as separator):

=GEOCODE(A2:A200; "ES"; "latlng")
=ARRAYFORMULA(IFS(B2:B200>41,2; "North"; B2:B200>39,9; "Centre"; TRUE; "South"))

Put the addresses in A, write the first formula in B2 and the coordinates fill B:C. Then the second one in D2 labels every customer by latitude. Use the longitude (column C) too if your zones run east to west. For a long list use the Geocode a column sidebar instead, which saves the result and never spends quota twice.

Check the precision first: with output "full" the third column says exact, interpolated, center or approximate, and a center point is the middle of a town, not a street.

Distance to the warehouse

=DISTANCE(A2:A50, "Calle Alcalá 50, 28014 Madrid", "driving", "km")

With Spanish or European settings (semicolon as separator):

=DISTANCE(A2:A50; "Calle Alcalá 50, 28014 Madrid"; "driving"; "km")

One row per customer with the driving distance to the warehouse in kilometres. The single address is repeated for every row, and it is geocoded once thanks to the cache. Use "mi" for miles.

Road distances use the routes quota. When a straight line is enough, use "straight": it is computed locally and costs nothing.

Travel time for technicians

=DRIVETIME(B2:B20, C2:C20, "driving", "min")

With Spanish or European settings (semicolon as separator):

=DRIVETIME(B2:B20; C2:C20; "driving"; "min")

In B the address where each technician starts the day, in C the address of the visit: the formula returns the minutes between each pair. Replace "min" with "h" for hours.

The time is the one Google estimates without live traffic. Keep a margin, and do not use it as a promise to the customer.

Order a delivery route

Extensions > Geocode & Maps for Sheets > Pro > Route order
Start row: 2   Round trip: yes   Distance: straight line

With the stops geocoded in a sheet, Route order sorts them by nearest neighbour from the start row and writes an order column with the total distance. A straight line costs no quota; by road it works up to 25 stops. This is a Pro feature, free during the beta.

Nearest neighbour is fast and good enough for a day of deliveries, but it is not the mathematically shortest route. For fleets and tight windows, use a routing tool.

A map of your stores

Extensions > Geocode & Maps for Sheets > Show map
Latitude: B   Longitude: C   Label: A   Group: D

The dialog draws one coloured point per store, with a different colour for each group (for example the region), the store name on click, and clusters from 200 points. Pro adds a link to share it with people who do not have the sheet.

Up to 2,000 points are shown; filter the sheet to see the rest. The OpenStreetMap attribution stays on the map, with the Google notice if the points came from Google.

Export to Google Earth with KML

Extensions > Geocode & Maps for Sheets > Show map > Download KML

You get a .kml file with one placemark per row, named after the label and grouped by the group column. Open it in Google Earth, import it into Google My Maps, or use the GeoJSON download for QGIS and web maps.

The file is built in your browser; nothing is uploaded and no access to your Drive is needed.