importX icon indicating copy to clipboard operation
importX copied to clipboard

FYI - CSV file requirements

Open nicboyde opened this issue 13 years ago • 0 comments

It may be obvious to some, but the csv file needs to comply with some standards. Both Excel and Open Office calc produce csv files, and these csv files will not work, because they insist on using single quotes or double quotes to denote text (as opposed to numbers, I presume).

Watch out for extra blank lines in the csv file after the main data - these will cause the "element count do not match" error message to appear.

I used Notepad++ to clean up csv files produced by both Excel and Calc.


Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

nicboyde avatar Jan 13 '12 06:01 nicboyde