How to Get Crypto Prices in Google Sheets (4 Methods, 2026)

There are four ways to pull live cryptocurrency prices into Google Sheets in 2026: the built-in GOOGLEFINANCE function (limited to ~10 major coins), CoinTable, a Google Sheets add-on for cryptocurrency prices (10,000+ coins, no API key), IMPORTDATA with a public API, and a custom Google Apps Script. For most users, installing CoinTable and typing =CT_PRICE("BTC") is the fastest path — 30 seconds from install to live Bitcoin price. This guide walks through all four methods step by step, with code examples and a comparison table so you can pick the right approach.

If you want to skip ahead, check our crypto formulas cheat sheet for a quick-reference of every formula mentioned below, or jump to our full comparison of the best crypto add-ons for Google Sheets.

Why Track Crypto Prices in Google Sheets?

Google Sheets is the go-to tool for crypto investors who want full control over their data. Unlike portfolio apps, a spreadsheet gives you:

• Complete privacy — your holdings stay in your spreadsheet, not on someone else's server
• Custom calculations — build your own formulas for profit/loss, DCA tracking, tax reporting
• Free and flexible — no subscription required for the spreadsheet itself
• Shareable — collaborate with partners or accountants without giving app access

The challenge? Getting live crypto prices into your cells. Manually copying prices from CoinGecko or CoinMarketCap is tedious and error-prone. If you want to track Bitcoin price in Google Sheets (or any other coin), you need an automated method.

This guide shows you four methods to get live cryptocurrency prices in Google Sheets, from the simplest built-in option to the most technical custom solution.

Quick Comparison: 4 Methods at a Glance

Before we dive in, here is how the four methods stack up:

For a deeper look at how CoinTable compares to using the CoinGecko API directly, see our CoinTable vs CoinGecko comparison.

Method 0: GOOGLEFINANCE (Built-in, Limited)

Google Sheets has a built-in GOOGLEFINANCE function that can fetch a handful of cryptocurrency prices. It requires zero setup — just type a formula:

=GOOGLEFINANCE("BTCUSD")

This returns the current Bitcoin price in USD. You can also try other major coins:

=GOOGLEFINANCE("ETHUSD")
=GOOGLEFINANCE("LTCUSD")

What GOOGLEFINANCE Gets Right

• Zero setup — no add-on, no API key, no script
• Familiar syntax — if you already use GOOGLEFINANCE for stocks, the crypto version works the same way
• Historical prices — you can pull date ranges for supported coins with =GOOGLEFINANCE("BTCUSD", "price", DATE(2025,1,1), DATE(2025,12,31), "DAILY")

GOOGLEFINANCE Limitations for Crypto

The limitations are significant. We wrote a full breakdown of GOOGLEFINANCE crypto limitations, but here is the summary:

• Only ~10–15 coins supported — BTC, ETH, LTC, BCH, and a few others. No SOL, no DOGE, no AVAX, no DeFi tokens, no meme coins.
• 20-minute price delay — prices are not real-time. For active trading decisions, this lag matters.
• No altcoins whatsoever — if a coin is not in the small list Google supports, you get an error.
• No market cap or volume — GOOGLEFINANCE only returns price data for crypto. No market cap, no 24h volume, no circulating supply.
• No historical download for most coins — historical data only works reliably for BTC and ETH.
• Unstable results — Google has not officially documented crypto support in GOOGLEFINANCE, so coverage can change without notice.

Bottom line: GOOGLEFINANCE is fine if you only need a rough BTC or ETH price and do not mind the delay. For broader coverage of 10,000+ cryptocurrencies with real-time data, use the CoinTable add-on described next.

Method 1: CoinTable Add-on (Recommended)

CoinTable, a Google Sheets add-on for cryptocurrency prices, gives you live crypto prices with simple formulas. No API keys, no coding, no configuration. It is the best crypto add-on for Google Sheets if you want comprehensive coverage with minimal friction.

Step 1: Install CoinTable

