Don’t forget to share this post

If you use Google Sheets and need current prices for various cryptocurrencies, the GOOGLEFINANCE function will import them using only the ticker symbol for that cryptocurrency. In minutes, you can have current and historical cryptocurrency data in your Google Sheets. However, a 20-minute delay between updates makes it unsuitable for real-time decisions.

In this article, you will learn how to use the GOOGLEFINANCE function to pull cryptocurrency prices into your Google Sheets. You will also learn about other ways of getting crypto prices from Google Sheets, including other functions in Google Sheets.

Can I use Google Finance for Crypto Prices?

Google Sheets’ GOOGLEFINANCE function can be used to get cryptocurrency prices. Simply type in, between quotation marks, the ticker symbol for the cryptocurrency as the only argument for the function. Alternatively, type the ticker symbol, without quotation marks, into a cell and use the cell reference in the formula.

A list of ticker symbols for most cryptocurrencies - of which there are thousands - is available on GitHub.

How To Import Yahoo Finance Data Into Google Sheets
How To Import Yahoo Finance Data Into Google Sheets

You want to analyze Yahoo Finance data in Google Sheets but are still using copy-paste? Here’s how to import Yahoo Finance data into Google Sheets instead.

READ MORE

How to Get Crypto Prices in Google Sheets with the Google Finance Function?

Follow the steps below to get crypto prices using Sheets’ GOOGLEFINANCE formula.

  1. 1. Open Google Sheets.
Use Google Finance to Get Crypto Prices in Sheets Open Sheets
Use Google Finance to Get Crypto Prices in Sheets - Open Sheets
  1. 2. In an empty cell, type in the ticker symbol for the cryptocurrency you want. In this example, I will get the price for Bitcoin in USD. The ticker symbol is BTCUSD.
Use Google Finance to Get Crypto Prices in Sheets Add Ticker Symbol
Use Google Finance to Get Crypto Prices in Sheets - Add Ticker Symbol
  1. 3. In a separate cell, type in the GOOGLEFINANCE formula. Select the cell with the ticker symbol as the only parameter and close the parenthesis.
Use Google Finance to Get Crypto Prices in Sheets Add Formula
Use Google Finance to Get Crypto Prices in Sheets - Add Formula
  1. 4. Once you press “Enter”, you may see “Loading…” in the cell for a few seconds, and then you’ll see the price for your chosen cryptocurrency.
Use Google Finance to Get Crypto Prices in Sheets Crypto Price Imported
Use Google Finance to Get Crypto Prices in Sheets - Crypto Price Imported
  1. 5. To format as a currency ($), click on the dollar symbol on the toolbar, as shown below.
Use Google Finance to Get Crypto Prices in Sheets Apply Currency Format
Use Google Finance to Get Crypto Prices in Sheets - Apply Currency Format

Other Ways to Get Crypto Prices in Google Sheets

There are multiple methods for getting crypto prices into Google Sheets, including other native functions and add-ons.

Get Crypto Prices with IMPORTXML

Google Sheets’ IMPORTXML function can be used to get crypto prices from many web pages. All you need are the URL and the XPath to the object that represents the price of your chosen cryptocurrency.

There are many ways to get the XPath for a specific object, but using Chrome’s Inspect feature is quick and simple.

For example, CoinMarketCap provides prices for a variety of cryptocurrencies.

Find the XPath

  1. 1. Open the website in Chrome and find the price for the cryptocurrency you want.
Use Google Finance to Get Crypto Prices in Sheets Open Website in Chrome
Use Google Finance to Get Crypto Prices in Sheets - Open Website in Chrome
  1. 2. Select the value and right-click. From the menu, choose “Inspect.”
Use Google Finance to Get Crypto Prices in Sheets Inspect Price
Use Google Finance to Get Crypto Prices in Sheets - Inspect Price
  1. 3. In the Inspect window, the line of code corresponding to the price will be selected. If the highlighted section is not quite right, hover over the lines of code around the selected one until you find one that highlights the price exactly.
Use Google Finance to Get Crypto Prices in Sheets Select Highlighted Code
Use Google Finance to Get Crypto Prices in Sheets - Select Highlighted Code
  1. 4. Right-click on the line of code and select Copy > Copy full XPath.
