Crypto prices & market data for Google Sheets

Install the CoinTable add-on from the Google Workspace Marketplace, then type =CT_PRICE("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 =CT_PRICE(A2) down. On a computer, the CoinTable panel can also add the formulas or a ready-made table for you.

Yes. The free plan includes 150 updates a month, all 10 formulas, 10,000+ coins and 50+ currencies, with no credit card. Free updates reset on the 1st of each month (UTC). When they run out, CoinTable pauses updates until the reset. Plus adds unlimited updates for normal use and scheduled refresh for $48 a year.

CoinTable covers 10,000+ coins by ticker, from Bitcoin and Ethereum to small altcoins. Prices come in 50+ currencies, including USD, EUR, GBP and JPY, and in BTC, ETH or sats. USD is the default; add a currency as the second argument: =CT_PRICE("BTC", "EUR"). When two coins share a ticker, CoinTable uses the larger one.

An update is one value CoinTable looks up: one coin, one metric and one currency, plus the period for % change. Each refresh looks up every distinct value in the file once, so 50 cells with =CT_PRICE("BTC") use 1 update. Opening the file uses up to one update per CoinTable cell, and none if you reopen it within 5 minutes. A sheet of 10 coins uses about 10 updates per refresh or open, so the free plan covers about 15 a month.

Prices refresh when an editor opens the spreadsheet and when you press Refresh. On Plus, you can also turn on refresh every hour, every 4 hours or once a day for each spreadsheet. CoinTable's server caches market data for 5 to 30 minutes, so prices aren't up to the second.

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.

Yes. Only each formula's ticker, currency and period 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.

CoinTable gets market data from a third-party crypto data provider. Its own server at cointable.pro fetches the data, caches it for 5 to 30 minutes and passes it to your sheet. You don't need an account with the provider.

CT_ formulas stop recalculating and show an unknown-function error, because the functions come 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.

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.

No. CoinTable has no price history: it returns current market data. CT_CHANGE gives the % change over 24h, 7d, 30d or 1y, and CT_ATH gives the all-time high, but there's no formula for the price on a past date. CoinTable doesn't send price alerts or offer a separate API either.

No. CoinTable is a Google Sheets add-on, installed from the Google Workspace Marketplace, and its formulas work only in Google Sheets.

Yes. Plus has a 14-day money-back guarantee on your first payment, once per customer. Open the Account tab in the CoinTable panel and click Get 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.