Bitcoin Price in Excel 365

Learn how to quickly pull the live bitcoin price in Excel. This same method can be used to import other cryptocurrencies as well.

As of May 2022, the following cryptocurrencies are available in Excel.

  • Bitcoin (BTC)
  • Bitcoin Cash (BCH)
  • Litecoin (LTC)
  • Ripple (XRP)
  • Ethereum (ETH)
Bitcoin Price in Excel
Learn to Create this tracking Sheet

How to pull real-time Bitcoin Price in Excel

Start by creating a new spreadsheet.

In order to display crypto currency pricing in Excel, you must use the Cryptocurrency + Price Currency.

For example, if we want to show the Bitcoin Price in Excel, we would use: BTCUSD

Let’s Get Started

Cryptocurrency in Excel

Learn to pull Bitcoin Price in Excel

Total Time: 2 minutes

Step 1: Create a list of Cryptocurrencies

Cryto Currency List

In this first step, we begin by inputting the cryptocurrency we want to track in Excel. As mentioned above, we need to use the Cryptocurrency + Price Currency. In our example, I’m showing BTC, ETH, and XRP in USD and EUR.

Step 2: Create a Table

Make sure you have a title in Cell A1. I chose “Crypto” since this example is strictly tracking crypto investments.

Highlight column “A1-A6” and go to “Insert” then “Table”

Step 3: Convert to Stocks

Once the table in created, go to “Data” then select “Stocks”

This will automatically convert the information in column A to stock formats.

Step 4: Format Crypto Tracking Results

Format Crypto Tracking

Once the cells are formatted into stocks, Excel will pull in live data. You can add additional columns by selecting the “Add Column” box in the right hand corner.

Step 5: Add Columns to Crypto Tracking

Crypto Add Columns

Here is the list of Columns you can add to your table. Typically, I like to show the 52 Week Low and High. You can also insert a column to show your actual position price and shares.

Step 6: Final Result

Bitcoin Price in Excel

Here is a simple way to track your Crypto investments, especially is you use multiple exchanges. Here at Excelbuddy we use Robinhood as your primary gateway for Cryptocurrency purchases.

For investing strategies, check out our Investing Discourse.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Send this to a friend