Spreadsheet node not working anymore

Questions
1

Hi,

I have a workflow that has been running for a long time now. It has always worked fine but last week it suddenly stopped working. I found what’s wrong but I don’t understand why and I guess it’s a bug in N8N..
I use the spreadsheet node to read a csv file. This always worked fine like this screenshot from 3rd of June:

Scherm­afbeelding 2024-06-10 om 16.59.25
Scherm­afbeelding 2024-06-10 om 16.59.253840×1826 320 KB

But suddenly the next day something strange happens with the data:
Scherm­afbeelding 2024-06-10 om 16.59.35
Scherm­afbeelding 2024-06-10 om 16.59.353840×1828 307 KB

Can anyone help please because this issue is very urgent. I know there is a new node to read a file from csv to json but this also does not work because something goes wrong when the values of the csv are in quotes:

image
image1920×911 60.5 KB

2

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:
3

I use n8n cloud with version 1.42.1

4

Hi @Marciano_Antonacci

I think this should work when you set the option to Exclude BOM

image
image840×972 40.2 KB

5

Hi Ria,
You’re correct! I received another error because the delimiter was “;” instead of “,”… But after setting the delimiter option it worked perfectly fine.
Thanks a lot