Find the Closest Location to Each Customer in Excel
1:02 · Published November 16, 2026
In this video
About this video
Match every customer to your nearest store, branch or depot, right in Excel. The CDXGeoStream Closest ZIP tool compares a column of customer ZIP codes against your own list of locations.
What you get
- The closest location for each customer, with its city and state
- The distance, in miles, kilometers or nautical miles
- The second and third closest locations
- No list of your own? Choose Anywhere to get the nearest ZIP code in the database for each customer.






