<p>You can use <a href="https://blockchair.com/bitcoin/blocks" rel="nofollow noreferrer">https://blockchair.com/bitcoin/blocks</a>.
It is limited to 1 million cells for free, but as you only need "Time" and "Height", just:</p>

<ol>
<li>deselect all checkboxes but "Height", and click on "Export" selecting then "csv". Open this file with your spreadsheet app.</li>
<li>deselect "Height" and select only "Time". Export. </li>
<li>Open the file from (2), copy the column, and paste it next to the first column in file from (1).</li>
<li>as the results are both ordered by time, rows coincide and you already have the desired data!</li>
</ol>

CC BY-SA 3.0
2018-03-30T09:43:10.260Z
2018-03-30T09:43:10.260Z
circulosmeos
<p>Using the BigQuery public dataset of <a href="https://bigquery.cloud.google.com/dataset/bigquery-public-data:crypto_bitcoin" rel="nofollow noreferrer">https://bigquery.cloud.google.com/dataset/bigquery-public-data:crypto_bitcoin</a></p>
<pre><code>SELECT
  number,
  timestamp
FROM
  `bigquery-public-data.crypto_bitcoin.blocks`
ORDER BY number ASC
</code></pre>

CC BY-SA 4.0
2020-08-02T13:11:46.730Z
2020-08-02T13:11:46.730Z
Scripter
<p>You can export them from the node using this tool <a href="https://github.com/blockchain-etl/bitcoin-etl" rel="nofollow noreferrer">https://github.com/blockchain-etl/bitcoin-etl</a></p>

<pre><code>&gt; pip install bitcoin-etl
&gt; bitcoinetl export_blocks_and_transactions --start-block 0 --end-block 500000 \
 --provider-uri http://user:pass@localhost:8332 \
 --blocks-output blocks.csv
</code></pre>

CC BY-SA 4.0
2019-01-25T08:30:15.383Z
Assume that this link from a new user contains malware.
Claris
CC BY-SA 4.0
2019-01-25T08:33:13.163Z
Take 5 seconds to open the Github profile and convince yourself it's not a malware.
medvedev1088
CC BY-SA 4.0
2019-01-25T08:34:53.517Z
Better than assuming it is benign. You might be interested in [bitcoin-iterate](https://github.com/rustyrussell/bitcoin-iterate) that's likely many orders of magnitude faster, especially when all of the block files end up in memory.
Claris
CC BY-SA 4.0
2019-01-25T08:40:38.077Z
Thanks! You might be interested in this public dataset https://bigquery.cloud.google.com/dataset/bigquery-public-data:crypto_bitcoin. Will take you a few seconds to export the entire blockchain to text files. Powered by blockchain-etl
medvedev1088
CC BY-SA 4.0
2019-01-25T07:10:59.570Z
2019-01-25T07:10:59.570Z
medvedev1088
<p>i am looking for a .csv file of every block timestamp in bitcoin history with the block height. i can get one day at a time from bitcoin.info but i dont fancy manually copying and pasting over 3000 days worth and cleaning that data up. Does anyone know an efficient way to obtain this? i'll even settle for the daily block count, as long as its back to the genesis block and in .csv format.</p>

<raw-data>
.csv file of every block timestamp in btc history
joaf bresj
# .csv file of every block timestamp in btc history

(Asked by: username_0 on 2018-03-29)

i am looking for a .csv file of every block timestamp in bitcoin history with the block height. i can get one day at a time from bitcoin.info but i dont fancy manually copying and pasting over 3000 days worth and cleaning that data up. Does anyone know an efficient way to obtain this? i'll even settle for the daily block count, as long as its back to the genesis block and in .csv format.

**Tags:** raw-data


---

## 3 answers

### Answer by username_1 on 2018-03-30. Score: 2

You can use <https://blockchair.com/bitcoin/blocks>.
It is limited to 1 million cells for free, but as you only need "Time" and "Height", just:

1. deselect all checkboxes but "Height", and click on "Export" selecting then "csv". Open this file with your spreadsheet app.
2. deselect "Height" and select only "Time". Export.
3. Open the file from (2), copy the column, and paste it next to the first column in file from (1).
4. as the results are both ordered by time, rows coincide and you already have the desired data!


---

### Answer by username_2 on 2020-08-02. Score: 2

Using the BigQuery public dataset of https://bigquery.cloud.google.com/dataset/bigquery-public-data:crypto_bitcoin
SELECT
  number,
  timestamp
FROM
  `bigquery-public-data.crypto_bitcoin.blocks`
ORDER BY number ASC


---

### Answer by username_3 on 2019-01-25. Score: 0

You can export them from the node using this tool https://github.com/blockchain-etl/bitcoin-etl
> pip install bitcoin-etl
> bitcoinetl export_blocks_and_transactions --start-block 0 --end-block 500000 \
 --provider-uri http://user:pass@localhost:8332 \
 --blocks-output blocks.csv

> **Comments:**
> **username_4**: Assume that this link from a new user contains malware.  
> **username_3**: Take 5 seconds to open the Github profile and convince yourself it's not a malware.  
> **username_4**: Better than assuming it is benign. You might be interested in [bitcoin-iterate](https://github.com/rustyrussell/bitcoin-iterate) that's likely many orders of magnitude faster, especially when all of the block files end up in memory.  
> **username_3**: Thanks! You might be interested in this public dataset https://bigquery.cloud.google.com/dataset/bigquery-public-data:crypto_bitcoin. Will take you a few seconds to export the entire blockchain to text files. Powered by blockchain-etl  

---

