CSV without Header issue

[userf24]

Hi,

I have a strange issue with loading a CSV without Header from FTP and trying to work with it.

when im trying to read the file with spreadsheet note and deselect “header row” im getting following output

if i set header to true, im getting the proper table

CSV content is nothing special

A2092RWRLA;SPIKE 29 SH ALTUS 16V XCT HLO;8413616897896;75;          ; ;
A2092RWRMD;SPIKE 29 SH ALTUS 16V XCT HLO;8413616897902;63;          ; ;
A2092RWRSM;SPIKE 29 SH ALTUS 16V XCT HLO;8413616897919; ;29/04/2024;5;
A2092RWRXL;SPIKE 29 SH ALTUS 16V XCT HLO;8413616897926;13;          ; ;
A2092RWRXS;SPIKE 29 SH ALTUS 16V XCT HLO;8413616897933;2;          ; ;
A2092SNRLA;SPIKE 29 SH ALTUS 16V XCT HLO;8413616897940;112;          ; ;
A2092SNRMD;SPIKE 29 SH ALTUS 16V XCT HLO;8413616897957;73;          ; ;
A2092SNRSM;SPIKE 29 SH ALTUS 16V XCT HLO;8413616897964;21;          ; ;
A2092SNRXL;SPIKE 29 SH ALTUS 16V XCT HLO;8413616897971;29;          ; ;
A2092VYNLA;SPIKE 29 SH ALTUS 16V XCT HLO;8413616896004;46;          ; ;
A2092VYNMD;SPIKE 29 SH ALTUS 16V XCT HLO;8413616896011;103;          ; ;
A2092VYNSM;SPIKE 29 SH ALTUS 16V XCT HLO;8413616896028;46;          ; ;
A2092VYNXL;SPIKE 29 SH ALTUS 16V XCT HLO;8413616896035;28;          ; ;
A2592RWRLA;SPIKE 29 DEORE 10V XCM REMOTE;8413616895953;71;          ; ;

nodes also nothing special:

Information on your n8n setup

• n8n version: 1.36.1

[n8n]

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:

[userf24]

i added now a code node, to add a header, is this the solution or is there something better ?

[barn4k]

Hello @userf24

That’s the correct behavior. When the header switch is off, the ftp node doesn’t know how to name the fields, so it returns them as array of column values