Crypto prices & market data for Google Sheets
Type =COINTABLE("BTC") in any cell and Bitcoin's price appears. 10,000+ coins, 63 currencies, no API key to paste.
4.5 on Google Workspace Marketplace · 1K+ installs
Free for 300 updates a month · No signup · No API key
| 1 | Coin | Price, $ | 24h, % |
|---|---|---|---|
| 2 | BTC | 102,942.00 | +1.84 |
| 3 | ETH | 2,485.25 | +0.92 |
| 4 | BNB | 642.18 | −0.34 |
| 5 | SOL | 167.84 | −2.10 |
| 6 | LTC | 94.20 | +0.62 |
| 7 | AVAX | 21.40 | +1.62 |
| 8 | LINK | 17.32 | +1.20 |
| 9 | UNI | 9.86 | +2.41 |
| 10 | ATOM | 4.73 | −1.05 |
| 11 | DOT | 3.85 | −0.48 |
| 12 | XRP | 2.37 | +0.41 |
| 13 | USDT | 1.00 | +0.01 |
| 14 | ADA | 0.89 | +3.05 |
| 15 | TRX | 0.28 | +0.74 |
| 16 | DOGE | 0.16 | −0.87 |
Prices and market data, right in your cells
The market data your sheet needs
Price, % change, 24h high and low, market cap, volume, rank, supply and all-time high, all from one formula.
Your coins, in your currency
Look up Bitcoin, Ethereum and thousands of smaller coins by ticker, in USD, EUR, GBP, JPY or even BTC and sats. 10,000+ coins, 63 currencies.
Fresh when you need it
Press Refresh to update every price in the file. On Plus, prices also refresh when you open the file, and every hour once you turn on auto-refresh. Prices are up to 30 minutes old on Free, and up to 5 minutes on Plus.
Start in three steps
Free on the Google Workspace Marketplace.
=COINTABLE("BTC")in any cell returns Bitcoin's price.Put tickers in a column and fill
=COINTABLE(A2)down, or add them from the CoinTable panel.
Try it on the sheet you already have.
Install free(opens in a new tab)Free for 300 updates a month · No signup · No API key
What changes in your sheet
Without CoinTable
- Copying prices from a website, cell by cell
- GOOGLEFINANCE covers only a few major coins
- Scripts and API keys to set up
- Copying prices in by hand, coin by coin
- Moving your portfolio into another app
With CoinTable
=COINTABLE("BTC")fills the cell- 10,000+ coins by ticker
- No signup, no API key to paste
- One Refresh updates every price in the file
- Your amounts stay in your own spreadsheet
Your crypto amounts never leave Google Sheets
Only the lookup leaves
Only each formula’s ticker, currency, field and period or date leave Google Sheets, with an anonymous key. Your amounts and the rest of the spreadsheet stay where they are.
Anonymous account
No name, no email. Just a random key that server logs don’t keep.
Only the sheets you use it in
No access to the rest of your Google Drive.
Questions before you install
How do I get crypto prices in Google Sheets?
Install the CoinTable add-on from the Google Workspace Marketplace, then type
=COINTABLE("BTC") in any cell. The cell shows Bitcoin's price in US dollars. To track a list of coins, put the tickers in column A and fill =COINTABLE(A2) down. On a computer, the CoinTable panel can also add the formulas or a ready-made table for you.Is CoinTable free?
Yes. The free plan includes 300 updates a month, prices up to 30 minutes old, all fields with the 24h change, 10,000+ coins and 63 currencies, with no credit card. Free updates reset on the 1st of each month (UTC). When they run out, cells keep their last values until the reset. Plus adds unlimited updates for normal use, prices up to 5 minutes old, the 1h, 7d, 30d and 1y changes and price on a past date for $48 a year.
Which coins and currencies can I track?
CoinTable covers 10,000+ coins by ticker, from Bitcoin and Ethereum to small altcoins. Prices come in 63 currencies, including USD, EUR, GBP and JPY, and in BTC, ETH or sats. USD is the default; for another currency, write a pair with a slash:
=COINTABLE("BTC/EUR"). When two coins share a ticker, CoinTable uses the larger one.What counts as an update?
An update is one coin in one currency. Every field of that coin in that currency counts once, and the same coin again within 6 hours is free. Errors and duplicates use no updates. So 50 cells of
=COINTABLE("BTC") plus =COINTABLE("BTC", "marketcap") use 1 update, and =COINTABLE("BTC/EUR") is another. A tracker of 10 coins in USD uses 10 updates per refresh, and nothing if you refresh again within 6 hours. Free's 300 cover one refresh a day for a month.How often do prices update?
On Free, prices are up to 30 minutes old. On Plus, up to 5 minutes. When the data source is busy, prices can be older, up to an hour. Prices refresh when you press Refresh. On Plus, they also refresh when an editor opens the file, and every hour once you turn on Auto for the spreadsheet, even while it's closed.
Do I need an API key or an account?
No. CoinTable needs no signup and no API key. The first time you use it, it creates an anonymous account with a random key, without your email. If you buy Plus, LemonSqueezy asks for your email and payment details at checkout.
Is my spreadsheet data private?
Yes. Only each formula's ticker, currency, field and period or date leave Google Sheets, with an anonymous key. Your amounts and the rest of the spreadsheet stay where they are. CoinTable can access only the spreadsheets you use it in, not the rest of your Google Drive, and never collects your email. It runs while you're away only for the Plus auto-refresh you turn on. Your data isn't used for ads and isn't sold.
Where does the price data come from?
CoinTable gets market data from a third-party crypto data provider. Its own server at cointable.pro fetches the data and passes it to your sheet: prices are up to 30 minutes old on Free and up to 5 minutes on Plus. You don't need an account or API key with any data provider.
What happens to my formulas if I remove the add-on?
CoinTable formulas stop recalculating and show an unknown-function error, because the function comes from the add-on. To keep the last prices, select the range and use Paste special › Values only before you uninstall. Your sheet and everything else in it stay as they are.
Which permissions does CoinTable ask for, and why?
Google lists these when you install: see and edit only the spreadsheet you have open (to write prices into cells), connect to an external service (to fetch prices), show its menu and sidebar, read your locale (for number formats), and run on a schedule (for the Plus auto-refresh you turn on). Google also shows your email address and basic profile; CoinTable's code doesn't read them, and the account it creates is anonymous.
Can CoinTable show past prices?
Yes, on Plus.
=COINTABLE("BTC", "price", DATE(2026,6,30)) shows Bitcoin's price on June 30, 2026. The date can also be text like "2026-06-30" or a cell with a date. It works for price only, within the last year, and the day is counted in your spreadsheet's time zone. CoinTable doesn't send price alerts or offer a separate API.Does CoinTable work in Excel?
No. CoinTable is a Google Sheets add-on, installed from the Google Workspace Marketplace, and its formulas work only in Google Sheets.
Can I get a refund for Plus?
Yes. Plus has a 14-day money-back guarantee on your first payment, once per customer. In the CoinTable panel, open ⋮ › Plan and billing, click Cancel Plus… and choose Now, with a refund; the money goes back to your payment method, usually within 5 to 10 business days. You can cancel anytime, and Plus stays active until the end of the period you paid for.
Stop copying crypto prices by hand
Install free(opens in a new tab)Free for 300 updates a month · No signup · No API key