Geocoding Real Estate Listings: From Spreadsheet to Map
Updated July 7, 2026 · Geloky team
Every listing has an address; almost nothing downstream can use it as text. Map search on your site, the "homes near me" feature, comps analysis, territory splits for agents — all of it runs on coordinates. Here's the workflow proptech teams and brokerages actually use to get from an MLS export or listings spreadsheet to mapped inventory.
The workflow
- Export the listings — from the MLS, CRM or portal backend — as CSV/Excel with the address parts in columns (street, city, state/region, postal code). Keep the listing ID column; you'll join on it later.
- Split out unit numbers. "12 Main St Apt 4B" geocodes worse than "12 Main St". Keep the unit in its own column for display; geocode the building.
- Batch geocode the file with the Geloky geocoding tool: upload, map the address columns, preview the first rows on the map (free), convert, download. 100 records/day free; $1 per 1,000 after — a 10,000-listing book costs $10.
- Review the misses. Sort by empty latitude: typically new developments, misspelled streets, or PO boxes. Fix and re-run just those rows — the free daily tier usually covers the retry.
- Join back and load — coordinates keyed by listing ID go into your portal database, IDX plugin, Tableau/Power BI dashboard, or Google My Maps for a quick shareable view.
Three traps specific to real estate data
- New construction: streets that are months old may not be in map data yet. Expect locality-level results and flag them for manual pinning rather than shipping a wrong rooftop pin to the portal.
- Vanity addresses: marketing names ("The Residences at Park Lane") don't geocode — keep the legal street address in the data.
- Centroid pollution: rows that matched only to city level cluster at the city centroid and make density maps lie. Filter by match quality before analysis.
Beyond the map
Once listings have coordinates, the follow-on questions are distance questions: how far is each property from the office, the school, the coast? Batch-compute those with the distance calculator — origins column (listings), destinations column (points of interest), driving or straight-line, whole file at once. And if you're regularly re-geocoding fresh inventory, the REST API automates the loop your spreadsheet workflow proved out.