Importing into Excel

·         Test out the query at https://api.bogged.finance and when you are happy, copy the Request URL. It will look something like this:
https://api.bogged.finance/v1/top_exchanges?chain=bsc&api_key=<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 modified 8mo ago