Spreadsheet File problem from a CSV file

Questions
1

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 :

unknown
unknown1899×895 87.4 KB

And when using a node after that to use the json data, i can’t get the data.
unknown2
unknown21600×585 29.3 KB

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]:
2

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?

3

Hello,

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

4

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.

image
image2709×1095 174 KB

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

image
image2679×787 53.4 KB

There also seems to be a lot of unneccessary whitespace.

image
image1900×593 22.1 KB

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?

5

Hi,

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: