NEW Geloky now works inside Claude, ChatGPT and Cursor. See how Geloky inside Claude & ChatGPT →
  1. Help
  2. 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.

1

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.
Drop your spreadsheet hereBrowse filesExcel, CSV or TSV
2

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.
AStoreNot used
BStreetStreet
CCityCity
DZIPZip
Columns are found automatically; change any that are wrong.
3

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.
The first rows, checked on a map before you pay.
4

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.

Continue with Google
or with email
you@company.com
Create account and continue
5

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.
Price$5.00
Pay $5Use plan rows
Payment confirms within a minute.
6

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.
nyc-stores.xlsx
Geocoding · Ready
CSVXLSXMap

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.

Time zoneThe time zone’s name, such as America/New_York. Every row that was found gets one, in any country.
UTC offsetIts offset from UTC in standard time, such as -05:00.
Daylight savingyes when the clocks change for summer, no when they don’t, as in Arizona.
CountyThe county’s name as the US Census writes it: New York County, Orleans Parish, Anchorage Municipality. US only, as are the columns below it.
County FIPSIts 5-digit code: 2 digits for the state, 3 for the county.
Census tractThe 11-digit code of the 2020 census tract: state, county and tract. Banks give it for every loan in HMDA and CRA reports.
Block groupThe 12-digit code of the block group inside the tract.
Congressional district (120th Congress)Such as NY-12. A state with one seat reads AK-AL; DC and the territories, their delegate’s district.
Match levelHow exact the match is: building, street, place, road, postcode, city or region; a point from your file reads point. County, tract and district are filled for building, street, place and point only: a postcode or a city lands on a centre point, which can lie in another county.

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.

FAQ

Common questions

Still stuck? Write to hello@geloky.com — a person answers within a day.

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.

Your first 100 rows are free. Every day.

No credit card · See your results on a map before you pay