You can get API results programmatically through a script and save them to a file, or you can work in Microsoft Excel to load the first page of the API response directly. See this article from Microsoft Support for instructions on how to do that.

Loading API data from a JSON file

1. On the Data tab in Excel, choose Get Data > From File > From JSON. Select your saved JSON file and click Import. You will be brought to the Power Query Editor.

1. Proceed to Transforming your data below.

Getting API data directly from the Web

1. From the Data tab in Excel, click From Web, then select Advanced in the dialog box that opens.

1. Complete the fields with the parameters for your API query. See the example below, noting that your URL will be different than what is shown in the example:

1. Click OK. You will be brought to the Power Query Editor. Continue with Transforming your data below.

Transforming your data

1. Right click on the data row and select Drill Down

1. On the Convert section of the Excel Ribbon, click To Table. A dialog box will open asking for information on field delimiters and extra columns. Click OK without changing any of the defaults.

1. Click the expand columns icon, then select the columns you want to appear in your spreadsheet. Click OK when you have made your selection.

1. On the Close section of the Excel Ribbon, click Close & Load. Your selected data will load in an Excel tab.