The blocks are stored in something called LevelDB, which is already a very capable database format. While you wouldn't have any fun opening it up in Excel (it's 10GB afteral), you can use a python application named Abe to throw it all into a Postgres/MySQL database if you really insist. I would personally advise against it though.
https://github.com/jtobey/bitcoin-abe
Topic: Open the Blockchain in a Database (Read 482 times)
Shoot I do too. Why did I think those were plaintext? Somebody who knows better will have to help.
I just get a bunch of scrambled characters.
Correct me if I'm wrong, but isn't the blockchain stored as plaintext? Can't you just view it by concatenating all the blockXX.dat files in the "~/.bitcoin/blocks" folder and just view them with a text viewer?
I want the whole blockchain. It would take years viewing 1 block at a time.
can you just use blockchain.info to get the information you need
Can anyone tell me how to open the blockchain using a database program such as Access? I apparently have the blockchain since I have bitcoin installed but I can not view it in anything but the native program. I tried importing the dat files but couldn't.
Jump to: