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.