Guides

Crypto in Google Sheets, explained

Short, practical guides for tracking cryptocurrency in a spreadsheet — prices, history, tax and more. No API keys, no code.

How to get live crypto prices in Google Sheets

The one-formula method for live Bitcoin, Ethereum and 1,000+ prices — no API key. Start here.

Crypto tax & cost basis in Google Sheets

Automatic historical buy prices, per-lot profit/loss, and short vs long-term gains with a one-click template.

How to get the Bitcoin price in Google Sheets

Live and historical BTC prices — dollars, euros, sats — with one formula. No API key.

Build a crypto portfolio tracker in Google Sheets

Holdings, live value, allocation and profit/loss that update themselves — or use the one-click template.

How to get the Ethereum price in Google Sheets

Live and historical ETH prices, the ETH/BTC ratio, and any currency — one formula.

A simpler crypto add-on for Google Sheets

Comparing crypto add-ons? An honest look at where CryptoTrackPro fits — no API key, free to start.

A CryptoFinance alternative for Google Sheets

Weighing CryptoFinance? See how a simpler, one-formula add-on compares.

Full formula reference & setup guide

Every formula, installation steps, permissions and troubleshooting in one place.

Ready to try it?

Install free — 50 lookups a day, no API key, no card.

Install CryptoTrackPro free