Use Google Finance to Get Crypto Prices in Sheets

Tracking cryptocurrency prices efficiently is essential for investors, analysts, and data enthusiasts. Google Sheets offers a powerful, accessible way to pull live and historical crypto price data directly into your spreadsheets—without needing complex tools or coding skills. With built-in functions like GOOGLEFINANCE, IMPORTXML, and IMPORTDATA, you can automate data retrieval and build dynamic dashboards for real-time monitoring.

This guide walks you through using Google Finance to get crypto prices in Sheets, explores alternative methods, and shows how to enhance your financial tracking with minimal effort.

Can You Use Google Finance for Cryptocurrency Prices?

Yes, Google Sheets’ GOOGLEFINANCE function supports cryptocurrency pricing. While traditionally used for stocks and currencies, it now includes major digital assets like Bitcoin, Ethereum, and others—provided you use the correct ticker symbol.

To retrieve a crypto price, simply use the formula:

=GOOGLEFINANCE("BTCUSD")

This returns the current price of Bitcoin in USD. You can replace "BTCUSD" with any supported cryptocurrency pair, such as "ETHUSD" for Ethereum or "ADAUSD" for Cardano.

💡 Tip: Instead of hardcoding symbols, place the ticker in a separate cell (e.g., A1) and reference it:

=GOOGLEFINANCE(A1)

This makes your sheet more flexible and easier to update.

A comprehensive list of supported cryptocurrency ticker symbols is available on GitHub repositories dedicated to crypto identifiers, helping you find the right format quickly.

⚠️ Note: Data from GOOGLEFINANCE has a 20-minute delay, making it unsuitable for high-frequency trading decisions. However, it's ideal for portfolio tracking, long-term analysis, and educational purposes.

👉 Discover how to automate financial data imports with powerful tools.

How to Get Crypto Prices in Google Sheets Using GOOGLEFINANCE

Follow these simple steps to start pulling crypto prices:

Step 1: Open Google Sheets

Create a new or open an existing spreadsheet where you want to display cryptocurrency prices.

Step 2: Enter the Ticker Symbol

In an empty cell (e.g., A1), type the ticker symbol for the cryptocurrency. For Bitcoin in USD, enter:

BTCUSD

Step 3: Insert the GOOGLEFINANCE Formula

In another cell (e.g., B1), enter:

=GOOGLEFINANCE(A1)

Press Enter.

You’ll see “Loading…” briefly, followed by the current market price.

Step 4: Format as Currency

To make the number more readable:

Select the cell with the price.
Click the $ (currency) button in the toolbar.
Choose your preferred currency format (e.g., USD).

Now you have a clean, automatically updated crypto price feed.

🔁 Pro Tip: Combine this with date functions like =GOOGLEFINANCE("BTCUSD", "price", TODAY()-7, TODAY()) to pull historical data over a specific period.

Alternative Methods to Import Crypto Prices into Google Sheets

While GOOGLEFINANCE is convenient, it has limitations in terms of coverage and update frequency. Here are three robust alternatives:

1. Use IMPORTXML to Scrape Crypto Prices from Websites

The IMPORTXML function pulls structured data from web pages using XPath selectors. It works well with sites like CoinMarketCap or CoinGecko.

How to Find the Correct XPath

Open CoinMarketCap in Chrome.
Locate the price of your desired cryptocurrency.
Right-click the price → Inspect.
In the Developer Tools panel, hover over nearby HTML elements until the correct price is highlighted.
Right-click the correct line → Copy → Copy full XPath.

Use IMPORTXML in Sheets

Paste the URL into one cell (e.g., A1):
https://coinmarketcap.com/currencies/bitcoin/
Paste the XPath into another cell (e.g., B1).
In a third cell, enter:
```
=IMPORTXML(A1, B1)
```

The price will appear shortly—if the site allows scraping.

⚠️ Limitation: Some websites block automated access or use JavaScript rendering, which IMPORTXML cannot process.

👉 Automate crypto data workflows with advanced financial platforms.

2. Use IMPORTDATA to Pull CSV-Based Crypto Feeds

IMPORTDATA fetches data from URLs that return CSV or TSV formats.

One reliable source is Cryptoprices.cc, which provides plain-text price endpoints.

Example:

=IMPORTDATA("https://cryptoprices.cc/BTC")

This returns Bitcoin’s price in a simple format. You can also import the full sitemap:

=IMPORTDATA("https://cryptoprices.cc/sitemap.txt")

Then parse URLs directly within Sheets.

✅ Advantages: Fast, lightweight, no formatting issues.
❌ Drawbacks: Limited to supported coins; less reliable during traffic spikes.

3. Use the CRYPTOFINANCE Add-on for Advanced Features

For users needing deeper integration, the CRYPTOFINANCE add-on enhances Google Sheets with dedicated crypto functions.

Features include:

Real-time prices from multiple exchanges.
Support for hundreds of altcoins.
Historical data queries.
Integration with Cryptowatch (free and paid tiers).

Install it via Extensions > Add-ons > Get add-ons in Google Sheets.

Once installed, use formulas like:

=CRYPTOFINANCE("BINANCE:BTCUSDT")

This pulls BTC/USDT prices directly from Binance—ideal for traders monitoring exchange-specific rates.

Frequently Asked Questions (FAQ)

Q: Does GOOGLEFINANCE support all cryptocurrencies?

No. GOOGLEFINANCE only supports major cryptocurrencies like Bitcoin (BTC), Ethereum (ETH), Litecoin (LTC), and some fiat pairs (e.g., BTCUSD, ETHGBP). Smaller altcoins may not be available.

Q: Why does my GOOGLEFINANCE formula show #N/A?

This usually means:

The ticker symbol is incorrect or unsupported.
The service is temporarily down.
There’s a typo in the formula.

Double-check the symbol format and ensure internet connectivity.

Q: How often does GOOGLEFINANCE update crypto prices?

Prices refresh approximately every 20 minutes. This delay prevents real-time trading but suffices for general tracking and reporting.

Q: Can I get historical crypto data with GOOGLEFINANCE?

Yes! Use:

=GOOGLEFINANCE("BTCUSD", "price", "01/01/2023", "01/31/2023", "DAILY")

Replace dates and frequency as needed.

Q: Is IMPORTXML reliable for long-term use?

Not always. If a website changes its HTML structure, your XPath breaks. Monitor regularly or consider API-based solutions for stability.

Q: Are there risks using third-party sites like Cryptoprices.cc?

Yes. These services aren’t officially affiliated with exchanges and may go offline. Always verify data accuracy before making investment decisions.

Final Thoughts

Using Google Finance to get crypto prices in Sheets is a fast, free way to begin tracking digital assets. Whether you're building a personal portfolio tracker or analyzing market trends, leveraging native functions like GOOGLEFINANCE, IMPORTXML, and IMPORTDATA empowers you to automate data collection without writing code.

For greater precision and broader coin coverage, consider enhanced tools like the CRYPTOFINANCE add-on or integrate with trusted exchange APIs.

👉 Access real-time crypto data and trading insights through integrated financial platforms.

By combining these techniques, you can create powerful, self-updating dashboards that keep you informed—saving time and improving decision-making in today’s fast-moving crypto markets.