Spreadsheet reading date types as numbers

I’m using the FTP node to download a CSV file and read it by the spreadsheet node.
However, I have date type values but the Spreadsheet node is reading them as numbers.



image

Hi @rahma_sayadi

Have you checked the csv in a text editor? Like notepad or notepad++.
Excel does some stuff when loading in a csv. In this case it might recognise the numbers as date time formats. As they are essentily just that.

If they are actually numbers you would need to change that in the source, or modify it in n8n with a set node or a date&time node.

Edit: If the values are actially date time strings. There should be an option in the spreadsheet node to read the source data. (If I remember correctly)

Hope this helped.

hello @BramKnuever
Thank you for your reply.
I checked in notepad++ they are date type


I can’t add a set node as you mention because I don’t know which field is of type date.

The solution is to enable the “Raw Data” and “Read As String”

1 Like

Hi @rahma_sayadi
Was just about the answer that, as I just sat down behind my PC.

image

Good to know you found the solution. :slight_smile:

1 Like

Thank you @BramKnuever

1 Like