CoinTable is a Google Sheets™ add-on that returns crypto prices and market data through formulas. Type =CT_PRICE("BTC") in a cell to get the Bitcoin price, or get the crypto price of any of 10,000+ cryptocurrencies, including Ethereum, Solana and smaller altcoins. It works as a crypto alternative to the GOOGLEFINANCE function. The free plan needs no signup, and there is no API key to paste.

🚀 How to get crypto prices in Google Sheets
1. Install CoinTable.
2. Type =CT_PRICE("ETH") in any cell for the Ethereum price in US dollars.
3. Put tickers in column A and fill =CT_PRICE(A2) down the column.
You can also choose Extensions > CoinTable > Open to add coins or a ready-made sheet from the CoinTable panel.

📊 10 formulas for cryptocurrency data
• Price: =CT_PRICE("SOL")
• Percent change over 24h, 7d, 30d or 1y: =CT_CHANGE("XRP", "USD", "7d")
• 24h high and low: =CT_HIGH("BNB"), =CT_LOW("BNB")
• Market cap: =CT_MARKETCAP("ADA")
• 24h trading volume: =CT_VOLUME("DOGE")
• Market cap rank: =CT_RANK("AVAX")
• Circulating supply: =CT_SUPPLY("LINK")
• All time high (ATH) and % below it: =CT_ATH("BTC"), =CT_ATHCHANGE("BTC")
Add a currency as the second argument, as in =CT_PRICE("BTC", "EUR"). USD is the default, and 50+ currencies work, including EUR, GBP and JPY.
Supported coins include Bitcoin, Ethereum, Solana, XRP, BNB, Cardano, Dogecoin, Litecoin and stablecoins such as USDT and USDC.

💼 Portfolio trackers, watchlists and dashboards
For a portfolio tracker, put amounts in column B: =CT_PRICE(A2)*B2 gives the value of each holding and SUM gives the total. For a watchlist, =CT_CHANGE(A2) shows the 24h % change of each coin. A dashboard can mix market cap, volume and rank with Sheets charts, and you can price a monthly report in EUR or GBP.
Investors and traders keep their portfolios in their own spreadsheet, and CoinTable never asks for a wallet or exchange keys.

📋 Ready-made sheets
Add a Starter watchlist, a Portfolio tracker with a pie chart or a Market overview in one click from the CoinTable panel. Each one is added as a new sheet, with tickers in column A that you can change.

🔄 How prices update
One click on Refresh in the CoinTable panel (or Extensions > CoinTable > Refresh data) updates every CT_ formula in the file. With Plus, prices also update each time you open the spreadsheet and, with Auto-refresh on, every hour on their own, even when the file is closed. Our server caches prices for 5 to 30 minutes.

💳 Pricing
Both plans include all supported coins, every formula and every currency.
• Free: $0, 150 updates a month, no card.
• Plus: unlimited updates and hourly auto-refresh, $48 a year or $6 a month. 14-day money-back guarantee, cancel anytime.

🔒 Privacy
CoinTable sends only each formula's ticker, currency and period, plus an anonymous key, to cointable.pro over HTTPS. Your amounts and the rest of the spreadsheet are never sent. It opens only the spreadsheets where you use it and does not read your Google account email. Google's permission list also includes running when you are not present: CoinTable uses it only for Plus scheduled refresh, which you turn on for each spreadsheet. Lemon Squeezy asks for an email and card details only if you buy Plus.

💬 Help
hi@cointable.pro
Docs and FAQ: cointable.pro/docs

Not financial advice.
Google Sheets™ is a trademark of Google LLC.