Tracking cryptocurrency prices efficiently is essential for investors, analysts, and finance enthusiasts. While Google Sheets has become a go-to tool for managing personal and professional financial data, pulling real-time crypto prices isn’t always straightforward—especially when dealing with lesser-known digital assets. This guide walks you through reliable methods to fetch cryptocurrency prices in Google Sheets, including workarounds for coins not supported by built-in functions.
Whether you're monitoring Bitcoin, Ethereum, or emerging tokens like Polygon and Chainlink, this article provides actionable solutions that combine simplicity with accuracy. We'll explore native functions, external data sources, and formatting fixes to ensure your spreadsheets stay accurate—no matter your regional settings.
Using Google Finance for Major Cryptocurrencies
Google Sheets' GOOGLEFINANCE() function is a powerful, widely-used tool for retrieving real-time financial data. Fortunately, it supports major cryptocurrencies such as Bitcoin (BTC), Ethereum (ETH), and Cardano (ADA) when quoted against fiat currencies like USD or BRL.
To get started, simply use the formula:
=GOOGLEFINANCE("BTCUSD")This returns the current price of Bitcoin in US dollars. Similarly:
=GOOGLEFINANCE("ETHBRL") // Ethereum price in Brazilian Real
=GOOGLEFINANCE("ADAEUR") // Cardano price in Euros👉 Discover how to automate financial tracking with smart tools and real-time data integration.
The syntax follows a clear pattern: concatenate the cryptocurrency ticker with the target fiat currency code (based on ISO 4217 standards). This method is secure, reliable, and updates automatically within minutes.
However, Google Finance does not support many mid-tier or emerging cryptocurrencies, such as Polygon (MATIC) or Chainlink (LINK). If you're tracking a broader portfolio, you'll need an alternative solution.
Workaround: Importing Data from Crypto Prices
For unsupported coins, a practical workaround involves using external services that provide machine-readable price data. One of the most effective options is Crypto Prices, a lightweight service that delivers clean, up-to-date cryptocurrency pricing in plain text—perfect for integration into Google Sheets.
Crypto Prices acts as a simplified front-end for the CoinGecko API but uses familiar ticker symbols (e.g., MATIC instead of “polygon”) and returns only price data in USD—ideal for spreadsheet use.
To fetch the price of a coin like Solana (SOL) or Chainlink (LINK), use the IMPORTDATA() function:
=IMPORTDATA("https://cryptoprices.cc/MATIC/")
=IMPORTDATA("https://cryptoprices.cc/LINK/")These formulas pull the current USD value directly into your cell. No authentication, no scripting—just instant access.
Handling Regional Formatting Issues
A common issue arises when using IMPORTDATA() in non-US locales: decimal separator mismatches. For example, users in countries using commas as decimal separators (like Brazil or Germany) may see 801457 instead of 0.801457, leading to significant calculation errors.
Why? Because the data comes in en_US format (with periods as decimal points), but your sheet interprets it based on local settings.
The fix is simple: specify the locale explicitly in the IMPORTDATA() function:
=IMPORTDATA("https://cryptoprices.cc/MATIC/";;"en_US")
=IMPORTDATA("https://cryptoprices.cc/SOL/";;"en_US")Note the two semicolons—this syntax allows you to pass "en_US" as the third parameter, forcing Google Sheets to interpret the incoming number correctly, regardless of your spreadsheet’s regional settings.
Converting Prices to Your Local Currency
Since Crypto Prices only provides values in US Dollars (USD), you’ll likely want to convert them into your local currency—such as Brazilian Real (BRL), Japanese Yen (JPY), or Euro (EUR).
You can achieve this by combining IMPORTDATA() with GOOGLEFINANCE() for currency conversion:
=IMPORTDATA("https://cryptoprices.cc/LINK/";;"en_US") * GOOGLEFINANCE("USDBRL")This formula:
- Fetches the Chainlink price in USD.
- Multiplies it by the current USD-to-BRL exchange rate.
- Outputs the result in Brazilian Reais—perfectly aligned with your local financial context.
Similarly:
=IMPORTDATA("https://cryptoprices.cc/DOGE/";;"en_US") * GOOGLEFINANCE("USDJPY") // DOGE in JPYThis hybrid approach gives you full flexibility without requiring complex scripts or third-party add-ons.
👉 Learn how real-time data enhances decision-making in dynamic financial environments.
Frequently Asked Questions (FAQ)
Q: Can I use GOOGLEFINANCE() for all cryptocurrencies?
A: No. GOOGLEFINANCE() supports only major cryptocurrencies like Bitcoin and Ethereum. Coins like Polygon, Chainlink, or Solana are not included.
Q: Why does IMPORTDATA() return incorrect numbers in some regions?
A: It’s due to decimal formatting differences. Data from Crypto Prices uses US number formatting (periods for decimals). If your sheet uses commas, it misreads the value. Always set the locale to "en_US" as the third parameter.
Q: Is Crypto Prices reliable and up-to-date?
A: Yes. It pulls data from CoinGecko’s API, which updates prices every few seconds. It’s trustworthy for real-time tracking.
Q: Can I import multiple coins at once?
A: Yes. Use separate IMPORTDATA() calls in different cells for each coin. You can then reference these cells in calculations across your sheet.
Q: Do I need coding skills to implement this?
A: No. All methods use built-in Google Sheets functions—no scripting or API keys required.
Q: Can I change the output currency other than USD?
A: Not directly through Crypto Prices. However, you can multiply the result by any USD-to-fiat exchange rate using GOOGLEFINANCE() to convert to your desired currency.
Final Tips for Effective Crypto Tracking
- Use named ranges for imported prices to make formulas cleaner.
- Cache results if you’re concerned about API limits or speed—copy values periodically to static cells.
- Combine with conditional formatting to highlight price movements (e.g., red/green based on change).
- Automate updates using Google Apps Script if you need more control over refresh intervals.
With these techniques, you can build a powerful, self-updating crypto dashboard entirely within Google Sheets—no downloads, no subscriptions, and no extra tools needed.
👉 Explore seamless ways to integrate live financial data into your daily workflow.
By leveraging GOOGLEFINANCE() and IMPORTDATA() strategically, you gain access to real-time pricing for both mainstream and niche cryptocurrencies. Whether you're building a personal tracker or a professional report, these methods ensure accuracy, scalability, and ease of use across global markets.
Start building your crypto price tracker today—and keep your financial insights just a spreadsheet away.