How do you export a comma delimited file in Excel 2013 & Windows 8 using the "Save As"
You would think that CSV (since its name says its comma separated values) would use a comma, but no, it uses semi-colons.
I have tried changing the "list separator" value in my region settings to "," from ";" as suggested on some other forums but this does not help. Its still exports a COMMA separated file with a semi-colon separator. Ridiculous.
I do not want to change my entire region to US, as that changes date & number formats, and that's not acceptable.
I have faced exactly the same problem and found not a solution, but rather a workaround. As my regional decimal separator is not a dot, but a comma, thus I had to uncheck "Use system separators" and manually change decimal separator from comma to dot in Excel > File > Options > Advanced. It looks like the list separator in Regional settings must be different from decimal separator. It's logical, but very frustrating to keep in mind every time I export CSV files from Excel. Microsoft could be much more flexible by implementing options to choose which CSV delimiter to use in Save As file type CSV dialog. As alternative I also use OpenOffice Calc to manage my CSV files. It's much more easier.
I hope it will help!
The thing is, the csv separator is NOT a nummerical separator. So it has nothing to do with the regional settigs !!
It is the field separator in a text based file. Excel exports with a delimiter that is a semicolon. Outlook, for example, imports only when it's a comma !
It is the way Excel exports to a CSV format.
I have searched all options in excel, but can't seem to find a way to change the separator.
For now i change the semicolon into a comma in notepad pretty pathetic..... :(
- Edited by Ger Voeten Thursday, January 22, 2015 11:30 AM