Geocoding & Distance Guides
Practical, no-fluff guides for working with addresses and coordinates in spreadsheets: geocoding, reverse geocoding, distance calculation, and honest tool comparisons.
How to Convert Addresses to Latitude and Longitude in Excel
Three working ways to geocode addresses in an Excel spreadsheet: a no-code batch upload, Excel formulas with a geocoding API, and Power Query — with the limits of each.
Read the guide →How to Batch Geocode a CSV File Free (No Code)
Step-by-step: turn a CSV of addresses into latitude/longitude coordinates without writing code, and what the free options really allow.
Read the guide →How to Geocode Addresses in Google Sheets
Two ways to get coordinates into Google Sheets: an Apps Script custom function, or exporting to CSV and batch geocoding — and when each makes sense.
Read the guide →Bulk Reverse Geocoding: Convert Coordinates to Addresses
How to turn a spreadsheet of latitude/longitude points (GPS logs, telematics, field data) back into readable addresses, in one batch.
Read the guide →How to Calculate the Distance Between Addresses in Excel
The haversine formula for coordinates, why addresses need geocoding first, and how to compute driving distances for a whole spreadsheet at once.
Read the guide →Google Maps Geocoding API Alternatives (2026)
When the Google Geocoding API is not the right fit — pricing model, terms, code requirement — and honest alternatives: Geloky, Nominatim/OSM, Geocodio, Geoapify, Mapbox, ArcGIS.
Read the guide →Best Free Batch Geocoding Tools Compared
A practical comparison of free ways to geocode address lists: Geloky, Geocodio, BatchGeo, QGIS, and self-hosted Nominatim — limits, formats and when to pay.
Read the guide →Geloky vs Geocodio vs BatchGeo: Which Fits Your Task?
Three tools, three different jobs: spreadsheet-first global geocoding, US-focused API geocoding, and map making. An honest guide to choosing.
Read the guide →Geocoding Real Estate Listings: From Spreadsheet to Map
How brokerages and proptech teams convert listing addresses to coordinates for portals, maps and analysis — and the address-quality traps to avoid.
Read the guide →Cleaning and Geocoding Delivery Addresses for Logistics
A workflow for delivery and field-service teams: standardize the address list, geocode it in batch, then compute distances to depots or between stops.
Read the guide →