Getting Started with CoinTable
CoinTable is the easiest way to get crypto prices in Google Sheets. Install the add-on, type a formula, and see prices for 10,000+ coins — no signup, no API key to paste, no code.
Step 1: Install CoinTable
- Open CoinTable on the Google Workspace Marketplace.
- Click Install and choose your Google account.
- Grant the permissions. CoinTable works only with the spreadsheet you have open.
- Open any spreadsheet. CoinTable appears under Extensions.
The add-on is free to install and takes under 30 seconds.
Step 2: Use your first formula
Type the following formula in any cell:
=COINTABLE("BTC")
You will see the Bitcoin price in USD.
CoinTable refreshes prices whenever you press Refresh in the CoinTable panel. On Plus, it also refreshes them when you open the spreadsheet (at most once every 5 minutes, up to 200 cells) and every hour if you turn on auto-refresh.
If the cell says "Choose Extensions › CoinTable › Open", do that once.
#NAME? has two causes.
- The coin isn't in quotes.
=COINTABLE(BTC)shows #NAME?; write=COINTABLE("BTC"). Curly quotes, like “BTC” copied from a chat or notes app, break a formula too. Retype the quotes, or use the Copy button next to every formula on this site. - CoinTable hasn't been opened in this spreadsheet yet. Choose Extensions > CoinTable > Open once, and the cells fill in by themselves.
Try another coin:
=COINTABLE("ETH")
This returns the current Ethereum price. CoinTable supports 10,000+ coins — use the coin's ticker symbol.
Step 3: Add pairs and attributes
Put the currency after a slash, and what you want second:
| Formula | Returns |
|---|---|
=COINTABLE("BTC") | Bitcoin price in US dollars |
=COINTABLE("BTC/EUR") | Bitcoin price in euros |
=COINTABLE("ETH", "changepct") | 24h change in percent: 1.5 means +1.5% |
=COINTABLE("ETH", "changepct", "7d") | 7-day change in percent (which periods are free) |
=COINTABLE("BTC", "marketcap") | Market capitalization |
=COINTABLE("SOL", "volume") | 24-hour trading volume |
=COINTABLE("BTC", "high") | 24-hour high price |
=COINTABLE("ADA", "supply") | Circulating supply |
=COINTABLE("BTC", "ath") | All-time high price |
=COINTABLE("DOGE", "rank") | Market cap rank |
=COINTABLE(A2:A20) | A price for every ticker in A2:A20 |
Every formula follows the same pattern: the coin first, then the attribute, then the period or date. The COINTABLE page lists all of them. No API key to paste and nothing to configure.
Step 4: Refresh
Press Refresh in the CoinTable panel to update every CoinTable formula in the file. If a refresh needs more free updates than you have left, CoinTable asks first. Refresh what's left updates as many coins as your updates cover, and the rest keep their values.
Next steps
- Examples — ready-to-use portfolio trackers, dashboards, and more.
- COINTABLE — every attribute, period and error message.
- Supported Currencies — the 63 currencies you can get prices in, and how tickers work.