# SpreadSheet node misinterpret datas

**URL:** <https://community.n8n.io/t/spreadsheet-node-misinterpret-datas/34216>\
**Category:** Questions\
**Tags:** spreadsheet-file\
**Created:** [December 14, 2023, 2:49pm UTC](https://community.n8n.io/t/spreadsheet-node-misinterpret-datas/34216 "2023-12-14T14:49:08Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![BenJ](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/benj/32/28342_2.png) [@BenJ](https://community.n8n.io/u/BenJ)\
**Post date:** [December 14, 2023, 2:49pm UTC](https://community.n8n.io/t/spreadsheet-node-misinterpret-datas/34216/1 "2023-12-14T14:49:08Z")

</div>

Hello,

I am working with some CSV files, but some datas from the file are encoded wrong, all of my dates are interpreted as float like in the picture below.

 ![image](https://europe1.discourse-cdn.com/n8n/original/3X/c/9/c98ec70ac7a70b7ff5cc73bebdd955524cdd254e.png)

I checked the option “Read as a string” and my datas are standing like this. I have the same problem with another column with text “0022-0002” which is transformed in a float like in the picture.

Could you let me know if I did something wrong ?

Thank you,  
Ben

---

<div class="post-metadata">

**Author:** ![n8n](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/n8n/32/196425_2.png) [@n8n](https://community.n8n.io/u/n8n)\
**Post date:** [December 14, 2023, 2:49pm UTC](https://community.n8n.io/t/spreadsheet-node-misinterpret-datas/34216/2 "2023-12-14T14:49:09Z")

</div>

It looks like your topic is missing some important information. Could you provide the following if applicable.

- **n8n version:**
- **Database (default: SQLite):**
- **n8n EXECUTIONS\_PROCESS setting (default: own, main):**
- **Running n8n via (Docker, npm, n8n cloud, desktop app):**
- **Operating system:**

---

<div class="post-metadata">

**Author:** ![ihortom](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/ihortom/32/11473_2.png) [@ihortom](https://community.n8n.io/u/ihortom)\
**Post date:** [December 15, 2023, 12:19am UTC](https://community.n8n.io/t/spreadsheet-node-misinterpret-datas/34216/3 "2023-12-15T00:19:09Z")

</div>

@BenJ , could you share your _ **raw** _ CSV file (just a few lines from it if it’s too large)?

Here’s the test workflow and the data looks fine to me

---

<div class="post-metadata">

**Author:** ![BenJ](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/benj/32/28342_2.png) [@BenJ](https://community.n8n.io/u/BenJ)\
**Post date:** [December 15, 2023, 8:44am UTC](https://community.n8n.io/t/spreadsheet-node-misinterpret-datas/34216/4 "2023-12-15T08:44:06Z")

</div>

Hi @ihortom, here is some corrupted datas, I can’t share a lot more because of confidentiality.

 ![image](https://europe1.discourse-cdn.com/n8n/original/3X/2/3/23431e876d86e3c5f0b2fb4955f6fdcc82608383.png)

---

<div class="post-metadata">

**Author:** ![ihortom](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/ihortom/32/11473_2.png) [@ihortom](https://community.n8n.io/u/ihortom)\
**Post date:** [December 16, 2023, 1:57am UTC](https://community.n8n.io/t/spreadsheet-node-misinterpret-datas/34216/5 "2023-12-16T01:57:02Z")

</div>

@BenJ , this is not CSV format. CSV stands for “comma-separated values”. You have `;` separating data. How do you import such data into n8n workflow in the first place? When I use standard CSV file (same values you have but comma separated) I have no problem interpreting those values as strings in the same form they are in the file. I didn’t even have to choose the option “Read As String”

For clarity, I created CSV file locally in the container, read it with “Read Binary Files” and then with “Spreadsheet File” node. All looks as expected

The last node produced (extract)

```auto
[
  {
    "Code": "0072-1017",
    "Date": "07/07/2015"
  },
  {
    "Code": "0072-0801",
    "Date": "07/07/2015"
  }
]

```

---

<div class="post-metadata">

**Author:** ![BenJ](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/benj/32/28342_2.png) [@BenJ](https://community.n8n.io/u/BenJ)\
**Post date:** [December 18, 2023, 8:38am UTC](https://community.n8n.io/t/spreadsheet-node-misinterpret-datas/34216/6 "2023-12-18T08:38:41Z")

</div>

Hi @ihortom,

Thank you for your reply.

Have a good day

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [December 25, 2023, 8:39am UTC](https://community.n8n.io/t/spreadsheet-node-misinterpret-datas/34216/7 "2023-12-25T08:39:25Z")

</div>

Closed on December 25, 2023, 8:39am UTC

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
