Forum Discussion
SEMI COLON (;) COLUMN SEPARATOR INSTEAD OF COMMA (,) WHEN WE EXPORT AS CSV UTF-8 FILE FORMAT
krish86 , that's only if change system separator
- open your file(s) you'd like to save as csv
- Win+R and type "control international", click Additional settings
- Change List separator on semicolons and click Apply
- save your Excel files as csv
- Change back List separator on comma and Apply (or Ok)
Sure you may keep your list separator as semicolon, but that could be side effect in different places, better to keep default one for your locale
SergeiBaklan Dear Sergei, I have the problem other way round. I need a comma separated csv. I followed all the steps - but still if I open the csv in text editor - it is still semicolon separated.
To be sure, on Windows you have list separator as comma, correct?
Dear SergeiBaklan, I followed the steps you described above and changed it in Excel from Semikolon to Comma - but it does not work. I there a general setting in Windows as well? Cannot find it... My language Settings are switched to German..
- Dear Sergei, sorry my fault. I used the Windows+R and thought it leads to an excel setting. Your above screenshots show what I already did. But still. I convert the xls to an csv - open it in editor and it is still semikolon separated ...