Start Searching the Answers
The Internet has many places to ask questions about anything imaginable and find past answers on almost everything.
How do I extract data from Coingecko?
Using the console
Enter a label like Binance to Google Sheets and click the Create button. Take note for both API Key and Secret Key values. Click the Edit restrictions button….
We plan to continue providing excellent service to the crypto community with our completely free API, free listing for projects, exchanges and more! Do drop us an email at email@example.com with any suggestions or feedback that you may have for us.
We will be using the “Power Query” feature in Excel to import the live crypto price data. If you have Excel 2016, the Power Query package comes pre-installed in the base version of Excel. It takes only a couple of moments and Excel Campus has put together a detailed guide on how to install the free Power Query add-in.
In this guide, we’ll walk through how to pull cryptocurrency market data from the CoinGecko API directly into Google Sheets, using the API Connector add-on for Sheets. The cool thing about CoinGecko is that their API is free and open, so we won’t need any API key. They also provide some unique API endpoints like most-searched coins.
Putting it together, we get the full API Request URL: Now let’s paste that URL into API Connector and import some crypto data into Google Sheets. Open up Google Sheets and click Add-ons > API Connector > Open. In the Create tab, enter the API URL we just created. Leave the Headers section empty. We can leave authentication set to None, too.
We can now enter all our values into API Connector and import CoinMarketCap API data into Google Sheets. Open up Google Sheets and click Add-ons > API Connector > Open. In the Create tab, enter the API URL we just created. Replace YOUR_API_KEY with the value provided above in step 3.
By default the /exchange-rates request URL will return all exchange rates in a single row. To split the data into a table, you can add in a JMESPath (paid feature) query of rates.* as shown in the screenshot above. For several endpoints, CoinGecko limits the number of records returned in each response.