Press "Enter" to skip to content

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

  1. From the Cryptosheets Excel ribbon click data.
  2. From the Googlesheets Add-ons menu click Cryptosheets then select Launch side-bar.
  3. Type in CoinGecko… then click on Simple Price.

How do I add a Binance API to Google Sheets?

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

  1. At spreadsheet’s main menu, go to Binance -> Setup API Keys .
  2. Set your API Key and click OK . Do the same for API Secret Key .
  3. Voila, you are ready to go!

Is Coingecko API free?

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 hello@coingecko.com with any suggestions or feedback that you may have for us.

Can Excel import crypto prices?

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.

Can You import coingecko data into Google Sheets?

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.

How to import crypto Data into Google Sheets?

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.

How to import CoinMarketCap API data to sheets?

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.

How to split coingecko data into multiple rows?

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.