BLOG
/
Crypto Taxes
checkCircle
Expert verified
4 min read

How to Download Cryptocurrency Data to Excel

How to Download Cryptocurrency Data to Excel
How to Download Cryptocurrency Data to Excel
info
Our Editorial Standards:
Our content is designed to educate the 500,000+ crypto investors who use the CoinLedger platform. Though our articles are for informational purposes only, they are written in accordance with the latest guidelines from tax agencies around the world and reviewed by certified tax professionals before publication. Learn More
on this page
close

In this guide, we’ll break down how you can download cryptocurrency pricing and transaction history data to an Excel spreadsheet. The process allows you to generate a csv file that contains data about your cryptocurrency transactions across all your wallets and exchanges in minutes. 

Can I pull cryptocurrency prices into Excel? 

If you have a Microsoft 365 subscription, you can use Excel’s stocks functionality to pull in cryptocurrency prices. 

Currently, Excel supports the following cryptocurrencies. 

  • Bitcoin (BTC)
  • Bitcoin Cash (BCH)
  • Litecoin (LTC)
  • Ripple (XRP)
  • Ethereum (ETH) 

Excel allows you to see the price of cryptocurrency in the fiat currency of your choice —  USD, EUR, CAD, and more! 

For example, if you want to see the price of BTC in USD, you can enter BTC/USD into a cell. Microsoft Excel will see this as a valid input and pull the relevant price. 

In addition, Excel can help you pull the historical prices of cryptocurrencies! The STOCKHISTORY function can help you show the price of your crypto at daily, monthly, and weekly intervals. 

Still, it’s important to remember that Excel has limitations when it comes to cryptocurrency. The platform does not support many different types of cryptocurrencies and cannot import your transactions from your wallets and exchanges. 

Does Excel support cryptocurrency exchanges and wallets? 

Unfortunately, Excel does not allow you to automatically import your transactions from exchanges like Coinbase or blockchains like Ethereum. This can make it difficult to keep a record of your cryptocurrency transactions — including the price of your crypto at receipt and disposal and the date and time you received and disposed of your coins. 

Luckily, there’s an easier way to track your transactions. Third-party tools like CoinLedger can help you automatically import your trades and download your cryptocurrency data on an Excel spreadsheet. 

Where can I download cryptocurrency data? 

With CoinLedger, you can download a csv file for Excel containing data from all of your cryptocurrency transactions. Let’s walk through the process. 

  1. Connect your wallets and exchanges to CoinLedger. 
  2. Let the platform import your transactions automatically. 
  3. Download a csv file containing data about all of your crypto transactions. 

Once you’re done, you’ll have a spreadsheet containing a record of your crypto transaction history — including the price of your crypto at disposal and at receipt! Your csv can be exported to platforms like Microsoft Excel. 

Get started with CoinLedger 

With CoinLedger, it’s never been easier to track your crypto transactions.


More than 500,000 investors around the world use the platform to track their crypto portfolios and report their crypto taxes. 

Get started with a free account today. 

Frequently asked questions

  • MinuPlus
  • MinuPlus
  • MinuPlus
  • MinuPlus
  • MinuPlus
  • MinuPlus
...
Want to try CoinLedger for free? Claim your free preview tax report.

Join 500,000 people instantly calculating their crypto taxes with CoinLedger.

How we reviewed this article

Edited By
Sources

All CoinLedger articles go through a rigorous review process before publication. Learn more about the CoinLedger Editorial Process.

CoinLedger has strict sourcing guidelines for our content. Our content is based on direct interviews with tax experts, guidance from tax agencies, and articles from reputable news outlets.

KNOWLEDGE BASE

Demystify Crypto Taxes

The Ultimate Crypto Tax Guide (2024)

This guide breaks down everything you need to know about cryptocurrency taxes, from the high level tax implications to the actual crypto tax forms you need to fill out.

Crypto taxes overview
howToHandleCryptocurency
Crypto Tax Rates 2024: Complete Breakdown

Here’s how much tax you'll be paying on your income from Bitcoin, Ethereum, and other cryptocurrencies.

Crypto tax rates
howToReportCryyptoLosses
How Crypto Losses Can Reduce Your Taxes

Crypto and bitcoin losses need to be reported on your taxes. However, they can also save you money.

How crypto losses lower your taxes
ellipseellipsecalculator

Calculate Your Crypto Taxes

  • Check
    No credit card needed
  • Check
    Instant tax forms
  • Check
    No obligations
Get Started For Free
percent
ellipseellipse
Jump to
list