Microsoft Excel Crypto Prices

The easiest way to pull crypto currency prices into your Microsoft Excel spreadsheet.

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

The =WEBSERVICE function

The WEBSERVICE function is what allows you to get arbitrary data from the internet, with a single argument, the source URL, Excel 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 Microsoft Office documentation on =WEBSERVICE.

How to get ETHEREUM (ETH) price in Microsoft Excel
This screenshot was taken from Portuguese version of MS Office, for english use WEBSERVICE, or find your local equivelent.

How to get Bitcoin price in Microsoft Excel

=NUMBERVALUE(WEBSERVICE("https://cryptoprices.cc/BTC/"))

How to get Bitcoin ATH price in Microsoft Excel

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

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

This requires a bit more work using a separate table, please see this Microsoft Office support page

About Microsoft Excel

Microsoft Excel is one of the most popular software programs in the world, and for good reason. It offers a wide range of features that can help you manage your data, including calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel also forms part of the Microsoft Office suite of software, making it an ideal choice for business and personal use.


List of all tokens/pairs available.