Cleaning and Geocoding Delivery Addresses for Logistics
Updated July 7, 2026 · Geloky team
A wrong address discovered at the doorstep costs a re-delivery; the same wrong address discovered in the spreadsheet costs one edit. For delivery, courier and field-service operations, cleaning + geocoding the address list up front is the cheapest reliability upgrade available. Here's a workflow that fits in a lunch break.
Step 1 — Standardize the columns
- Split into
street,city,region,postal_code,country— separate fields match better than one long string. - Move unit/apartment/floor info to its own column (drivers need it; geocoders don't).
- Fill the country column even for domestic lists — it removes whole classes of ambiguity.
- Deduplicate exact repeats (recurring customers) so you geocode each address once.
Step 2 — Batch geocode and use the misses as a QA report
Upload the file to the batch geocoding tool, map the columns, preview free, convert. Two outputs matter:
- Coordinates for every matched row — the fuel for routing and distance work.
- The unmatched/low-quality rows — this is your bad-address report, before a driver finds out the hard way. Fix the typos and missing postcodes and re-run just those rows (the 100/day free tier usually covers retries).
Step 3 — Turn coordinates into operations
- Distance to depot: upload stops + depot to the batch distance calculator for driving distance and time per stop — with options like avoiding ferries. That's delivery-cost math, zone pricing and honest ETAs.
- Service-area checks: straight-line distance (a one-line spreadsheet formula — see the Excel distance guide) instantly flags out-of-area orders.
- Clustering stops into routes: every route optimizer takes coordinates in; none take raw address text.
Make it a habit, not a project
The teams that win do this on every import: new orders come in, addresses get standardized and geocoded the same day, misses go back to customer service while contact is fresh. Once the spreadsheet loop is proven, the REST API runs the same clean-geocode-flag cycle automatically inside your order pipeline.