Google Sheets Crypto Prices

The easiest way to pull crypto currency prices into your Google Sheets spreadsheet.

A simple IMPORTDATA function call that requires no parsing and no limitations.

The =IMPORTDATA function

The IMPORTDATA function is what allows you to get arbitrary data from the internet, with a single argument, the source URL, Google Sheets will pull the contents and update the row. Given that cryptoprices.cc is returning plain text, it requires no additional parsing from your side.

See Google documentation on =IMPORTDATA.

How to get BITCOIN (BTC) price in Google Sheets

How to get Bitcoin price in Google Sheets

=IMPORTDATA("https://cryptoprices.cc/BTC/")

How to get Bitcoin ATH price in Google Sheets

=IMPORTDATA("https://cryptoprices.cc/BTC/ATH/") (Append /ATH/ to any URL)

How to convert Bitcoin price to your local currency (example with GBP)

=IMPORTDATA("https://cryptoprices.cc/BTC/")*GOOGLEFINANCE("CURRENCY:USDGBP")

Demo / PoC Spreadsheet

You can see an example spreadsheet on my Medium blog post.

About Google Sheets

Google Sheets is a spreadsheet program that is included as part of the free, web-based Google Docs Editors suite offered by Google. It allows users to create and edit spreadsheets online, in real time, with others who are also working on the same document. Google Sheets has many of the same features as Microsoft Excel, but it is also able to connect to other web-based applications and services. This makes it a very versatile tool for businesses and individuals alike.


List of all tokens/pairs available.