Once the basics worked, I made an Excel pivot table from the original dataset to list the distinct combinations of city and state and used the preview batch request API to send a query with them. You can see how to submit them in the How to Search For an Address section in the Azure Maps docs. With the Azure Maps API key, I used the Postman app to create a few sample requests and ensure the key was working nicely. You can see how to do it in the Azure Maps documentation here. The first step was to create an Azure Maps account from inside the Azure Portal and obtain an API key. Getting the data from Azure Maps using their API Microsoft Azure Maps API - used to query each city and state in order to obtain the address, geographic coordinates, and other useful pieces of data, such as county, state initials, etc.Excel - the ultimate application to work with smaller datasets by using pivot tables, look-ups, etc.VS Code - my favorite lightweight editor.Postman app - super easy to create and format requests to web APIs.My goal: enrich each row in the dataset with the latitude and longitude to be able to use D3.js more efficiently. In my case, I had a very simple dataset that had (among many) a column for the name of a US city, and another for the US state for each row. Online services such as the Microsoft Azure Maps service API or the Google Maps API can help to enrich location data by either geocoding, or reverse-geocoding depending on the data available, and format needed. Data wrangling is a necessary step when working with publicly available data and enriching/preparing said data for consumption by apps, services, or even visualizing it directly with libraries such as D3.js.

Importing json data into excel