CDXGeoStream Technologies

Find the Closest Location to Each Customer in Excel

1:02 · Published November 16, 2026

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.