Batch geocoding
Batch geocode a spreadsheet of addresses
Latitude and longitude for every row of an Excel or CSV file, or addresses for your coordinates. The first 100 rows every day are free.
- 1Upload
- 2Choose columns
- 3Preview on map
- 4Geocode
No file at hand? Try a sample with 20 New York addresses
A sample of your file, geocoded
| Address | Latitude | Longitude | Match |
|---|
Create a free account to geocode this file
Your upload and your choices stay here while you sign up.
Geocode this file
You are logged in as . The file goes to your dashboard, where you pay for it or use your plan's rows.
Sending your file
Keep this tab open until it reaches 100%. Your dashboard opens by itself.
The first rows are checked with Google reCAPTCHA; the Google Privacy Policy and Terms of Service apply.
What you get back
Latitude and longitude for every row
Your file comes back as you sent it, with three columns added: the latitude, the longitude and the address Geloky matched. Untidy addresses are fine; the three below were typed in a hurry.
| Store | Address | Geocoded latitude | Geocoded longitude | Geocoded address |
|---|---|---|---|---|
| Midtown | 350 5th avenue new york | 40.748377 | -73.984854 | 350 5th Ave, New York, New York, 10118 |
| Upper West Side | 200 central park w, ny 10024 | 40.781308 | -73.972817 | 200 Central Park W, New York, New York, 10024 |
| Lower Manhattan | 1 centre st nyc | 40.712980 | -74.003758 | 1 Centre St, New York, New York, 10007 |
- Download it as Excel or CSV. Free files come as CSV.
- Open the finished file on a map and check it at a glance.
- Share a paid file’s map with a link, or put it on your website.
Batch reverse geocoding
Have coordinates instead? Upload them and choose Reverse geocode in step 2. Latitude and longitude go in two columns, in decimal degrees, and every row gets the nearest street address.
| Latitude | Longitude | Geocoded address |
|---|---|---|
| 40.706145 | -74.009087 | 47-57 Wall St, New York, NY, 10005, USA |
| 40.687012 | -73.990215 | 133-147 Smith St, Brooklyn, NY, 11201, USA |
How it works
From spreadsheet to coordinates in four steps
Upload
Drop an Excel (.xlsx, .xls), CSV or TSV file of up to 1 GB, or paste rows from Excel or Google Sheets.
Choose columns
Geloky finds the address columns by their names. One column with the whole address works, and so do separate street, city, state, ZIP and country columns.
Preview on map
The first rows are geocoded free and pinned on a map, next to the price of the whole file. Pins in the wrong place? Fix the columns before you pay.
Geocode
Pay for the file or use your plan’s rows. It runs in the background, and we email you when a big file is ready to download.
Pricing
What a file costs
Free
- 100 rows every day
- Results as CSV, kept for 24 hours
Pay as you go
- $5 minimum per file
- Paid once for that file, no subscription
Monthly
- 75,000 to 6,000,000 rows a month
- 20% back to your API wallet
A file of 3,000 addresses costs $5, the minimum; one of 20,000 addresses costs $20. The tool shows the exact price before you pay. Compare all plans →
Geocode from code or an AI assistant
The REST API geocodes and reverse geocodes single rows or whole batches at $0.001 per address. The MCP server lets Claude, ChatGPT or Cursor geocode a list for you, paid from the same API wallet.
FAQ
Batch geocoding questions
Something else? Write to hello@geloky.com — a person answers within a day.
Batch geocoding finds the latitude and longitude of a whole list of addresses at once, instead of looking them up one by one. It is also called bulk geocoding. On Geloky you upload the list as a spreadsheet and download the same file with the coordinates added.
One file can be up to 1 GB. Big files run in the background: close the tab, and we email you when the file is ready to download. Monthly plans cover up to 6,000,000 rows a month, or unlimited rows.
The first 100 rows every day are free, with no card needed. Above that, a file costs $1 per 1,000 rows with a $5 minimum, paid once for that file, or you take the rows from a monthly plan from $20 a month.
Excel (.xlsx and .xls), CSV and TSV files, or rows pasted from Excel or Google Sheets. Save CSV files as UTF-8 so accents survive. You download the result as Excel or CSV; free files come as CSV.
No. One column with the whole address works, and so do separate columns for street, city, state, ZIP code and country. Geloky matches the columns by their names, and you can change any it got wrong.
A full street address is usually matched to its building or its street; a row with only a town or a postcode gets that town or postcode. The geocoded address column shows what was matched, and you check the first rows on a map before you pay. Rows that can’t be found are left empty.
Yes. Geloky geocodes addresses worldwide, written the way people write them locally. If your list covers several countries, a country column helps.
Yes, that is reverse geocoding. Choose Reverse geocode in step 2: latitude and longitude go in two columns, in decimal degrees like 40.7484 and -73.9857, and every row gets the nearest street address.
Files on the free plan are deleted after 24 hours; paid files stay on your dashboard until you delete them. The details are in the privacy policy.
Guides
More about geocoding spreadsheets
How to Convert Addresses to Latitude and Longitude in Excel
Three 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 guideHow to Geocode Addresses in Google Sheets
Geocode addresses in Google Sheets with the Geloky add-on: =GELOKY formulas or a whole column at once, $0.001 per address. Plus Apps Script and batch upload.
Read the guideBulk 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 guideChoosing a tool? Read Best Free Batch Geocoding Tools Compared or Geloky vs Geocodio vs BatchGeo.