How To Import Live Cryptocurrency Prices In Google Sheets

If you’re looking to import live cryptocurrency prices in Google Sheets you’ve come to the right place, there are actually several ways to import cryptocurrency prices within Google Spreadsheets.

However, the easiest way to import crypto prices is by using the Cryptosheets Addon.

The reason we like Cryptosheets is the automatic price updates it does for you and all for Free.

Most importantly, you can easily grab data for both the main cryptocurrency coins, such as BTC, ETH and also alt-coins, without any extra complex programming or web scraping.

Cryptosheets essentially does all the hard work fo you.

So, in this article, we will cover exactly how you can import live cryptocurrency prices in Google Sheets using the Cryptosheets addon. We’ll walk you through downloading the addon all the way to getting your cryptocurrency price.

Free Bonus: Click Here To Get A Free Introduction To Financial Analytics in Spreadsheets and learn the basics of spreadsheets by working with rows, columns, addresses, and ranges.

Affiliate Disclaimer: We sometimes use affiliate links in our content. This won’t cost you anything, but it helps keep our lights on and pays our writing and developer teams. We appreciate your support!

How To Import Live Cryptocurrency Prices In Google Sheets

Step 1: Install Cryptosheets Addon In Google Sheets

Before we can get to the bread and butter of using Cryptosheets functions, we’ll need to first get the Cryptosheets addon/add-in installed into our Google Sheets.

Of course… you’ll need to first have Google Sheets opened (Preferably in an empty spreadsheet).

To get our Cryptosheets addon we can follow these steps:

  1. Click on Extensions
  2. Click on Add-ons
  3. Click on Get add-ons
  4. Search For Cryptosheets in the search bar
  5. Click on Cryptosheets
  6. Click on Install
  7. Click on Continue For permissions
  8. Sign in using your dedicated google sheets account

You can check if you’ve successfully installed cryptosheets by going on Extensions > Add-ons > Manage Addons

2. Create An Account With Cryptosheets

Now that we’ve installed our Addon, we need to do one more step before we can actually use Cryptosheets which is creating and signing into our Cryptosheet Account.

To create a our Cryptosheets account we can follow these steps:

  1. Click on Extensions
  2. Click on Cryptosheets
  3. Click on Launch Sidebar
  4. Click on Signup
  5. Follow the Signup account details

If you’ve followed the steps correctly, the green Signup Button at the sidebar on step 4, should change and indicate which indicates you have properly created an account.

Common Issues

1. Not seeing Launch Sidebar, you’ll need to refresh your browser or maybe restart your browser

2. drive.google.com refused to connect, this normally means you have multiple google accounts signed in, you’ll need to sign out of all your accounts and only have one active google account.

Step 3: Get your live Cryptocurrency prices

Now that you’ve created your account, you can now utilize all the functions that Cryptosheets gives you. There are actually a couple of ways that you can import cryptocurrency prices with Cryptosheets, which we will show you below.

Getting real-time crypto prices that auto-update in Google Sheets

To get real-time cryptocurrency prices that automatically update for you in Google Sheets, we can use the function =cs.exrate().

This function basically pulls real-time prices of cryptocurrency and updates instantly based on the intervals that have been provided.

All you need to do is to specify the cryptocurrency coin, the fiat currency you want it to convert into and the interval time in seconds.

Using cs.exrate() is great for tracking real-time prices to the T, which allows you to build an interactive crypto dashboard without manually refreshing the data.

Syntax:

cs.exrate(Cryptocurrency coin, Quote, Time interval)

Parameters:

  • Cryptocurrency coin: The crypto coin you’re interested in, for example, BTC
  • Quote: The price you want the crypto to be converted into, for example, USD
  • Time Interval: How long you want the refresh to be in seconds, if you put 1, it’ll refresh every 1 second.

To learn more, we recommend reading Cryptosheets manual on cs.exrate.

Below, we have made a simple table to get the live prices of the main cryptocurrency coins.

So in the first argument we had =cs.exrate(BTC,USD,1) which got us the live prices of BTC in USD currency and updated every 1 second.