NEW Geloky now works inside Claude, ChatGPT and Cursor. See how Geloky inside Claude & ChatGPT →

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.

How it works ↓
  1. 1Upload
  2. 2Choose columns
  3. 3Preview on map
  4. 4Calculate
1

Your customers

The people or places to match, as addresses or coordinates

Drop the customer list here
Excel or CSV · up to 1 GB
For example
CustomerAddress
Greenpoint Florist120 Franklin St, Brooklyn, NY 11222
Park Slope Books220 7th Ave, Brooklyn, NY 11215
2

Your locations

Your stores, warehouses or offices, each with a name: up to 500

Drop the location list here
Excel or CSV · up to 500 locations
For example
StoreAddress
Long Island City store27-01 Queens Plaza N, Long Island City, NY 11101
Brooklyn store620 Atlantic Ave, Brooklyn, NY 11217
Add both lists to continue. Both in one Excel file? Drop it in both boxes and pick the sheet in each.

Every customer gets its nearest location

CustomerAddressNearest locationDistanceDrive time
Greenpoint Florist120 Franklin St, Brooklyn, NY 11222Long Island City store2.47 mi15.6 min
Park Slope Books220 7th Ave, Brooklyn, NY 11215Brooklyn store1.47 mi11.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

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.

CustomerAddressNearest locationLocation addressStraight line (mi)Road distance (mi)Drive time (min)
Greenpoint Florist120 Franklin St, Brooklyn, NY 11222Long Island City store27-01 Queens Plaza N, Long Island City, NY 111011.802.4715.6
Park Slope Books220 7th Ave, Brooklyn, NY 11215Brooklyn store620 Atlantic Ave, Brooklyn, NY 112170.901.4711.8
Hell’s Kitchen Café600 9th Ave, New York, NY 10036Chelsea store75 9th Ave, New York, NY 100111.331.359.1
Astoria Deli31-10 Ditmars Blvd, Astoria, NY 11105Long Island City store27-01 Queens Plaza N, Long Island City, NY 111012.282.7418.9
Harlem Bikes2100 Frederick Douglass Blvd, New York, NY 10026Upper East Side store1071 5th Ave, New York, NY 101281.371.8610.7
Added by Geloky Distances in miles or kilometers, time in minutes.
  • 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

Thirty customers and four stores: each customer takes the colour of its nearest store by road. Greenpoint, at the top of Brooklyn, goes to Long Island City: the Lower East Side store is a little closer in a straight line, but it is across the East River.
  1. 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.

  2. 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.

  3. 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.

Read the full guide, step by step →

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

$0
  • 100 rows every day: 33 customers
  • Results as CSV, kept for 24 hours

Pay as you go

$3 per 1,000 customers
  • $5 minimum per file
  • Paid once for that file, no subscription

Monthly

from $20 a month
  • 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.