I will geocode addresses and reverse geocode coordinates
Data engineer specialized in geospatial data
About this Gig
Have a spreadsheet full of addresses with no coordinates? Or coordinates with no addresses? I'll handle both.
I'll run your data through a geocoding pipeline and deliver a clean file with results and a match status for every row so you know exactly what was found and what wasn't.
What you send me:
A CSV or Excel file with an address column or a file with lat/lon columns for reverse geocoding.
What you get back:
- Geocoding: latitude, longitude, and match_status added to every row
- Reverse geocoding: address column added to every row
- Nothing is silently dropped failed rows are clearly marked
I use:
- Nominatim (OpenStreetMap) free, no API key needed
- Google Maps higher accuracy, better international coverage (you provide your own API key)
Delivery includes:
- Output file in your preferred format
- Summary report: total rows, success count, failure count, success rate
- Notes on any rows that failed and why
- Duplicate addresses are detected and geocoded once
Technology:
Python
Expertise:
Transformation
My Portfolio
FAQ
What format does my file need to be in?
CSV or Excel (.xlsx). For geocoding, provide an address column. For reverse geocoding, provide latitude and longitude columns.
What if some rows fail?
Every failed row is marked as "failed" with null values. Nothing is silently dropped. I'll include notes on likely causes.
Do I need to share my Google Maps API key?
Only if you choose Google Maps. Create a restricted key just for this order and revoke it after delivery. Nominatim needs no key.
Can you handle addresses outside of English?
Yes, but accuracy depends on the provider and region.
Can you clean up my addresses before geocoding?
Yes. I can normalize your addresses before geocoding such as expanding abbreviations (St → Street, Ave → Avenue), strip extra whitespace, and append a missing country. This is available as an add-on. Message me to include it in your order.
Can I get the results as a map-ready spatial file instead of CSV?
Yes. I can deliver results as a GeoJSON, GeoPackage, or Shapefile point layer. Each successfully geocoded row becomes a point geometry ready to load into QGIS, PostGIS, or any GIS tool. Available as an add-on. Please mention it when ordering.
What if Nominatim can't find some of my addresses?
I can run a second pass on failed rows using Google Maps as a fallback provider. This recovers matches that Nominatim misses, especially for less common or international addresses. You'll need to provide a Google Maps API key. Available as an add-on.

