Importing into Excel

· Test out the query at and when you are happy, copy the Request URL. It will look something like this:<your api key>

· Select the "Data" tab

· Select "From Web"

· Paste the request URL and click OK

· Power Query Editor will open. Click the “Into Table” icon (top left)

· Click “Remove Rows” --> Bottom Rows --> 1

· Click the expand icon to the right of the “Value” column header and select “Expand to New Rows”

· Do the same thing again. You should see the column names from your query. Click OK.

· Right-click the “Name” column header à Remove

· Click “Close & Load” (top left)

Tip: You can undo any action in the Applied Steps history by clicking the X.

Last updated