Track Bitcoin Price in Google Sheets (2026 Guide)

4 Ways to Get Bitcoin Price in Google Sheets

There are four methods to pull BTC price into a spreadsheet. Here's the quick comparison before we go deep on each one. For the full guide covering all cryptocurrencies, see how to get crypto prices in Google Sheets.

CoinTable, a Google Sheets add-on for cryptocurrency prices, is the recommended method. It gives you the most BTC data points with the least setup. If you're evaluating all available add-ons, see the best crypto add-ons for Google Sheets comparison.

Method 1: CoinTable (Recommended)

Install

1. Open Google Sheets
2. Go to Extensions → Add-ons → Get add-ons
3. Search "CoinTable"
4. Click Install
5. Type =CT_PRICE("BTC") in any cell

That's it. No API key. No account. No configuration.

Bitcoin Formulas

CoinTable gives you a dedicated formula for every BTC data point:

=CT_PRICE("BTC")          → $84,215.00    Current price in USD
=CT_PRICE("BTC", "EUR")   → €77,840.00    Current price in euros
=CT_CHANGE("BTC")         → -1.82         24h price change (%)
=CT_ATH("BTC")            → $108,786.00   All-time high price
=CT_MARKETCAP("BTC")      → $1,672,000,000,000   Market cap
=CT_VOLUME("BTC")         → $38,200,000,000      24h trading volume
=CT_RANK("BTC")           → 1             Market cap rank
=CT_SUPPLY("BTC")         → 19,840,000    Circulating supply

Every formula uses the same pattern: function name + ticker. No full coin names, no currency pair suffixes, no exchange identifiers. Just "BTC".

Price in Different Currencies

CoinTable supports 50+ fiat currencies. Add the currency code as a second argument:

=CT_PRICE("BTC", "USD")    US Dollar
=CT_PRICE("BTC", "EUR")    Euro
=CT_PRICE("BTC", "GBP")    British Pound
=CT_PRICE("BTC", "JPY")    Japanese Yen
=CT_PRICE("BTC", "CHF")    Swiss Franc
=CT_PRICE("BTC", "AUD")    Australian Dollar
=CT_PRICE("BTC", "CAD")    Canadian Dollar
=CT_PRICE("BTC", "BRL")    Brazilian Real

Method 2: GOOGLEFINANCE

=GOOGLEFINANCE("BTCUSD")

Built into Google Sheets — no installation needed. Returns the Bitcoin price in USD with an approximately 20-minute delay.

Limitations: Only returns price. No market cap, no volume, no 24h change, no historical crypto data. Only supports USD. For the full breakdown, read GOOGLEFINANCE crypto limitations.

This method works if you literally only need a single delayed BTC price and nothing else.

Method 3: CoinGecko API

function BTC_PRICE() {
  const API_KEY = "YOUR_DEMO_KEY";
  const url = `https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd&x_cg_demo_api_key=${API_KEY}`;
  const response = UrlFetchApp.fetch(url);
  const data = JSON.parse(response.getContentText());
  return data.bitcoin.usd;
}

Then use =BTC_PRICE() in your sheet.

Requirements: CoinGecko account, API key (free Demo tier available), Apps Script knowledge. Setup takes 5-10 minutes.

When to use: If you need historical BTC price data over time, CoinGecko's API is currently the best free source. For current price tracking, CoinTable is simpler.

Method 4: Direct Apps Script (Any API)

You can write custom Apps Script functions that call any public API — Binance, Coinbase, CryptoCompare, etc.

function BTC_PRICE_BINANCE() {
  const url = "https://api.binance.com/api/v3/ticker/price?symbol=BTCUSDT";
  const response = UrlFetchApp.fetch(url);
  const data = JSON.parse(response.getContentText());
  return parseFloat(data.price);
}

When to use: If you need exchange-specific pricing (e.g., Binance BTC price vs. Coinbase BTC price) or you're already comfortable with Apps Script.

Downsides: You maintain the code. APIs change endpoints, rate limits, and authentication requirements. When they do, your spreadsheet breaks until you fix the script.

Build a BTC Dashboard in 5 Minutes

Here's a complete Bitcoin dashboard layout using CoinTable formulas. Create a new sheet and set it up like this:

Dashboard Layout

Formatting Tips

• Column A: Labels, bold, 150px width
• Column B: Formulas/values, right-aligned, 200px width
• Price cells: Format as Currency ($)
• Change cells: Format as Percentage (%) and add conditional formatting — green for positive, red for negative
• Market Cap/Volume: Format as Number with no decimals, or use a custom format like $#,##0,,"M" to show millions

Add a Holdings Tracker Below

This gives you a one-page BTC command center: current market data on top, your personal position below.

Auto-Refresh Setup

By default, CoinTable formulas update when you open the spreadsheet or manually recalculate (Ctrl+Shift+F9 on Windows, Cmd+Shift+F9 on Mac).

For automatic background refreshing:

Free Tier — Manual Refresh Trigger

Create a simple Apps Script trigger to force recalculation on a schedule:

1. Go to Extensions → Apps Script
2. Add this function:

function refreshSheet() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet();
  const range = sheet.getActiveSheet().getDataRange();
  range.setValues(range.getValues());
}

3. Set a time-driven trigger to run it every hour or every 4 hours

This forces the sheet to re-evaluate all formulas, including CoinTable functions.

Plus Plan — Built-in Auto-Refresh

CoinTable Plus ($5/month) includes native auto-refresh. Prices update automatically without any script setup. If you're checking your BTC dashboard multiple times a day, this pays for itself in convenience.

Beyond Bitcoin

Once your BTC dashboard is working, extending it to other coins is trivial. The same formulas work for every supported cryptocurrency — just change the ticker:

=CT_PRICE("ETH")       Ethereum
=CT_PRICE("SOL")       Solana
=CT_PRICE("DOGE")      Dogecoin
=CT_PRICE("ADA")       Cardano

For an Ethereum-specific setup, see track Ethereum price in Google Sheets. For a broader multi-coin tracker, check out track altcoin prices in Google Sheets.

The complete list of formulas and their arguments is in the crypto formulas cheat sheet.

Quick Reference

Install CoinTable from Google Workspace Marketplace, type =CT_PRICE("BTC"), and your Bitcoin dashboard is live.