CoinTable is a Google Sheets™ add-on that returns crypto prices and market data with one formula, COINTABLE. Type =COINTABLE("BTC") in a cell to get the Bitcoin price, or get the price of any cryptocurrency or token: 10,000+ cryptocurrencies, from Ethereum, Solana, XRP, BNB and Dogecoin to smaller altcoins and a stablecoin such as USDT. It works like the GOOGLEFINANCE function, for crypto. 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. In your spreadsheet, choose Extensions > CoinTable > Open once.
3. Type =COINTABLE("ETH") in any cell for the Ethereum price in US dollars.
4. Put tickers in column A and fill =COINTABLE(A2) down, or fill the whole column at once with =COINTABLE(A2:A20).
The CoinTable panel can also add coins or a ready-made template for you.
📊 One formula, 20 attributes
=COINTABLE(coin, [attribute], [period or date])
• Price in another currency, at the current exchange rate: =COINTABLE("BTC/EUR")
• Percent change over 24h: =COINTABLE("XRP", "changepct")
• Change over 1h, 7d, 30d or 1y (Plus): =COINTABLE("SOL", "changepct", "7d")
• Market cap, volume and rank: =COINTABLE("ADA", "marketcap")
• 24h high and low: =COINTABLE("BNB", "high")
• Supply, max supply and FDV: =COINTABLE("LINK", "maxsupply")
• All-time high and low, with their dates: =COINTABLE("BTC", "ath")
• Historical price on a past date, up to a year back (Plus): =COINTABLE("BTC", "price", DATE(2026,6,30))
• Coin name: =COINTABLE("AVAX", "name")
USD is the default, and 63 currencies work, including EUR, GBP and JPY, so the same formula is also a crypto converter. If your spreadsheet uses a decimal comma, separate the arguments with semicolons.
Moving from GOOGLEFINANCE? For crypto, =GOOGLEFINANCE("CURRENCY:BTCEUR") becomes =COINTABLE("BTC/EUR"). Do this only for crypto: some stock tickers, such as TSLA and META, are also coin tickers.
Older formulas such as =CT_PRICE("BTC") keep working. Switch to COINTABLE in the CoinTable panel moves a spreadsheet to the new formula, and the numbers stay the same.
💼 Portfolio tracker, watchlist and dashboard
For a crypto portfolio tracker or investment tracker, put amounts in column B: =COINTABLE(A2)*B2 gives the value of each holding and SUM gives the total. For a watchlist, =COINTABLE(A2, "changepct") 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.
📋 Templates
Add a Starter watchlist, a Portfolio tracker with a pie chart or a Market overview template 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
Prices refresh when you press Refresh in the CoinTable panel or choose Extensions > CoinTable > Refresh data. On Plus, they also refresh when the spreadsheet is opened, and every hour once you turn on Auto for that spreadsheet, even when the file is closed. Free prices are up to 30 minutes old, Plus prices up to 5 minutes.
💳 Pricing
Both plans include all supported coins and currencies, and every attribute.
• Free: $0, no card. 300 updates a month, prices up to 30 minutes old, the 24h change. An update is one coin in one currency: all its attributes count once, and the same coin again within 6 hours is free. When the updates run out, cells keep their last values until the 1st.
• Plus: $48 a year or $6 a month. Unlimited updates for normal use, prices up to 5 minutes old, 1h, 7d, 30d and 1y changes, price history by date, and refresh on open and every hour. 14-day money-back guarantee, cancel anytime.
🔒 Privacy
CoinTable sends only each formula's ticker, currency, attribute and period or date, plus an anonymous key and the spreadsheet's ID, to cointable.pro over HTTPS. Our server keeps the ID only as a one-way hash. 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 the Plus hourly auto-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.