CoinTable brings real-time cryptocurrency market data into Google Sheets™ — prices, hourly/daily/weekly changes, market cap, volume, rank, circulating supply and all-time highs for Bitcoin, Ethereum and 10,000+ other coins.

You can track live prices, compare performance over time, analyze market metrics, and build dashboards or portfolio trackers without API keys or coding.

🚀 How to start

1. Install the add-on
2. In a cell, type:
    =CT_PRICE("BTC", "USD")
3. Get the current Bitcoin price in USD


🔎 Examples

– Price → =CT_PRICE("BTC", "USD")
– Change (24h) → =CT_CHANGE("ETH", "USD", "24h")
– Change (7d) → =CT_CHANGE("BTC", "USD", "7d")
– High 24h → =CT_HIGH("BTC", "USD")
– Low 24h → =CT_LOW("BTC", "USD")
– Market Cap → =CT_MARKETCAP("SOL", "USD")
– Volume (24h) → =CT_VOLUME("ADA", "USD")
– Rank → =CT_RANK("DOGE")
– Supply → =CT_SUPPLY("MATIC")
– ATH → =CT_ATH("AVAX", "USD")
– % from ATH → =CT_ATHCHANGE("AVAX", "USD")


⚡ Features

✓ Real-time crypto market data — prices, hourly/daily/weekly change, 24h high/low, market cap, volume, rank, circulating supply, ATH and % from ATH
✓ 10,000+ cryptocurrencies supported — build portfolio trackers for Bitcoin, Ethereum, Solana, Dogecoin and more
✓ Built for Google Sheets™ — turn any spreadsheet into a cryptocurrency tracker with native formulas and flexible layouts
✓ Sidebar formula builder — search a coin, pick a metric, insert a ready-to-use formula
✓ No setup required — no API keys, no accounts, no coding
✓ Secure by design — requests are encrypted; your spreadsheet data stays private


👥 Who is it for

– Traders and investors tracking portfolios
– Analysts building dashboards and reports
– Teams using crypto data in Google Sheets™