Search code examples
excelparsingcsvescapingheidisql

Unable to recognize columns in CSV file except in Excel

I have a following CSV file:

col1;col2;col3;col4
row11;row12;row13;row14
row21;row22;row23;row24
row31;row32;row33;row34
row41;row42;row43;row44

Now, this file can be opened nicely in Excel, which recognizes the columns and the rows separation, but any of the other software I tried (some specialized in CSV editing, and some for other purposes, like HeidiSQL which I used to import the CSV files into tables), so this poses an issue. Theres around 200 rows, with 30 or so solumns, so manually doing this is a really hard task.

Do you know a way to make this a "proper" CSV?

Thanks!

Solution

  • csv = comma separated variables - your file is using semi colons instead of commas, change to commas and it should work