Getting Started with CoinTable
CoinTable is the easiest way to get real-time crypto prices in Google Sheets. Install the add-on, type a formula, and see live prices for 10,000+ tokens — no API keys, no code, no manual updates.
Step 1: Install CoinTable
- Open any Google Sheets spreadsheet.
- Go to Extensions > Add-ons > Get add-ons.
- Search for CoinTable.
- Click Install and grant the required permissions.
Or install directly from the Google Workspace Marketplace.
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:
=CT_PRICE("BTC")
You will see the current Bitcoin price in USD. The value updates automatically.
Try another coin:
=CT_PRICE("ETH")
This returns the current Ethereum price. CoinTable supports 10,000+ tokens — use any ticker symbol.
Step 3: Explore more formulas
CoinTable provides 10 formulas for comprehensive crypto data:
| Formula | Description | Example |
|---|---|---|
| CT_PRICE | Current price in USD | =CT_PRICE("BTC") |
| CT_CHANGE | Price change percentage (24h) | =CT_CHANGE("ETH") |
| CT_MARKETCAP | Market capitalization | =CT_MARKETCAP("BTC") |
| CT_VOLUME | 24-hour trading volume | =CT_VOLUME("SOL") |
| CT_HIGH | 24-hour high price | =CT_HIGH("BTC") |
| CT_LOW | 24-hour low price | =CT_LOW("ETH") |
| CT_SUPPLY | Circulating supply | =CT_SUPPLY("ADA") |
| CT_ATH | All-time high price | =CT_ATH("BTC") |
| CT_RANK | Market cap rank | =CT_RANK("DOGE") |
| CT_SPARKLINE | 7-day price sparkline | =CT_SPARKLINE("BTC") |
Every formula follows the same pattern: =CT_FUNCTION("TICKER"). No API keys or configuration needed.
Next steps
- Examples — ready-to-use portfolio trackers, dashboards, and templates.
- Supported Currencies — full list of 10,000+ supported tokens and tickers.