<p>Blockchain.info has a list of API endpoints to make it easy to collect data. </p>

<p><a href="https://blockchain.info/api" rel="nofollow">blockchain.info/api</a></p>

<p>Depending on which data set you want, you can typically add <code>?format=csv</code> to the end of the query to get results in csv format, or <code>?format=json</code> if you'd prefer JSON. Once you have the data in a .csv file, you can simply <a href="https://support.office.com/en-za/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba" rel="nofollow">open the file in Excel</a>, which has native support for .csv files.</p>

CC BY-SA 3.0
2015-04-27T13:48:26.350Z
2015-04-27T13:48:26.350Z
JohnDvorak
<p>The .csv format is 'comma separated variables', and is easily imported into Excel.</p>

<p>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.</p>

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

CC BY-SA 3.0
2015-04-27T16:06:19.703Z
2015-04-27T16:06:19.703Z
organofcorti
<p>can anyone explain how to transfer data from Blockchain.info to Excel. I am not familiar with the CSV format.  Thank you in advance!</p>

CC BY-SA 3.0
2015-04-27T13:43:25.753Z
What sort of data are you trying to get from Blockchain.info?
JohnDvorak
<blockchain.info>
How to import data from Blockchain.info to Excel
John
# How to import data from Blockchain.info to Excel

(Asked by: username_0 on 2015-04-27)

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

**Tags:** blockchain.info

> **Comments:**
> **username_1**: What sort of data are you trying to get from Blockchain.info?  

---

## 2 answers

### Answer by username_1 on 2015-04-27. Score: 1

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

[blockchain.info/api](https://blockchain.info/api)

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](https://support.office.com/en-za/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba), which has native support for .csv files.


---

### Answer by username_2 on 2015-04-27. Score: 0

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.


---