1. Open your Google Sheet
2. Go to Extensions > Add-ons > Get add-ons
3. Search for "CoinTable"
4. Click Install and grant permissions

That's it. No account creation, no API key, no setup wizard.

Step 2: Use Your First Formula

Type this in any cell:

=CT_PRICE("BTC")

Press Enter. You will see the current Bitcoin price in USD.

Want it in euros? Add a second argument:

=CT_PRICE("BTC", "EUR")

Need Ethereum? Solana? Any of 10,000+ tokens?

=CT_PRICE("ETH")
=CT_PRICE("SOL")
=CT_PRICE("DOGE")

Step 3: Explore More Formulas

CoinTable offers more than just prices. Build a complete crypto portfolio tracker dashboard:

=CT_PRICE("BTC")        → Current price
=CT_CHANGE("BTC")       → 24h price change (%)
=CT_MARKETCAP("BTC")    → Market capitalization
=CT_VOLUME("BTC")       → 24h trading volume
=CT_RANK("BTC")         → Market cap rank
=CT_SUPPLY("BTC")       → Circulating supply
=CT_ATH("BTC")          → All-time high price
=CT_HIGH("BTC")         → 24h high
=CT_LOW("BTC")          → 24h low

Every formula supports 50+ fiat currencies as a second argument. Use "USD", "EUR", "GBP", "JPY", and more. See the full list in our crypto formulas cheat sheet.

Why CoinTable?

• 30-second setup — install and start using immediately
• No API key — works out of the box
• 10,000+ cryptocurrencies — from Bitcoin to the newest DeFi tokens
• 50+ fiat currencies — prices in any currency you need
• Privacy-first — CoinTable only reads cells with its formulas
• Free tier — 300 requests per month at no cost

Method 2: IMPORTDATA with Public APIs

If you prefer not to install an add-on, you can use Google Sheets' built-in IMPORTDATA function with a public crypto API.

How It Works

The IMPORTDATA function fetches data from a URL and displays it in your spreadsheet. You can point it at a public crypto API:

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

This returns raw JSON data. To extract just the price, you will need to combine it with other functions or use IMPORTJSON (a custom script).

A simpler approach uses CoinGecko's CSV-compatible endpoint, but these change frequently and may break without notice.

Limitations of IMPORTDATA

• Rate limits — public APIs restrict how many requests you can make (CoinGecko free tier: 5–15 calls/minute)
• No guaranteed uptime — API endpoints can change or go offline
• Complex formulas — parsing JSON in Sheets requires workarounds
• Limited coins — free API tiers support fewer cryptocurrencies
• No support — if something breaks, you are on your own
• Caching issues — Google Sheets caches IMPORTDATA results unpredictably

For a single Bitcoin price check, IMPORTDATA works. For a crypto portfolio tracker with 20+ coins, the rate limits and complexity make it impractical.

Method 3: Google Apps Script

Google Apps Script lets you write custom JavaScript functions that run inside Google Sheets. You can create a custom function that fetches crypto prices from any API.

How It Works

1. Open your Google Sheet
2. Go to Extensions > Apps Script
3. Replace the code with:

function CRYPTO_PRICE(symbol) {
  const url = `https://api.coingecko.com/api/v3/simple/price?ids=${symbol}&vs_currencies=usd`;
  const response = UrlFetchApp.fetch(url);
  const data = JSON.parse(response.getContentText());
  return data[symbol]?.usd || "Not found";
}

4. Save the script (Ctrl+S)
5. Go back to your sheet and use:

=CRYPTO_PRICE("bitcoin")

Note that CoinGecko's API uses full names (e.g., "bitcoin" not "BTC"), which adds friction compared to CoinTable's ticker-based approach.

When to Use This Method

Apps Script is best when:

• You need custom data processing (e.g., averaging prices from multiple exchanges)
• You are comfortable with JavaScript
• You want to build complex automations (e.g., email alerts when prices change)
• You are already using Apps Script for other purposes

For most users, the development time (30+ minutes to get a basic script working, hours for a robust one) does not justify the effort when CoinTable provides the same data with zero code.

