> For the complete documentation index, see [llms.txt](https://docs.bogged.finance/bogged-finance/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bogged.finance/bogged-finance/token-teams/api/importing-into-excel.md).

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

![](/files/mdezGxfif0noQiR1RcPe)

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