NEW Geloky now works inside Claude, ChatGPT and Cursor. See how Geloky inside Claude & ChatGPT →
  1. Help
  2. Nearest location guide

How to find the nearest location for every customer

The nearest store, warehouse or office for every row of a customer list, in six steps. You add two lists, your customers and your locations, as addresses or as coordinates.

1

Add your two lists

Your customers go in the first box and your locations in the second: stores, warehouses or offices, up to 500, each with a name. Drop a file on each box or paste the rows.

  • Each list can be addresses or latitude and longitude, and the two don’t have to match: customers as addresses and stores as coordinates works.
  • One Excel file with two sheets works too: pick the sheet for each list.
  • Other columns, like customer numbers, come back unchanged.
Customers2,350 rows
Locations6 stores
2

Choose your columns

For each list, tell Geloky whether it holds addresses or coordinates, and check the matched columns. Locations also need the column with their names.

  • An address can sit in one column, or be split into street, city, state, zip and country columns.
  • Coordinates: a latitude column and a longitude column.
  • Each customer gets the name of its nearest location back, so give every location its own name, like “Chelsea store”.
Customers · column BAddress
Customer address
Locations · column AStore
Location name
Locations · column BAddress
Location address
Columns are found automatically; change any that are wrong.
3

Preview and choose how to measure

The first 5 customers are matched for free and drawn on a map, each joined to its nearest location. Choose the nearest by drive time or by road distance, by car, on foot or in a straight line, and miles or kilometers; the preview updates as you go.

  • By road, each customer’s 3 closest locations in a straight line are compared by road, and the quickest wins, or the shortest.
  • The nearest in a straight line is not always the nearest by road: rivers, bridges and highways change the answer.
  • A location that can’t be found is named on the preview and left out of the matching: fix its address, or give its coordinates.
Nearest by
Drive timeRoad distance
Travel by
CarWalkingStraight line
The first customers on the map, each joined to its nearest store.
4

Create an account or log in

Sign up with Google or your email to match the whole list. Your lists and your settings stay where they are.

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

Pay, or use your plan

Pay for this file, or use rows from your plan. By road, a customer counts as 3 rows, because 3 locations are compared by road; in a straight line, 1 row. The locations are free, and the first 100 rows every day are free too: 33 customers by road.

  • Pay as you go: $3 per 1,000 customers by road, with a $5 minimum per file. 2,350 customers by road come to $8.
Price$8.00
2,350 customers by road × 3 rows = 7,050 rows
Pay $8Use plan rows
Payment confirms within a minute.
6

Download the results

Every customer row comes back with its nearest location, that location’s address, the straight-line distance, the road distance and the drive time, as CSV or Excel from your dashboard. Customers given as addresses also get their latitude, longitude and matched address.

customers.xlsx
Nearest location · Ready
CSVXLSX

FAQ

Common questions

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

By road, the nearest is the quickest drive, or the shortest if you chose road distance, not the closest point on a map. A river, a bridge or a highway can make a store that looks farther the quicker one to reach.

Your first 100 rows are free. Every day.

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