CoinTable guides
RSSStart with the full walkthrough, then pick the guide for the job in front of you: a portfolio tracker, a broken GOOGLEFINANCE formula, a move off CRYPTOFINANCE, or a comparison of add-ons. For every formula and its arguments, see the formula reference.
- Guides
How to Get Bitcoin & Crypto Prices in Google Sheets (2026)
Get the Bitcoin price in Google Sheets with one formula, plus 10,000+ altcoins. No API key. Includes a GOOGLEFINANCE coin test and #N/A fixes.
· 12 min read
- Comparisons
CoinGecko API in Google Sheets: Key, Limits & Errors (2026)
Use the CoinGecko API in Google Sheets: Demo API key, rate limits, paid plans and 429 errors as of October 2026, plus a way to get prices with no API key.
· 8 min read
- Guides
GOOGLEFINANCE Crypto: 17 of 30 Coins Work, Tested (2026)
Tested October 15, 2026: =GOOGLEFINANCE("CURRENCY:BTCUSD") works for 17 of 30 top coins. Full ticker list, #N/A fixes, and a no-API-key option.
· 7 min read
- Trackers
Crypto Portfolio Tracker in Google Sheets (Free Template, 2026)
Copy a free crypto portfolio tracker for Google Sheets: current prices, P&L, allocation and a DCA tab with average cost. No API key, no signup needed.
· 10 min read
- Comparisons
CRYPTOFINANCE in Google Sheets Not Working? The Fix (2026)
CRYPTOFINANCE stopped working after the Cryptowatch API shutdown. Swap =CRYPTOFINANCE("BTC/USD") for =COINTABLE("BTC/USD"): same pair, formula map, regex fix, no API key.
· 7 min read
- Comparisons
CoinGecko for Sheets vs CoinTable: Key or No Key? (2026)
CoinGecko for Sheets needs a CoinGecko API key; CoinTable needs no API key. Compare formulas, limits and errors, and when each add-on is the better pick.
· 8 min read