Spreadsheet File problem from a CSV file

Describe the issue/error/question

From a CSV file i use Spreadsheet File to read the content of the csv and convert it to json. The : cause a break line problem. See screenshot :

And when using a node after that to use the json data, i can’t get the data.

CSV file : https://tmpfiles.org/30854/csv2.csv

What is the error message (if any)?

View message above

Please share the workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 0.192.0
  • Database you’re using (default: SQLite): Default
  • Running n8n with the execution process [own(default), main]:
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]:

Hey Nelekt,
sorry to hear you are having trouble. When I try to download your csv I am getting 404 NOT FOUND. Can you upload your csv again?


Here a new link: Easyupload.io - Upload files for free and transfer big files easily.
Pass: n8nsupport

Hey @Nelekt,
I just tried out your csv file and the file content itself seems to be corrupted. It’s true that the csv is parsed incorrect.

Looking at the file itself, are all the Banner : lines supposed to be there?

There also seems to be a lot of unneccessary whitespace.

I have to say I’ve never seen a csv like that so I am unable to help here. Are you able to work with more regular csv files? Am I missing something?


The csv file comes straight from F-Secure Elements VM API

I have no other way to get the CSV.

It’s probably a problem with their API then :confused: