Geocode Addresses in Excel and Sort by Distance
1:00 · Published November 17, 2026
In this video
About this video
Turn a column of addresses into coordinates, then rank the whole list by distance from any point, without leaving Excel.
What you get
- The best match, city, county, latitude and longitude for each row
- A new sheet with every address and its straight-line distance to your target, nearest first
- A target can be a ZIP code, an address, or a latitude and longitude
- The sort reuses the coordinates you just geocoded. Only the target is looked up.
- ZIP codes geocode on every plan. Street addresses need a paid plan or purchased credits.






