Nearest location
Find the nearest location for every customer
Upload your customers and your locations, such as stores, warehouses or offices. Every customer comes back with its nearest location, the distance and the drive time. The first 100 rows every day are free.
- 1Upload
- 2Choose columns
- 3Preview on map
- 4Calculate
Your customers
The people or places to match, as addresses or coordinates
| Customer | Address |
|---|---|
| Greenpoint Florist | 120 Franklin St, Brooklyn, NY 11222 |
| Park Slope Books | 220 7th Ave, Brooklyn, NY 11215 |
Your locations
Your stores, warehouses or offices, each with a name: up to 500
| Store | Address |
|---|---|
| Long Island City store | 27-01 Queens Plaza N, Long Island City, NY 11101 |
| Brooklyn store | 620 Atlantic Ave, Brooklyn, NY 11217 |
Every customer gets its nearest location
| Customer | Address | Nearest location | Distance | Drive time |
|---|---|---|---|---|
| Greenpoint Florist | 120 Franklin St, Brooklyn, NY 11222 | Long Island City store | 2.47 mi | 15.6 min |
| Park Slope Books | 220 7th Ave, Brooklyn, NY 11215 | Brooklyn store | 1.47 mi | 11.8 min |
Added by Geloky: the nearest location and its address, the distance in a straight line and by road, and the drive time. Addresses can be in one column or split into street, city, state and zip; coordinates work too. Other columns come back unchanged.
No files at hand? Try 20 New York customers and 6 stores
The first customers, matched
| Customer | Nearest location | Straight line | By road | Time |
|---|
Create a free account to match these customers
Your lists and your settings stay here while you sign up.
Match these customers
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 customers are checked with Google reCAPTCHA; the Google Privacy Policy and Terms of Service apply.
What you get back
Your customer list, with the nearest location on every row
The list comes back as you sent it, with five columns added: the nearest location, its address, the distance in a straight line, the distance by road and the drive time. These are five New York shops matched with six stores, by car.
| Customer | Address | Nearest location | Location address | Straight line (mi) | Road distance (mi) | Drive time (min) |
|---|---|---|---|---|---|---|
| Greenpoint Florist | 120 Franklin St, Brooklyn, NY 11222 | Long Island City store | 27-01 Queens Plaza N, Long Island City, NY 11101 | 1.80 | 2.47 | 15.6 |
| Park Slope Books | 220 7th Ave, Brooklyn, NY 11215 | Brooklyn store | 620 Atlantic Ave, Brooklyn, NY 11217 | 0.90 | 1.47 | 11.8 |
| Hell’s Kitchen Café | 600 9th Ave, New York, NY 10036 | Chelsea store | 75 9th Ave, New York, NY 10011 | 1.33 | 1.35 | 9.1 |
| Astoria Deli | 31-10 Ditmars Blvd, Astoria, NY 11105 | Long Island City store | 27-01 Queens Plaza N, Long Island City, NY 11101 | 2.28 | 2.74 | 18.9 |
| Harlem Bikes | 2100 Frederick Douglass Blvd, New York, NY 10026 | Upper East Side store | 1071 5th Ave, New York, NY 10128 | 1.37 | 1.86 | 10.7 |
- Download it as Excel or CSV. Free files come as CSV.
- Customers given as addresses also get their latitude, longitude and the address found.
- Thousands of customers in one file, matched in the background.
How it works
The nearest by road, not just on the map
Every location, in a straight line
Each customer is measured against every location as the crow flies. That costs nothing and takes no time, even with 500 locations.
The 3 closest, compared by road
A river, a highway or a one-way street can turn the closest store into a long drive. So the 3 closest are measured by road, by car or on foot.
The quickest one wins
Each customer gets the location with the shortest drive, or the shortest road distance if you prefer, with the distance and the time.
In the sample: Greenpoint Florist is 1.74 mi from the Lower East Side store and 1.80 mi from the Long Island City store, in a straight line. But the Lower East Side store is across the East River: 20.0 minutes by car, against 15.6. So the Long Island City store is its nearest location.
Who uses it
One list of people, one list of places
Stores and franchises
Send each customer to the nearest store, or split a mailing list by store.
Delivery and logistics
Assign every order or address to the nearest warehouse or depot, with the drive time.
Sales and service teams
Give each lead to the nearest rep or office, and each job to the nearest technician.
Clinics, schools and branches
Find the nearest clinic, school or branch for everyone on a list.
Pricing
What a file costs
Free
- 100 rows every day: 33 customers
- 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 rows: 25,000 customers
- 20% back to your API wallet
By road, a customer counts as 3 rows, because its 3 closest locations are compared; in a straight line, 1 row. Locations are free. A file of 1,000 customers costs $5, the minimum; one of 20,000 customers costs $60. The tool shows the exact price before you pay. Compare all plans →
FAQ
Nearest location questions
Something else? Write to hello@geloky.com — a person answers within a day.
Upload your customer list and your store list, as Excel or CSV files. Geloky measures every customer against every store and adds the nearest store, the distance and the drive time to each customer’s row. There are no formulas to write and no API key to get.
Every location is first measured in a straight line. The 3 closest are then measured by road, and the one with the shortest drive wins, or the shortest road distance if you choose that. With Straight line, the closest location as the crow flies wins.
Yes. Addresses can be in one column, or split into street, city, state, zip and country columns. Latitude and longitude work too, and the two lists don’t have to be the same kind. Customers given as addresses also get the latitude, longitude and address that were found.
Up to 500 locations, each with a name, such as a store name or a branch number. Up to 20,000 customers by road, or any number in a straight line.
By road, a customer counts as 3 rows, because its 3 closest locations are compared: $3 per 1,000 customers pay as you go, with a $5 minimum per file, or 3 rows of a monthly plan. In a straight line, a customer is 1 row. Locations are free, and the first 100 rows every day are free: 33 customers.
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.
More distance tools
Other ways to measure
Batch distances
A list of trips, from one address or point to another: the distance and the travel time for every row.
Calculate distancesDistance matrix calculator
Paste up to 25 places and get the straight-line distance between every pair. Free, no sign-up.
Open the matrixBatch geocoding
A spreadsheet of addresses to latitude and longitude, or coordinates back to addresses.
Geocode a file