Best Crypto Google Sheets Templates (2026)

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, a Google Sheets add-on for cryptocurrency prices, to pull live prices, so your data is always current. If you're new to getting crypto data into Google Sheets, start with our guide on how to get crypto prices in Google Sheets.

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

Layout

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

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

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

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

Note: This template is a starting point for organization. Always consult a tax professional for your specific situation.

Getting Started

1. Install CoinTable — Get it free from Google Workspace Marketplace
2. Copy a template — Create a new Google Sheet and set up the columns from any template above
3. Add your data — Enter your tickers, quantities, and costs
4. Watch it update — CoinTable formulas pull live prices automatically

All five templates work with CoinTable's free tier (300 requests/month). For heavy users tracking 20+ coins, the Plus plan ($5/month) gives you unlimited requests and auto-refresh.

For a deeper dive into individual templates, see our crypto portfolio tracker guide, DCA calculator tutorial, and crypto tax tracker guide. For a quick reference of all available formulas, check the crypto formulas cheat sheet.