Detailed Comparison: Which Method Is Best?

For most users, CoinTable is the clear winner. It combines the easiest setup with the most comprehensive data coverage. GOOGLEFINANCE is fine for a quick BTC price. The only reason to use IMPORTDATA or Apps Script is if you have very specific technical requirements that CoinTable does not cover.

How to Refresh Your Crypto Data

All four methods cache data differently:

• GOOGLEFINANCE: Updates automatically but with a ~20-minute delay. No manual refresh option.
• CoinTable: Prices update when you refresh. Use the CoinTable menu or press Ctrl+Shift+F9 to refresh all formulas.
• IMPORTDATA: Google caches results for up to 1 hour. Force refresh by adding a dummy parameter: =IMPORTDATA(url & "&t=" & NOW())
• Apps Script: Results cache for up to 6 hours by default. Add SpreadsheetApp.flush() in your script to force updates.

CoinTable Plus subscribers get auto-refresh, so your prices stay current without manual intervention.

Troubleshooting

"Loading..." appears in cells

Give it a few seconds. If using CoinTable, try Extensions > CoinTable > Refresh Prices. For IMPORTDATA, check that the API URL is correct and accessible.

"#ERROR!" in cells

Common causes:

• GOOGLEFINANCE: The coin is not supported. Try a different ticker or switch to CoinTable for altcoins. See GOOGLEFINANCE crypto limitations for the full list of supported coins.
• CoinTable: Check your monthly request limit in Extensions > CoinTable > Usage
• IMPORTDATA: The API endpoint may have changed or be rate-limited
• Apps Script: Check the script editor for error messages (View > Execution log)

Prices seem outdated

• GOOGLEFINANCE: This is expected — prices have a ~20-minute delay
• CoinTable: Press Ctrl+Shift+F9 or use the CoinTable refresh button
• IMPORTDATA: Add &t= followed by a changing value to bust the cache
• Apps Script: Clear the cache with CacheService.getScriptCache().removeAll()

"Request limit exceeded"

CoinTable Free includes 300 requests per month. If you need more, the Plus plan offers unlimited requests for $5/month. IMPORTDATA and Apps Script are subject to the external API's rate limits.

Conclusion

Getting crypto prices in Google Sheets does not have to be complicated. Here is the bottom line:

• Use GOOGLEFINANCE if you only need BTC or ETH and can tolerate a 20-minute delay.
• Use CoinTable if you want the fastest, simplest solution with the broadest coverage. Install it, use =CT_PRICE("BTC"), and move on with your day.
• Use IMPORTDATA if you need a single price and do not want to install anything at all.
• Use Apps Script if you need custom data processing and are comfortable with JavaScript.

For 95% of users, CoinTable is the right choice. It is free to start, takes 30 seconds to set up, and covers 10,000+ cryptocurrencies in 50+ fiat currencies.

Related Guides

Getting Started

• How to Track Bitcoin Price in Google Sheets — step-by-step for BTC specifically
• Track Ethereum Price in Google Sheets — ETH prices plus gas and staking context
• Track Solana, DOGE & Altcoin Prices — multi-coin watchlists beyond the majors
• GOOGLEFINANCE Crypto Limitations — full breakdown of what GOOGLEFINANCE can and cannot do

Tools and Add-ons

• Best Crypto Add-ons for Google Sheets — comparison of all available add-ons
• CoinTable vs CoinGecko for Google Sheets — detailed feature comparison
• CoinTable vs CRYPTOFINANCE — migrating off CRYPTOFINANCE after the Cryptowatch sunset

Building Your Spreadsheet

• Crypto Portfolio Tracker in Google Sheets — build a full portfolio dashboard
• Google Sheets Crypto Formulas Cheat Sheet — every CoinTable formula with examples
• Best Crypto Google Sheets Templates — ready-made templates to get started fast
• Crypto DCA Calculator in Google Sheets — model dollar-cost averaging with live prices
• Crypto Tax Tracker in Google Sheets — cost basis and gains tracking