Best Crypto Google Sheets Templates (2026)
TL;DR
5 free crypto Google Sheets templates you can build today using CoinTable formulas: Portfolio Tracker, DCA Calculator, Watchlist, Multi-Currency Converter, and Tax Helper. Each template uses live data — no manual price updates.
Why Use Templates?
Building a crypto spreadsheet from scratch takes time. These templates give you a head start with proven layouts and formulas. Each one uses CoinTable to pull live prices, so your data is always current.
Requirements: Install the free CoinTable add-on to use these templates.
Template 1: Portfolio Tracker
Track the value of all your crypto holdings in one place.
What it does: Shows each coin's current price, your quantity, total value, profit/loss, and allocation percentage.
Key Formulas
| Column | Formula | Description |
|---|---|---|
| Current Price | =CT_PRICE(A2) | Live price from CoinTable |
| 24h Change | =CT_CHANGE(A2) | Daily change percentage |
| Total Value | =CT_PRICE(A2) * C2 | Price × quantity |
| P/L | =CT_PRICE(A2) * C2 - D2 * C2 | Current value minus cost basis |
| Allocation | =E2 / SUM(E$2:E$20) | Percentage of total portfolio |
Layout
| Coin | Ticker | Qty | Avg Cost | Price | 24h % | Value | P/L |
|---|---|---|---|---|---|---|---|
| Bitcoin | BTC | 0.5 | $45,000 | =CT_PRICE("BTC") | =CT_CHANGE("BTC") | ... | ... |
| Ethereum | ETH | 10 | $2,800 | =CT_PRICE("ETH") | =CT_CHANGE("ETH") | ... | ... |
Add a summary row at the top with =SUM() for total portfolio value and overall P/L.
Template 2: DCA Calculator
Plan and track your dollar-cost averaging strategy.
What it does: Shows your average entry price, total invested, current value, and DCA performance over time.
Key Formulas
Current Price: =CT_PRICE("BTC")
Total Invested: =SUM(B2:B100)
Total Coins: =SUM(C2:C100)
Average Cost: =SUM(B2:B100) / SUM(C2:C100)
Current Value: =SUM(C2:C100) * CT_PRICE("BTC")
Total Return: =(Current Value - Total Invested) / Total Invested
Layout
| Date | Amount ($) | Coins Bought | Price at Purchase |
|---|---|---|---|
| 2026-01-01 | $200 | 0.00285 | $70,175 |
| 2026-02-01 | $200 | 0.00278 | $71,942 |
| 2026-03-01 | $200 | 0.00291 | $68,728 |
Add a dashboard at the top showing average cost vs. current price to see how your DCA strategy is performing.
Template 3: Watchlist
Monitor coins you're interested in without tracking holdings.
What it does: A quick-reference dashboard showing price, change, market cap, volume, and rank for your favorite coins.
Key Formulas
For each coin in your watchlist (with ticker in column A):
Price: =CT_PRICE(A2)
24h Change: =CT_CHANGE(A2)
Market Cap: =CT_MARKETCAP(A2)
Volume: =CT_VOLUME(A2)
Rank: =CT_RANK(A2)
ATH: =CT_ATH(A2)
vs ATH: =CT_ATHCHANGE(A2)
Layout
| Ticker | Price | 24h % | Market Cap | Volume | Rank | ATH | vs ATH % |
|---|---|---|---|---|---|---|---|
| BTC | =CT_PRICE("BTC") | =CT_CHANGE("BTC") | =CT_MARKETCAP("BTC") | ... | ... | ... | ... |
| ETH | =CT_PRICE("ETH") | =CT_CHANGE("ETH") | =CT_MARKETCAP("ETH") | ... | ... | ... | ... |
| SOL | =CT_PRICE("SOL") | =CT_CHANGE("SOL") | =CT_MARKETCAP("SOL") | ... | ... | ... | ... |
Use conditional formatting to highlight cells green (positive change) or red (negative change).
Template 4: Multi-Currency Converter
See crypto prices in multiple fiat currencies side by side.
What it does: Shows any crypto's price in USD, EUR, GBP, JPY, and other currencies simultaneously.
Key Formulas
CoinTable's second argument controls the fiat currency:
USD: =CT_PRICE("BTC", "USD")
EUR: =CT_PRICE("BTC", "EUR")
GBP: =CT_PRICE("BTC", "GBP")
JPY: =CT_PRICE("BTC", "JPY")
CHF: =CT_PRICE("BTC", "CHF")
AUD: =CT_PRICE("BTC", "AUD")
Layout
| Coin | USD | EUR | GBP | JPY | AUD |
|---|---|---|---|---|---|
| BTC | =CT_PRICE("BTC","USD") | =CT_PRICE("BTC","EUR") | ... | ... | ... |
| ETH | =CT_PRICE("ETH","USD") | =CT_PRICE("ETH","EUR") | ... | ... | ... |
This template is especially useful for international traders or anyone reporting in multiple currencies.
Template 5: Tax Helper
Organize your trades for tax reporting.
What it does: Records buy/sell transactions with current market values to help calculate capital gains and losses.
Key Formulas
Current Price: =CT_PRICE(B2)
Current Value: =CT_PRICE(B2) * C2
Cost Basis: =D2 * C2
Unrealized P/L: =CT_PRICE(B2) * C2 - D2 * C2
Realized P/L: =F2 * G2 - D2 * G2 (sell price × qty - avg cost × qty)
Layout
| Date | Coin | Qty | Avg Cost | Action | Sell Price | Current Price | Unrealized P/L |
|---|---|---|---|---|---|---|---|
| 2026-01-15 | BTC | 0.1 | $68,000 | BUY | — | =CT_PRICE("BTC") | ... |
| 2026-02-20 | ETH | 5 | $2,500 | BUY | — | =CT_PRICE("ETH") | ... |
Note: This template is a starting point for organization. Always consult a tax professional for your specific situation.
Getting Started
- Install CoinTable — Get it free from Google Workspace Marketplace
- Copy a template — Create a new Google Sheet and set up the columns from any template above
- Add your data — Enter your tickers, quantities, and costs
- Watch it update — CoinTable formulas pull live prices automatically
All five templates work with CoinTable's free tier (500 requests/month). For heavy users tracking 20+ coins, the Plus plan ($5/month) gives you 10,000 requests and auto-refresh.
Admin
CoinTable Team