Actually, when I upload the demo CSV file without changing anything, the importation works fine.
But if I change only 1 character of the data (“Benton” to “Alex”), the error “Line 2 has too many columns” appears.
How can I solve that issue?
Thanks for your answer.
I found the demo CSV file on my FTP access.
The fields are well separated by comas in the cell A1 (company_name,level_ID,contact_email,expiration_date,…)
But I notice that the data is split into 5 different cells.
A2 – Benton, John B Jr,1,[email protected],25.12.2018 12:15,USA > Lousiana
B2 – Canada > Ottawa > Ottawa,”6649 N Blue Gum St, New Orleans
C2 – 1210 Stittsville Main Street”,…
Is 5 the number max of columns for the import?
Because when I import the same file but with separated cells for each field as such:
A2 – Benton, John B Jr
B2 – 1
C2 – [email protected]
D2 – 25.12.2018 12:15
E2 – …
the error message “Line 2 has too many columns” appears again.
Very useful answer, thanks a lot.
