# Find the Nearest Location for Each Customer (Free, Whole Lists) | InstaMaps > Paste your customers and your branches, stores or depots, and get each customer's nearest location by straight line or drive time, with a map and a CSV. US addresses and ZIPs, UK postcodes. Free. Source: https://get-instamaps.com/tools/nearest-location-finder **47,961** locations geocoded with InstaMaps in the last 30 days, 372 today # Find the nearest location for each customer Paste or upload your customers, list your branches, stores, depots or offices, and get the nearest one to every customer, by straight line or by road. A map, the share each location serves, and your file back. Free, no account. Quick answer To find each customer's nearest location, measure from every customer to every location and keep the shortest: by straight line (great-circle miles) for speed, or by road, where the quickest drive can belong to a location that's further away as the crow flies. Paste your locations and your customers below. It works with US addresses and ZIP codes, UK addresses and postcodes, and latitude and longitude. Step 1 of 2 · about a minute ## Where are your locations? Your branches, stores, depots or offices: one per line, up to 25\. Give each a name before a colon if you like. ## Who are your customers? Drop a spreadsheet or CSVor click to choose one · we read the address column and keep the rest Or paste one address, ZIP or postcode per line Nearest by As the crow flies. Fast for any size of list. US addresses and ZIP codes, UK addresses and postcodes, or latitude and longitude. Only the address is used. ## What you get For every customer: its nearest location, the distance in miles (and the drive time when you measure by road), and the next nearest location, so you can see who sits between two. Then a table of how many customers each location is nearest to, with the average and furthest distance, and a map with every customer coloured by its nearest location. The download keeps every column of your own file. ## Straight line or by road? Straight line is instant for any size of list and right for territories and rough catchments. By road measures the three nearest locations in a straight line on real roads and keeps the quickest drive, which matters where rivers, motorways or mountains get in the way. Drive times are weekday estimates: road time with the measured average delay for the area. ## Where the data comes from US addresses are placed with our own US address data, UK addresses and postcodes with Ordnance Survey and OpenStreetMap data, and every row shows how sure we are of its location. Road distances come from our own routing on OpenStreetMap roads. Nothing goes to a paid map service. ## FAQs How do I find the closest store to each customer in Excel? You can, with a distance formula for every customer and store and a MIN lookup, but it gets slow past a few hundred rows and it's straight line only. Paste the same two lists here and you get each customer's nearest store, by straight line or by road, as a file you can open in Excel. How many customers and locations can I use? Up to 5,000 customers and 25 locations at a time. The first 25 customers show straight away; enter a work email to match the rest and download the whole file. Does it work with UK postcodes? Yes. Customers and locations can be UK addresses or postcodes on their own (a postcode is placed at its centre), US addresses or ZIP codes, or latitude and longitude. Can I name my locations? Yes. Put the name before a colon: "Dallas branch: 2100 Ross Ave, Dallas, TX 75201". Without one, the address is the name. How is drive time worked out? On real roads, from our own routing on OpenStreetMap roads, with the weekday average delay measured for the area (Texas A&M's Urban Mobility Report in the US, the Department for Transport's in Great Britain). Do you keep my list? Your addresses are used to run the match. They aren't shared or sold. 1. [Home](/) 2. › 3. [Free tools](/tools) 4. › 5. Nearest location to each customer ## More free address tools * [Distance matrix →Miles or drive minutes between every pair of up to 12 places, on real roads.](/tools/distance-matrix-calculator) * [Route planner for multiple drivers →Up to 100 stops split across up to 10 drivers on real roads, each driver's stops in order with a Google Maps™ link.](/tools/multi-driver-route-planner) * [Postcode to postcode distance →Miles by road between UK postcodes, with drive time, for one journey or a whole list.](/tools/postcode-distance-calculator) * [ZIP code to ZIP code distance →Miles by road between ZIP codes or addresses, with drive time, and a mileage log at the IRS rate.](/tools/zip-code-distance-calculator) * [Multi-stop route planner →Up to 100 stops in the best order, as one Google Maps™ link.](/tools/multi-stop-route-planner) * [Delivery route planner →Depot first, up to 100 delivery stops in the best order, with one Google Maps™ link for the driver.](/tools/delivery-route-planner) [All free tools →](/tools) InstaMaps Territory mapping and routing for Google Sheets™. ### Product * [Features](#features) * [How It Works](#how-it-works) * [Sheets Formulas](/formulas) * [100-Stop Route Planner](/tools/multi-stop-route-planner) * [Dispatch Software](/blog/dispatch-software) * [Route Optimization](/blog/route-optimization-software) ### Company * [About](#) * [Blog](/blog) * [Free Tools](/tools) * [Store Locator](/store-locator) * [Careers](#) * [Contact](#) ### Resources * [Setup Guide](/docs/setup) * [Help Center](/docs/help) * [Documentation](/docs) * [Geocoding & Routing API](/developers) * [Data room for reporters](/data) * [Press Map: Closed UK Pubs](/press/closed-pubs) * [Free Batch Geocoder](/tools/geocoder) * [HUBZone Checker](/tools/hubzone-checker) * [Census Tract Lookup](/tools/census-tract-lookup) * [Opportunity Zone Checker](/tools/opportunity-zone-checker) * [USDA Eligibility Checker](/tools/usda-eligibility-checker) * [Flood Zone Checker](/tools/flood-zone-checker) * [Flood Zones Explained](/flood-zones) * [Nearest Location Finder](/tools/nearest-location-finder) * [People Within a Drive Time](/tools/drive-time-market-report) * [Bulk Address Lookup](/tools/bulk-address-lookup) * [Bulk Postcode Lookup (UK)](/tools/bulk-postcode-lookup) * [UK Postcode Tools](/tools/uk-postcode-tools) * [Population Within a Radius](/tools/population-within-radius) * [Conservation Area Checker](/tools/conservation-area-checker) * [Flood Zone Checker (England)](/tools/uk-flood-zone-checker) * [UPRN Lookup](/tools/uprn-lookup) * [Service Area Map](/tools/service-area-map) * [Multi-Driver Route Planner](/tools/multi-driver-route-planner) * [Postcode Distance (UK)](/tools/postcode-distance-calculator) * [ZIP Code Distance (US)](/tools/zip-code-distance-calculator) * [ZIP Codes in a Radius](/tools/zip-codes-in-radius) * [Sales Route Planner](/blog/sales-route-planner-free) * [Territory Mapping](/blog/free-territory-mapping-software) * [Report Issue](mailto:hello@get-instamaps.com?subject=Something%20isn%27t%20working) ### Legal & Support * [Privacy Policy](/privacy) * [Terms of Service](/terms) * [Support](/support) * [Admin Config](/dashboard/settings/admin) ### [InstaMaps by use case](/for) [Lead distance](/for/lead-distance)[Circle prospecting](/for/circle-prospecting)[Door knocking](/for/door-knocking)[Cleaning schedules](/for/cleaning-business-scheduling)[Field service routes](/for/field-service-routes)[Sales territories](/for/sales-territory-mapping)[Driving for dollars](/for/driving-for-dollars)[Site verification](/for/site-verification)[Store locators](/for/store-locator)[Property listings](/for/real-estate-listings)[Address cleanup](/for/property-data-cleanup)[Delivery routes](/for/delivery-routes)[Field service](/for/field-service-jobs)[Trip planning](/for/travel-itinerary)[School mapping](/for/school-mapping)[education](/for/school-district-lookup)[education](/for/map-student-addresses)[education](/for/distance-to-school)[field service](/for/home-care) © 2026 InstaMaps. All rights reserved.