I wonder how to download bitcoin data to csv files. I would like to get all blocks, transactions in csv files. What is the fastest way to achieve this?
Been there, done that. Trust me unless your searching skill is way better mine then
LoyceV's blockdata will be your best source, alternatively, you can download the "Blockchair Database Dumps" from
blockchair, but if you don't have a script/bot to do that for you, then you will need to manually download 10 years worth of DAILY data, assuming we never had a whole day without finding a block then you are going to download about 3650 files, so I suggest you stick to the former option.
Keep in mind that LoyceV has that data in a .txt file, so for you to convert it to CSV you going to need a workaround, and the
easiest one would be using MS Excel.