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 updated