Are you tired of checking crypto prices manually? Want to automate your portfolio tracking or build a custom crypto dashboard? Good news — with just a few steps, you can pull live cryptocurrency prices directly into Google Sheets.

In this guide, we’ll show you three simple methods to get real-time crypto data, whether you’re a casual investor or a DeFi data nerd.

---

Method 1: Using GOOGLEFINANCE() (Very Limited)

Google Sheets has a built-in function called GOOGLEFINANCE(), which works well for some financial data — but only a few cryptocurrencies are supported.

Example:

=GOOGLEFINANCE("CURRENCY:BTCUSD")

This pulls the current price of Bitcoin (BTC) in USD.

Limitations:

• Only supports a few coins like BTC, ETH, LTC.
• No volume, no historical data, no market cap.

Use this for basic and quick price checks.

Method 2: CoinGecko API (Free & No API Key)

CoinGecko offers a powerful API — completely free and without the need for an API key.

Step 1: Add a Script to Enable IMPORTJSON

1. Open your Google Sheet.
2. Go to Extensions > Apps Script.
3. Delete any existing code, and paste this:

function IMPORTJSON(url) {
  var response = UrlFetchApp.fetch(url);
  var json = JSON.parse(response.getContentText());
  var output = [];
  for (var key in json) {
    if (typeof json[key] === 'object') {
      for (var subKey in json[key]) {
        output.push([key + " " + subKey, json[key][subKey]]);
      }
    } else {
      output.push([key, json[key]]);
    }
  }
  return output;
}

4. Save and close the script editor.

Step 2: Fetch Crypto Prices

Now, in your sheet, paste this formula:

=IMPORTJSON("https://api.coingecko.com/api/v3/simple/price?ids=bitcoin,ethereum&vs_currencies=usd")

This returns the live prices of Bitcoin and Ethereum in USD. Want more coins? Just modify the URL:

=IMPORTJSON("https://api.coingecko.com/api/v3/simple/price?ids=dogecoin,solana,cardano&vs_currencies=usd")

Method 3: Use Binance API (More Advanced)

If you want detailed market data or broader trading pairs, the Binance API is an excellent option.

Example (no script needed):

=IMPORTDATA("https://api.binance.com/api/v3/ticker/price?symbol=BTCUSDT")

That brings you BTC/USDT’s current price. Replace BTCUSDT with other symbols like ETHUSDT, ADAUSDT, etc.

IMPORTDATA() will update periodically.

---

Final Thoughts

Method	Best For	Easy to Use	Live Prices	Advanced Data
GOOGLEFINANCE()	Beginners	Yes	Limited	No
CoinGecko + Script	Most Users	Yes	Yes	Basic only
Binance API	Traders / Devs	Medium	Yes	Yes

With these options, you can create a crypto dashboard, monitor your portfolio, or even build trading models inside Google Sheets — without paying for expensive tools.