I'm trying to export my XLSX
file to CSV
using Excel 2013.
The problem I am facing is that the resulting CSV file uses semicolon (;)
as a separator. I need it to be a comma (,)
.
I've changed my regional settings to use comma as a list separator:
However, Excel still exports with semicolon. How to make it export csv with comma as a separator?
Best Answer
As you've spotted, the list separator isn't for CSV.
I guess this is because you are using comma as the decimal so the default for "comma" separated files becomes semi-colon separated.
I think the only native solution is to change back to standard english settings before saving the file.
Or, as mentioned above, use a utility to change the
;
to,
post save. You could even get clever and intercept the save process in VBA (or simply create your own save button) to output the csv and then call out to the filing system libraries to do a replace text on the file.