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. The file looks like this by default: import from './excel.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. This generate command will create the service file:, in the src/app directory of the project.

For example, in this case, you can generate the Excel service you need using ng generate service ExcelService.

With the Angular CLI, you can generate a new service by running the ng generate service command in the terminal. How to Convert JSON Data to XLSX Format in Angular

Importing json data into excel