# Issue with date in spreadsheet node

**URL:** <https://community.n8n.io/t/issue-with-date-in-spreadsheet-node/11928>\
**Category:** Questions\
**Tags:** data-transformation, node\
**Created:** [March 6, 2022, 10:40am UTC](https://community.n8n.io/t/issue-with-date-in-spreadsheet-node/11928 "2022-03-06T10:40:23Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mcc37](https://avatars.discourse-cdn.com/v4/letter/m/c37758/32.png) [@mcc37](https://community.n8n.io/u/mcc37)\
**Post date:** [March 6, 2022, 10:40am UTC](https://community.n8n.io/t/issue-with-date-in-spreadsheet-node/11928/1 "2022-03-06T10:40:23Z")

</div>

Hi,

I’m pulling electricty price history from French Governement open dataset : `https://www.data.gouv.fr/fr/datasets/r/c13d05e5-9e55-4d03-bf7e-042a2ade7e49`

I use this workflow to transform this csv file to a spreadsheet so I can insert it into a PostgreSQL database.

I have an issue with the date format. Starting at 2014, there is an issue in DATE\_DEBUT column, it’s not a date anymore but a number.

 ![Capture d’écran 2022-03-06 à 11.37.33](https://europe1.discourse-cdn.com/n8n/original/2X/7/7cbda53c2ec8df00181c9bf163edbe836ed5e221.png)

Any idea ?

My n8n setup :

- **n8n version:** 0.165.1
- **Database you’re using (default: SQLite):** PostgreSQL

---

<div class="post-metadata">

**Author:** ![RicardoE105](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/ricardoe105/32/550_2.png) [@RicardoE105](https://community.n8n.io/u/RicardoE105)\
**Post date:** [March 6, 2022, 2:14pm UTC](https://community.n8n.io/t/issue-with-date-in-spreadsheet-node/11928/2 "2022-03-06T14:14:17Z")

</div>

Not sure why this is happening, but if you set raw data to true (underneath options), it parses the dates correctly.

---

<div class="post-metadata">

**Author:** ![mcc37](https://avatars.discourse-cdn.com/v4/letter/m/c37758/32.png) [@mcc37](https://community.n8n.io/u/mcc37)\
**Post date:** [March 6, 2022, 3:44pm UTC](https://community.n8n.io/t/issue-with-date-in-spreadsheet-node/11928/3 "2022-03-06T15:44:19Z")

</div>

Thanks @RicardoE105, it’s working. Not clear what it means, but it’s ok.

---

<div class="post-metadata">

**Author:** ![mcc37](https://avatars.discourse-cdn.com/v4/letter/m/c37758/32.png) [@mcc37](https://community.n8n.io/u/mcc37)\
**Post date:** [March 6, 2022, 4:26pm UTC](https://community.n8n.io/t/issue-with-date-in-spreadsheet-node/11928/4 "2022-03-06T16:26:28Z")

</div>

To share the final result if someone interested to reuse, this flow pull Tarif bleu de l’électricté history from French Governement open data and fill a PostgreSQL / TimescaleDB table.

Pour partager le résultat final si cela intéresse quelqu’un, ce flow récupère l’historique du Tarif bleu de l’électricité depuis le site open data du gouvernement français et le stocke dans une table PostgreSQL / TimescaleDB.

 ![Capture d’écran 2022-03-06 à 17.23.43](https://europe1.discourse-cdn.com/n8n/original/2X/b/bc2becedba20debea8bd596c3a7d25b6daa58f24.png)