Zip code to zip code distances

Copper Contributor

I have a list of zip codes (several hundred) and another list of zip codes (also several hundred). The goal is to set up a table with each zip code as the axes and the distance between those zip codes as the table information. Is this possible to do in Excel? I do have a file that has the latitude/longitude for every zip code in the US if there's some way to look up that up and calculate the distance.


Direct distance is fine (vs driving distance).

1 Reply
best response confirmed by jwa33 (Copper Contributor)