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
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 ...
Sorry, I'm not sure what's wrong. Tried to repeat
- my default Window setting for list separator is comma
- closed all Excel and change setting to semicolon
- start new Excel save as csv, open in Notepad:
- closed Excel
- returned back list separator to comma
- save same file as csv
now it is comma separated