- Help
- 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.
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.
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”.
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.
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.
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.
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.
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.
Up to 500 locations, and up to 20,000 customers by road in one file. Split a bigger customer list into several files, or match it in a straight line, which has no such limit.
An empty row means the customer’s address was not found: fix it and send those customers again. In a paid file, fixed rows run free within 30 days. A “-” in the road columns means no road joins the customer to its closest locations, for example across water without a ferry or a bridge: it keeps the nearest location in a straight line.
Yes. Choose Walking, and the file gets walking distance and walking time instead of driving.
No. You pay only for customers: 3 rows each by road, 1 row each in a straight line.
Your first 100 rows are free. Every day.
No credit card · See your results on a map before you pay