Excel – How to change default csv separator in Excel 2013

microsoft excel

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:

enter image description here

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.

Related Question