Tracking cryptocurrency prices in real time doesn’t have to be complicated. With the right tools, you can build a dynamic, self-updating dashboard using Google Sheets—no coding required. Whether you're monitoring Bitcoin, Ethereum, or altcoins, integrating live crypto data into your spreadsheets is fast, free, and surprisingly powerful.
This guide walks you through how to pull live crypto prices, historical all-time highs (ATH), and even convert values into your local currency—using nothing more than built-in Google Sheets functions.
How to Import Live Crypto Prices Using =IMPORTDATA
The key function for pulling cryptocurrency price data into Google Sheets is =IMPORTDATA. This built-in formula fetches data from a public URL and imports it directly into your spreadsheet.
Syntax:
=IMPORTDATA("URL")All you need is a web endpoint that returns plain text or CSV/TSV data—and that’s exactly what services like cryptoprices.cc provide.
👉 Discover how to automate crypto price tracking effortlessly.
Get the Current Bitcoin Price
To retrieve the live Bitcoin price in USD:
=IMPORTDATA("https://cryptoprices.cc/BTC/")Once entered, this formula will return the current BTC/USD price in the cell. Google Sheets automatically refreshes imported data periodically (typically every 30–60 minutes), so your sheet stays up to date without manual intervention.
Fetch All-Time High (ATH) Price for Any Cryptocurrency
Want to compare today’s price against an asset’s peak performance? Simply append /ATH/ to the ticker symbol in the URL.
For Bitcoin’s all-time high:
=IMPORTDATA("https://cryptoprices.cc/BTC/ATH/")You can replace BTC with any supported cryptocurrency ticker (e.g., ETH, SOL, ADA) to get their respective ATH prices.
This feature is especially useful for tracking recovery percentages or analyzing market cycles.
Convert Crypto Prices to Your Local Currency
Cryptoprices.cc returns values in USD by default. But if you’re based outside the U.S., you’ll likely want prices in your local currency—like EUR, GBP, JPY, or CAD.
Google Sheets includes the GOOGLEFINANCE function to pull live exchange rates between fiat currencies.
Example: Convert Bitcoin Price to British Pounds (GBP)
=IMPORTDATA("https://cryptoprices.cc/BTC/") * GOOGLEFINANCE("CURRENCY:USDGBP")This formula:
- Pulls the current BTC price in USD.
- Multiplies it by the live USD-to-GBP exchange rate.
You can adapt this for other currencies:
- Euro (EUR):
GOOGLEFINANCE("CURRENCY:USDEUR") - Japanese Yen (JPY):
GOOGLEFINANCE("CURRENCY:USDJPY") - Canadian Dollar (CAD):
GOOGLEFINANCE("CURRENCY:USDCAD")
Now your crypto tracker speaks your financial language.
Supported Cryptocurrencies and Trading Pairs
The service at cryptoprices.cc supports a wide range of digital assets. You can view the full list of available tokens and pairs via:
https://cryptoprices.cc/sitemap.txt
Commonly supported assets include:
- Bitcoin (BTC)
- Ethereum (ETH)
- Binance Coin (BNB)
- Solana (SOL)
- Cardano (ADA)
- Dogecoin (DOGE)
- Polkadot (DOT)
- Chainlink (LINK)
Each can be accessed using the same pattern:
=IMPORTDATA("https://cryptoprices.cc/[TICKER]/")Replace [TICKER] with the symbol of your choice.
Why Use Google Sheets for Crypto Tracking?
Google Sheets isn’t just for budgets and invoices. It’s a robust platform for personal finance automation—especially when combined with real-time web data.
Key Advantages:
- Free and accessible: No cost, works on any device with a browser.
- Real-time collaboration: Share your portfolio tracker with family or teammates.
- Automated updates: Data refreshes on Google’s schedule—no manual input needed.
- Integration-ready: Works with Google Apps Script, APIs, and external financial tools.
- Customizable dashboards: Add charts, conditional formatting, alerts, and more.
Compared to standalone apps or complex dashboards, Google Sheets offers simplicity with surprising depth.
Build Your Own Crypto Portfolio Tracker
Imagine a spreadsheet that shows:
- Live prices for all your holdings
- Total portfolio value in your local currency
- Gain/loss calculations based on purchase price
- Percentage allocation per asset
All of this is possible using combinations of:
=IMPORTDATA()→ for crypto prices=GOOGLEFINANCE()→ for fiat conversions- Simple arithmetic and cell references
👉 Start building your real-time crypto dashboard now.
Frequently Asked Questions (FAQ)
Q: How often does Google Sheets update imported crypto data?
A: The =IMPORTDATA function typically refreshes every 30 to 60 minutes. Exact timing depends on Google’s internal scheduling and usage patterns. For faster updates, consider using Apps Script with time-driven triggers.
Q: Can I import multiple cryptocurrencies at once?
A: Yes! Just use the =IMPORTDATA function in multiple cells, each pointing to a different cryptocurrency URL. For example: =IMPORTDATA("https://cryptoprices.cc/ETH/") in one cell, =IMPORTDATA("https://cryptoprices.cc/SOL/") in another.
Q: What happens if the URL returns an error?
A: If the cell shows #N/A, #VALUE!, or similar errors, check that:
- The URL is correct and accessible.
- The ticker symbol is supported.
- The service (
cryptoprices.cc) is online.
You can wrap formulas inIFERROR()for cleaner display:=IFERROR(IMPORTDATA("https://cryptoprices.cc/BTC/"), "Loading...")
Q: Is cryptoprices.cc safe and reliable?
A: While it provides useful plain-text price feeds, it's a third-party service not affiliated with Google or major exchanges. Always cross-check critical data and avoid relying solely on any single source for trading decisions.
Q: Can I track prices from specific exchanges?
A: The cryptoprices.cc endpoint aggregates prices generally and doesn’t specify exchange sources. For exchange-specific data (e.g., Binance or OKX), you’d need to use their official APIs—some of which can also be integrated into Sheets via IMPORTDATA or Apps Script.
Q: Can I set up price alerts in Google Sheets?
A: Not natively—but yes with automation. Use Google Apps Script to run daily checks and send email notifications when a price crosses a threshold. This turns your sheet into an alert system.
Final Tips for Success
- Label your cells clearly: Use adjacent columns for asset name, quantity, entry price, current price, and profit/loss.
- Use named ranges and formatting to make your sheet easy to read.
- Combine with other tools: Link your sheet to mobile apps via integrations like IFTTT or Make (formerly Integromat).
- Backup regularly: While Google auto-saves, duplicate important sheets as a safety measure.
Whether you're a casual investor or managing a diversified portfolio, leveraging Google Sheets gives you full control—with zero cost.
👉 Maximize your crypto insights with powerful tracking tools.
By combining simple functions like =IMPORTDATA and =GOOGLEFINANCE, you unlock a world of automated financial tracking. And once you’ve mastered crypto prices, the same principles apply to stocks, forex, NFT floor prices, and more.
Start small. Build smart. Track everything.