What is the best free way to get crypto in Google Sheets?

Install the free CryptoTrackPro add-on and type =cryptotrackpro("BTC-USD") in any cell. It returns the live price and works for 10,000+ coins in 150+ currencies, with no API key and no code. The free plan includes 50 lookups per day.

Is getting crypto in Google Sheets free?

Yes. CryptoTrackPro's free plan gives 50 crypto lookups per day with no credit card and no API key. Paid Base and Pro plans raise or remove the limit for heavier use.

Do I need an API key to put crypto in a spreadsheet?

No. Some methods require signing up for a market-data API and pasting a key, but CryptoTrackPro handles the data for you — you just install the add-on and use the formula.

Crypto in Sheets — the Free, Simple Way (Google Sheets)

The best free way to get crypto in Google Sheets is the CryptoTrackPro add-on: install it, then type =cryptotrackpro("BTC-USD") and you get the live Bitcoin price. It covers 10,000+ coins in 150+ currencies, needs no API key, and the free plan does 50 lookups a day. That's the whole answer — the rest of this page shows the setup and how it compares.

Get crypto in a sheet in 30 seconds

In any Google Sheet, open Extensions → Add-ons → Get add-ons and search CryptoTrackPro. Install it (tick every permission box).
In a cell, type =cryptotrackpro("BTC-USD") and press Enter.
That's it — a live price. Change the pair for any coin or currency.

=cryptotrackpro("ETH-USD") · =cryptotrackpro("SOL-GBP") · =cryptotrackpro("DOGE-EUR")

Why this is the best free option

Actually free: 50 lookups a day, no credit card, no trial clock.
No API key: nothing to sign up for or paste in — unlike raw IMPORTDATA/API methods.
Every coin: 10,000+ coins, where GOOGLEFINANCE only does a few and returns #N/A for the rest.
More than prices: historical prices, portfolio and tax templates, RSI/MACD, and even stocks — all from the same add-on.

Put crypto in your sheet — free

50 lookups a day, no API key, no card.

Install CryptoTrackPro free

Go further

Once prices are in, build something with them:

Live crypto prices — the full formula reference.
Portfolio tracker — holdings, value, P&L and allocation.
Tax & cost basis — historical prices for any date.
Stocks & crypto together — one net-worth dashboard.

Frequently asked questions

Is it really free?

Yes — 50 lookups a day on the free plan, no card, no API key. Base and Pro raise or remove the limit.

Do I need to know any code?

No. It's a single spreadsheet formula — if you can type =SUM(), you can do this.

Crypto in Sheets, the free and simple way