can anyone explain how to transfer data from Blockchain.info to Excel. I am not familiar with the CSV format. Thank you in advance!

  • What sort of data are you trying to get from Blockchain.info?
    – JohnDvorak
    Apr 27, 2015 at 13:43

2 Answers 2


Blockchain.info has a list of API endpoints to make it easy to collect data.


Depending on which data set you want, you can typically add ?format=csv to the end of the query to get results in csv format, or ?format=json if you'd prefer JSON. Once you have the data in a .csv file, you can simply open the file in Excel, which has native support for .csv files.


The .csv format is 'comma separated variables', and is easily imported into Excel.

However, most of the blockchain data available will be a list with varying numbers of fields. This does not lend itself to a .csv file, so they're only available as .json files. These are not easily converted to simple m*n table that Excel will like.

Summary: whether you'll be able to do what you want to do depends on which data you want.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.