In this article:

Add Real-Time Crypto Prices to Google Sheets (2024 Update)

May 8, 2024

In this article we will show how to add real time crypto prices to google sheets with the GOOGLEFINANCE function. Simply follow the steps below.

Add Crypto Prices to Google Sheets Using GOOGLEFINANCE Function


The GOOGLEFINANCE function uses the following syntax for crypto prices:



Ticker is the symbol for the crypto in google finance that you want to import into your sheet. It should be enclosed in double quotes. 

GOOGLEFINANCE can import the current prices for a given crypto. Here are the steps:

1. Identify The Crypto to Import

What we need to identify is the crypto and its corresponding ticker in Google Finance. For example, we want to import Bitcoin prices. Go to and then search for Bitcoin. We will be able to reach the following page:

Import real time crypto prices google finance, check page for crypto coin ticker

The URL to this page is

What we need is the code after the /quote/ portion. It is BTC-USD. This is the ticker we need to import Bitcoin prices to our Google Sheets 

2. Use Formula =GOOGLEFINANCE(ticker)

Using the syntax =GOOGLEFINANCE(ticker), the formula becomes


Where the ticker is enclosed in double quotes. Just type the formula where you want to insert the Bitcoin price. 

How to import real time crypto price, using googlefinance function

3. Press Enter

The cell will initially show “Loading”, and then the current price will appear.

Imported real time crypto price via googlefinance function

You have now imported crypto prices via GOOGLEFINANCE!


How to Set GOOGLEFINANCE to Import Latest Price Every Minute?

You can do so by setting Google Sheets to automatically recalculate every minute. Click File, then select Settings.

Automate import real time crypto price google finance, click file, select settings

A box labeled Settings for this spreadsheet appears. Click the Calculation tab, then click the drop-down box under the label Recalculation. Select On change and every minute

Automate import real time crypto price google finance, click calculation tab, select on change and every minute

Click Save settings. The sheet should recalculate every minute. 

If you enjoyed this article, you might also like our article on how to split text to rows in Google Sheets or our article on how to manually add API CoinMarketCap to Google Sheets. 

If you want to learn how to send emails based on dates in Google Sheets, we also suggest checking out our detailed guide. 

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->