How to Batch Geocode a CSV File Free (No Code)

Updated July 7, 2026 · Geloky team

You have a CSV full of addresses and you need coordinates — for a map, a delivery tool, a BI dashboard, or a database import. Here is the shortest path from CSV to latitude/longitude, plus what "free" genuinely covers.

The 5-minute route

1. Check the CSV. One address per row. Both layouts work: a single column ("1600 Pennsylvania Ave NW, Washington, DC 20500") or split columns (street, city, state, zip, country). Split columns usually match better.
2. Upload the file at geloky.com/geocoding. No account or credit card required to start.
3. Map columns — point the tool at your address column(s).
4. Preview free. The first rows are geocoded and shown on a map immediately. If the pins look wrong, fix the column mapping and re-preview — it costs nothing.
5. Convert & download. The output is your CSV with latitude, longitude and the matched address appended, ready for Excel, Google My Maps, Tableau, Power BI, or a database import.

What "free" actually covers

• Geloky: 100 records per day free, then $1 per 1,000 (pay-as-you-go, $5 minimum) — the free tier resets daily and covers testing and small lists; a 5,000-row file costs $5.
• Other hosted tools (Geocodio, Geoapify, CSV2GEO and friends) each offer some free volume — check their current limits; most are per-day or per-batch caps.
• Public Nominatim (the OpenStreetMap geocoder at nominatim.org) is free but its usage policy allows roughly one request per second and explicitly discourages bulk jobs — it is not a batch tool.
• Self-hosted Nominatim is truly unlimited and free as software, but you'll run a server with a planet-scale database. Worth it for permanent heavy pipelines; overkill for files.

Three things that improve your match rate

• Include the country — "Springfield" exists dozens of times; "Springfield, IL, USA" doesn't.
• Remove unit/apartment noise from the street field ("Apt 4B" often hurts more than it helps).
• Watch the encoding — save as UTF-8 so accented street names survive the trip.

After geocoding

Common next steps: plot the file (Google My Maps and Leaflet both eat CSV with lat/long columns), compute distances between the points, or go the other direction and turn coordinates back into addresses with bulk reverse geocoding.