- Help
- Batch geocoding guide
How to geocode a spreadsheet
From a file of addresses to latitude and longitude in six steps. The same steps work the other way round, from coordinates to addresses.
Upload your file
Drop an Excel, CSV or TSV file on the upload box, or paste rows straight from Excel or Google Sheets. No account is needed for this part.
- Files up to 1 GB.
- Save CSV files as UTF-8 so accents and other alphabets survive.
- No file at hand? Try the sample with 20 New York addresses.
Choose your columns
Say what you want to do, geocode addresses or reverse geocode coordinates, and check the columns Geloky matched for you.
- Is the first row a header? Switch it off if your data starts in row 1.
- Everything in one column? Choose it as Street address and leave the rest empty.
- Coordinates must sit in two columns, in decimal degrees.
Check the preview on the map
The first rows are geocoded for free and dropped on a map, with the price for the whole file next to them.
- Pins in the wrong place usually mean a column is matched wrongly. Go back and fix it.
- The price is $1 per 1,000 rows, $5 at the least.
Create an account or log in
To process the whole file, sign up with Google or with your email. Your file and your choices wait for you while you do.
Pay, or use your plan
Pay for this one file, or take the rows from your monthly plan. The first 100 rows every day are free.
- Payment goes through FastSpring and confirms within a minute.
- Processing starts by itself; you can close the tab.
Download the results
When the file is ready it waits on your dashboard: download it as CSV or Excel, with latitude and longitude added, or see it on a map and share that map with a link.
- We email you when a big file finishes.
- Free files are kept for 24 hours, paid files until you delete them.
- A paid file's map can be shared: one switch gives a view-only link and the code to put it on your website, with pins coloured by any column. Free files come as CSV only.
Extra columns: time zone, county, census tract, district
Switch on Extra columns on the preview step, and every row gets its time zone and, in the US, its county, census tract, block group and congressional district. With the switch on, an address counts as 2 rows, in the US or not. For a file that already has coordinates and needs no address, choose Time zone, county, district on step 2: a point then counts as 1 row.
Counties, tracts, block groups and districts come from the US Census Bureau’s TIGER/Line boundaries (2026 release); time zones from timezone-boundary-builder, © OpenStreetMap contributors. They are worked out on Geloky’s own server, and the same columns come with the API.
Usually the address is incomplete or misspelled, or holds extra text like a business name or unit number. Fix those rows and upload them again; rows that were not found are not worth paying for, so check the preview first.
Add a Country column, or include the country in the address column. Short addresses like “Main St 5” exist in many countries.
Save the CSV as UTF-8 (in Excel: Save as → CSV UTF-8), or upload the Excel file as it is.
Most files finish within minutes. Very large files take longer; the dashboard shows the progress and we email you when it is done.
Yes. Switch on Extra columns on the preview step: every row gets its time zone, and in the US its county, census tract, block group and congressional district, for one extra row per address.
Yes. The same geocoding is available as a REST API and as an MCP server for AI assistants, at $0.001 per address.
Your first 100 rows are free. Every day.
No credit card · See your results on a map before you pay