Sheets Geocoder guide

How to Prepare Delivery Addresses for Route Planning

Clean, geocode and quality-check delivery stops in Google Sheets before exporting them to route-planning or dispatch software.

Quick answer

Separate delivery instructions from the physical address, preserve an order or stop ID, geocode the address, review failed and approximate points, then export coordinates and operational constraints to the route planner. Geocoding locates stops; it does not optimize their sequence.

Keep location, instructions and constraints separate

Field groupExamples
IdentityStop ID, order ID, customer reference
LocationStreet, city, region, postal code, country
Geocode resultLatitude, longitude, formatted address, status
Service constraintsTime window, duration, vehicle requirement
Driver instructionsEntrance, dock, phone and access notes

Resolve location problems before optimization

  1. NormalizeMove operational notes out of address fields and preserve postal-code zeroes.
  2. GeocodeReturn coordinates, formatted address and status.
  3. ReviewFix no-match rows and inspect campuses, rural roads and commercial complexes.
  4. EnrichAdd service time, time windows, capacity and required vehicle.
  5. ExportSend stable IDs and reviewed locations to the route planner.

Coordinates do not determine the best sequence

A nearest-neighbor sort by straight-line distance ignores roads, one-way streets, bridges, traffic, vehicle capacity and promised time windows. Google's Routes documentation accepts addresses, place IDs or coordinates, while route optimization is a separate service with its own model and billing.

Review operationally expensive mistakes

  • Verify depot, cross-border and high-value stops.
  • Check that the point represents the usable entrance.
  • Do not expose gate codes in public maps.
  • Preserve failed stops rather than silently dropping them.
  • Give dispatchers a documented override process.
  • Keep customer phone and delivery notes out of the geocoding request.

Sources and methodology

Technical claims were checked against the sources below on August 18, 2026. Product limits and third-party pricing can change; verify the live documentation before designing a production workflow.

Common questions

Does geocoding optimize a delivery route?

No. Geocoding converts stops into locations. Route optimization sequences those stops using roads, travel times, capacity, time windows and other constraints.

Should delivery instructions be included in the geocoding address?

No. Keep gate codes, phone numbers, time windows and driver notes in separate fields so they do not interfere with address parsing.

Are latitude and longitude enough for navigation?

They identify a point, but the point may not be the correct entrance or loading area. Critical commercial, campus and rural stops should be reviewed.

Can I use a PO box as a delivery stop?

A PO box is not normally the recipient's physical delivery location. Obtain an appropriate street or facility address.

Start with your own sheet

Geocode your first 100 rows free.

No API key, custom formula, or credit card required.

Install from Marketplace