Use Google Finance to Get Crypto Prices in Sheets Copy Full X Path
Use Google Finance to Get Crypto Prices in Sheets - Copy Full XPath

How to Use GOOGLEFINANCE Function in Google Sheets?

Import current or historical financial market data from Google Finance & monitor real-time. Here's how to use the GOOGLEFINANCE function in Google Sheets

READ MORE
How to Use GOOGLEFINANCE Function in Google Sheets

Use IMPORTXML with URL and XPath

  1. 1. In Google Sheets, type the URL and the XPath into separate cells.
Use Google Finance to Get Crypto Prices in Sheets URL X Path
Use Google Finance to Get Crypto Prices in Sheets - URL & XPath
  1. 2. In another cell, type in the formula and select the cell with the URL as the first parameter.
Use Google Finance to Get Crypto Prices in Sheets Import XML First Parameter
Use Google Finance to Get Crypto Prices in Sheets - ImportXML First Parameter
  1. 3. Select the cell with the XPath as the second parameter and close the parenthesis.
Use Google Finance to Get Crypto Prices in Sheets Import XML Second Parameter
Use Google Finance to Get Crypto Prices in Sheets - ImportXML Second Parameter
  1. 4. Press “Enter” to get the price for your chosen cryptocurrency.
Use Google Finance to Get Crypto Prices in Sheets Price Imported
Use Google Finance to Get Crypto Prices in Sheets - Price Imported

Get Crypto Prices with IMPORTDATA

Google Sheets’ IMPORTDATA function can also be used to get cryptocurrency prices from specific webpages. Even though the function is designed to be used with CSV and TSV files, there is a website that publishes crypto prices in a way that allows us to use this function.

The Cryptoprices.cc website offers a simple API where all the endpoints return text. You just need to use the URL for the cryptocurrency you need. All the URLs are available on the sitemap, which is also a text file. This means you can also use IMPORTDATA to get that list and choose the URL from Sheets.

Use Google Finance to Get Crypto Prices in Sheets Import Data Formula
Use Google Finance to Get Crypto Prices in Sheets - ImportData Formula

Get Crypto Prices with the CRYPTOFINANCE Add-on

Another way of pulling crypto prices into Google Sheets is the CRYPTOFINANCE add-on, which provides a variety of additional features. If you have a paid data plan with Cryptowatch, you can access your account through the CRYPTOFINANCE add-on in Google Sheets. However, even with a free account, you can access all of Cryptowatch’s Public data.

Use Google Finance to Get Crypto Prices in Sheets Crypto Finance Add on
Use Google Finance to Get Crypto Prices in Sheets - CryptoFinance Add-on

How to automate your data on top of Google Sheets?

Layer is an add-on that equips you with the tools to increase efficiency and data quality in your processes on top of Google Sheets. Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds. See how it works.

Using Layer, you can:

  • Share & Collaborate: Automate your data collection and validation through user controls.
  • Automate & Schedule: Schedule recurring data collection and distribution tasks.
  • Integrate & Sync: Connect to your tech stack and sync all your data in one place.
  • Visualize & Report: Generate and share reports with real-time data and actionable decisions.

Limited Time Offer: Install the Layer Google Sheets Add-On today and Get Free Access to all the paid features, so you can start managing, automating, and scaling your processes on top of Google Sheets!

Conclusion

As you have seen, it’s easy to get cryptocurrency prices using Google Sheets’ GOOGLEFINANCE function. Although it’s possible to do it with other Sheets’ functions used to import external data, they are only useful if you have a source that provides crypto prices in the required format.

You now know how to use Google Sheets’ GOOGLEFINANCE function to get cryptocurrency prices. You also know about some other methods you can use to get these prices, like Google Sheets’ IMPORTXML and IMPORTDATA functions, as well as the CRYPTOFINANCE add-on.

To learn more about importing financial data, as well other types of data into Google Sheets, check out these related articles.

Layer google sheets add on offer
Get Started With Layer Today!

Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds.

GET STARTED FOR FREE
Hady ElHady
Hady is Content Lead at Layer.

Hady has a passion for tech, marketing, and spreadsheets. Besides his Computer Science degree, he has vast experience in developing, launching, and scaling content marketing processes at SaaS startups.

Originally published Aug 4 2022, Updated Nov 11 2022