I will provide an excel addin with mapping capabilities

Bring mapping capabilities and geocoding to Microsoft Excel: insert static maps with heatmap, administrative boundaries, shapes and geo-objects, place photos and street views, download GeoJSON and KML, get address components, find places with details, build routes, show isolines and have some other geocoding functions in your spreadsheet.

This app is powered by Google Maps and requires a Google Maps API Key with enabled Places API, Directions API, Maps Static API, Street View Static API, Maps JavaScript API, Geocoding API for several functions. Shapes and boundaries functionality requires Bing Maps API. Isoline functionality requires Bing Maps API or Here Maps API key. The app comes with shared API keys for a limited trial period. Links to obtain your own keys are available on the add-in Taskpane. Get free usage quota for Maps, Routes, and Places every month.

Click Home - Maps for Excel - Show Taskpane - Show ideas to find some ideas for use of Maps for Excel formulas.