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. If a cell asks you to activate CoinTable, choose Activate once from Extensions › CoinTable.

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, cells keep the prices they show until the reset. Plus adds unlimited updates for normal use 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. Refresh Data looks up each distinct value once, so 50 cells with =CT_PRICE("BTC") use 1 update. A sheet of 10 coins uses 10 updates per refresh, so the free plan covers about 15 refreshes a month. Lookups that end in an error count too.

Prices update when you choose Refresh Data from Extensions › CoinTable; nothing updates on its own. A new formula looks up its price when you type it. 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. 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 (reserved for scheduled refresh, not switched on yet). 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: email hi@cointable.pro within 14 days for a full refund. You can cancel anytime, and Plus stays active until the end of the period you paid for.