> 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-google-sheets.md).

# Importing into Google Sheets

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

·         Create a new Google Sheet

·         Select Extensions --> Apps Script

·         Delete the existing content of the script

·         Copy the code from [this script on Github](https://gist.github.com/paulgambill/cacd19da95a1421d3164) into the script editor

·         File --> Save

·         In cell A1, type the following and press enter:

\=ImportJSON("\<your request url>", "/data", "noInherit")

·         You should see the query data returned as rows:

![](/files/gsjNUKJH3RTPNUU2ixUO)