Do I need an API key to get crypto prices in Google Sheets?

No. CryptoTrackPro handles all data sourcing for you, so you never need to register for, paste, or manage an exchange API key.

How do I get the Bitcoin price in Google Sheets?

Install CryptoTrackPro and type =cryptotrackpro("BTC-USD") into a cell. Change the pair to ETH-USD, SOL-EUR, or any of 1,000+ supported coins and 150+ currencies.

Is it free to get crypto prices in Google Sheets?

Yes. The free plan includes 50 price lookups per day. Paid plans raise or remove the limit and add auto-refresh and technical indicators.

How to Get Live Crypto Prices in Google Sheets (2026 Guide)

Q: Can Google Sheets pull live crypto prices?

Google Sheets has no built-in crypto function, but a free add-on like CryptoTrackPro adds one. After installing, =cryptotrackpro("BTC-USD") returns the live Bitcoin price in USD — no API key or code required.

Google Sheets is brilliant for tracking money — except it has no idea what Bitcoin costs. There's no built-in =CRYPTO() function, and the usual workarounds (IMPORTDATA from an exchange, a raw API call, a pasted CSV) break constantly, need API keys, or stop refreshing. This guide shows the simple way that just works.

The one-formula method

Install the free CryptoTrackPro add-on, then type this into any cell:

=cryptotrackpro("BTC-USD")

That's the live Bitcoin price in US dollars, updating whenever you refresh. Swap the pair for any coin and any currency:

=cryptotrackpro("ETH-EUR") — Ethereum in euros
=cryptotrackpro("SOL-GBP") — Solana in British pounds
=cryptotrackpro("DOGE-USD") — Dogecoin in dollars
=cryptotrackpro("BTC-ETH") — a crypto-to-crypto cross rate

1,000+ coins and 150+ quote currencies are supported. No API key is ever required — the add-on sources the data for you.

Step by step

Install CryptoTrackPro from the Google Workspace Marketplace — it's free and takes about 20 seconds.
Open any Google Sheet and accept the permission prompt (tick every box so formulas can fetch data).
Type =cryptotrackpro("BTC-USD") in a cell and press Enter.
Refresh anytime from the sidebar's "Refresh All Prices" button, or turn on Auto-Refresh to keep prices current while you work.

Link a price to a cell

Most people keep a column of ticker symbols and reference it, so one formula covers a whole watchlist. If A2 contains BTC:

=cryptotrackpro(A2 & "-USD")

Drag it down and every row prices itself. Multiply by a holdings column and you have a live portfolio value.

Beyond live prices

The same add-on covers the rest of what a crypto spreadsheet needs:

Historical prices — =cryptotrackproPrice("BTC","2021-04-14") returns the closing price on any past date (great for tax and cost basis).
Market data — 24-hour change, market cap, volume and rank via =cryptotrackproData().
Technical indicators — RSI, MACD and OHLCV history for traders who live in Sheets.

Try it in your own sheet

Free plan includes 50 lookups a day. No credit card, no API key.

Install CryptoTrackPro free

Frequently asked questions

Can Google Sheets pull live crypto prices?

Not on its own — there's no native crypto function. A free add-on adds one. After installing CryptoTrackPro, =cryptotrackpro("BTC-USD") returns the live price.

Do I need an API key?

No. The add-on sources all data for you — you never register for or paste an exchange API key.

Is it free?

Yes — 50 lookups per day on the free plan. Base and Pro raise or remove the limit and add auto-refresh and indicators.

Which coins and currencies are supported?

Over 1,000 cryptocurrencies and 150+ quote currencies, including USD, EUR, GBP, JPY and crypto-to-crypto pairs.

Next: calculate crypto tax and cost basis in Google Sheets →

How to get live crypto prices in Google Sheets