<p>It sounds like you are asking how to build a block explorer. Basically you would activate the full transaction index by adding <code>txindex=1</code> to your bitcoin.conf. Parse all the history data and dump it into a database. Then keep track of all the new transaction data on your own database as blocks come in with <code>blocknotify</code> or real-time with ZMQ notifications.</p>

<p><a href="https://github.com/bitcoin/bitcoin/blob/master/doc/zmq.md#usage" rel="nofollow noreferrer">https://github.com/bitcoin/bitcoin/blob/master/doc/zmq.md#usage</a></p>

<p>There's also options like bitpay's bitcore that pretty much does the work for you. It does require a lot more HD space though. </p>

CC BY-SA 3.0
2017-04-16T05:36:56.040Z
2017-04-16T05:36:56.040Z
m1xolyd1an
<p>My understanding of your question is that you want a tool that parses/queries the blockchain and saves the results into an Excel file. I'm not sure that something like that exists, but if you're willing to experiment with code then there are options.</p>

<ul>
<li><a href="https://github.com/bitcoin-abe/bitcoin-abe" rel="nofollow noreferrer">Abe</a> is a block browser for Bitcoin &amp; similar currencies. Written in Python.</li>
<li><a href="https://bitcoinjs.org/" rel="nofollow noreferrer">BitcoinJS</a> is a javaScript library for the Bitcoin blockchain.</li>
<li><a href="https://github.com/dcousens/fast-dat-parser" rel="nofollow noreferrer">fast-dat-parser</a> a blockchain parser written in C++.</li>
</ul>

<p>Each of these libraries is capable of reading the blockchain, and the languages have other libraries for saving data to Excel, CSV, in a database, etc.</p>

CC BY-SA 3.0
2017-06-15T09:55:33.630Z
2017-06-15T09:55:33.630Z
Lenwood
<p>Checkout this API:
<a href="https://blockchain.info/api" rel="nofollow noreferrer">https://blockchain.info/api</a></p>

<p>Specifically look at "Transactions &amp; Blocks Data" &amp; "Market Data".</p>

<p>With PHP you can use that API and work with the data. PHP also allows you to create and export to Excel sheets: <a href="http://www.the-art-of-web.com/php/dataexport/" rel="nofollow noreferrer">http://www.the-art-of-web.com/php/dataexport/</a></p>

<p>For me, because I know PHP, this would be the easiest route to go.</p>

CC BY-SA 3.0
2017-04-23T08:48:31.430Z
OP is asking how to read data from the blockchain that his Bitcoin Core instance downloaded, not how to use a 3rd party API.
Pieter Wuille
CC BY-SA 3.0
2017-06-09T22:43:42.980Z
I was just telling him how I would do it as the last line of my answer says. Any bit of information helps that is relevant. Maybe if he knew PHP he would find it easier to do the route I recommended. But I do see your perspective.
Marc Alexander
CC BY-SA 3.0
2017-04-15T23:00:50.963Z
2017-04-15T23:00:50.963Z
Marc Alexander
<p>I installed Bitcoin-Core Wallet and downloaded the whole 130gigs BlockChain. Now I'd like to read the BlockChain Data to know all bitcoin values since the beginning. Not sure how to start. I need that data for making my own graphs in Excel</p>

<p>How can I read data from the whole BlockChain? Thanks.</p>

CC BY-SA 3.0
2017-04-15T22:57:43.693Z
What do you mean by bitcoin values?
Pieter Wuille
<blockchain><bitcoind><historical-trade-data>
How to get Bitcoin historical data from Bitcoin-Core?
Fred Cailloux
# How to get Bitcoin historical data from Bitcoin-Core?

(Asked by: username_0 on 2017-04-15)

I installed Bitcoin-Core Wallet and downloaded the whole 130gigs BlockChain. Now I'd like to read the BlockChain Data to know all bitcoin values since the beginning. Not sure how to start. I need that data for making my own graphs in Excel

How can I read data from the whole BlockChain? Thanks.

**Tags:** blockchain, bitcoind, historical-trade-data

> **Comments:**
> **username_1**: What do you mean by bitcoin values?  

---

## 3 answers

### Answer by username_2 on 2017-04-16. Score: 4

It sounds like you are asking how to build a block explorer. Basically you would activate the full transaction index by adding `txindex=1` to your bitcoin.conf. Parse all the history data and dump it into a database. Then keep track of all the new transaction data on your own database as blocks come in with `blocknotify` or real-time with ZMQ notifications.

<https://github.com/bitcoin/bitcoin/blob/master/doc/zmq.md#usage>

There's also options like bitpay's bitcore that pretty much does the work for you. It does require a lot more HD space though.


---

### Answer by username_3 on 2017-06-15. Score: 2

My understanding of your question is that you want a tool that parses/queries the blockchain and saves the results into an Excel file. I'm not sure that something like that exists, but if you're willing to experiment with code then there are options.

* [Abe](https://github.com/bitcoin-abe/bitcoin-abe) is a block browser for Bitcoin & similar currencies. Written in Python.
* [BitcoinJS](https://bitcoinjs.org/) is a javaScript library for the Bitcoin blockchain.
* [fast-dat-parser](https://github.com/dcousens/fast-dat-parser) a blockchain parser written in C++.

Each of these libraries is capable of reading the blockchain, and the languages have other libraries for saving data to Excel, CSV, in a database, etc.


---

### Answer by username_4 on 2017-04-15. Score: -1

Checkout this API:
<https://blockchain.info/api>

Specifically look at "Transactions & Blocks Data" & "Market Data".

With PHP you can use that API and work with the data. PHP also allows you to create and export to Excel sheets: <http://www.the-art-of-web.com/php/dataexport/>

For me, because I know PHP, this would be the easiest route to go.

> **Comments:**
> **username_1**: OP is asking how to read data from the blockchain that his Bitcoin Core instance downloaded, not how to use a 3rd party API.  
> **username_4**: I was just telling him how I would do it as the last line of my answer says. Any bit of information helps that is relevant. Maybe if he knew PHP he would find it easier to do the route I recommended. But I do see your perspective.  

---

