# 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”

![](https://2904693074-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mjz3PBq89DT2OWUHzd5%2Fuploads%2FUH4KMu7MaFAk7YmfTr9l%2Fimage.png?alt=media\&token=d12b2bb4-112f-49c7-8751-b22a94f896e9)

·         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)

&#x20;

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