How to Get Bitcoin and other Cryptocurrency Real-Time Prices in Excel

If you hold crypto-currencies like BitCoin, LiteCoin, Ethereum and would like to track the value in real-time on an Excel spreadsheet then this is the easiest way to do so!

If you want to get started with Bitcoin you can open an account at CoinBase.

I have created a spreadsheet with an embedded plugin designed to update Bitcoin and other currencies automatically and populated it with some data to spur your imagination.

Step1 –  Download this zip file which contains and Excel 2016 spreadsheet:

Crypto Bitcoin Holdings Value v2 (Real Time Crypto Currency Excel is now available. (See the bottom of this post.)

Step 2 – Extract the Excel Spreadsheet “Crypto Bitcoin Holdings Value” and save it to your PC

Step 3 – Save the zip file that is embedded in the spreadsheet to your PC, or double click on the zip that is embedded and extract the file that way. Your Choice.




Step 4 – Close Excel, and Extract the plug-in from the file, save it to your PC

Step 5- Run the plug-in. After installing it Excel will have a new tab called “Crypto Excel”





Now you are set up and ready to modify the spreadsheet however you like to fit your unique scenario. When you open the spreadsheet you’ll see that I have pre-populated 3 Cryptocurrencies; BitCoin, LiteCoin and Ethereum with a theoretical situation.  The logic behind the layout is:

  • Master OverView – Current state of your currencies. Some may be waiting to be funded, you may have multiple wallets – adjust to your situation.
  • Available Funds – Money readily available for purchases or trade, probably sitting on an exchange.
  • Hard Wallet – Money in a hard wallet like Trezor or in a paper wallet. Offline and secure from breaches.

You’ll notice that there are several #N/A fields wherever a coin price should be – go to the CryptoExcel tab and click CONNECT.





Ta-Da! Real-time bitcoin prices in an Excel spreadsheet!

You can add other currencies listed on the CURRENCIES tab using the formula =CC_RATE(“LTC”, “Coinbase”) – just replace LTC with the symbol of the currency you want to track!

Also take a look at the yellow highlighted fields – change to fit your numbers.

Happy Cryptoing!
Donate BTC to me? Sure you can! Thanks for asking! 115vhqSUbHrxAEiF65SuZzCUSQBtknqEAi

Dec 20th Update:
Wow! What a few weeks – here is the ROUGH v2 seeing that BCH has shown up on exchanges and people were asking me for other crypto coins as well. Enjoy – and I look forward to your continued suggestions / commentsDownload Current Version (2.0) Here

Categories Uncategorized

Tags BCH Bitcoin Bitcoin Cash BTC Crypto ETH Ethereum Excel LiteCoin LTC

You must log in to post a comment


  • I have installed & unzipped the Excel program. I ran CryptoExcelAddin and it says it ran successfully but I do not see a Crypto Excel tab on the Excel spread sheet. Any suggestions on what I should test or do over?

    Thank you.

    • I have it working with the latest version of Excel here in 2021….. Try again? Check Add-Ins? Should be pretty straight forward as outlined above.
      Goog Luck!

  • Hi not in file Real Time Crypto Currency Excel

  • When I unzipped it only opens an excel sheet without showing me any add in to install or did I get it wrong?

    • Double click on the image of the zip file in the spreadsheet and it will extract that file, then follow the directions above. Enjoy!


Password Reset

An email has been set with password reset instructions. If you do not see this email within a few minutes, check your spam folder.

Not Allowed

Your current user level does not allow voting. Please contact the site administrator to upgrade.


Submit a New Post!

Please login first