How to change delimiter for CSV Export
search cancel

How to change delimiter for CSV Export


Article ID: 159979


Updated On:


Data Loss Prevention Enforce


If you need to export Excel data to a CSV file but the data have commas in it, you can in Windows change the delimiter used in the export from outside of Excel -- specially via the Control Panel.



Go to the Control Panel –> Regional and Language Options (or Date, Time and Regional Options –> Regional and Language Option on some machines) –> click the Customize button. In the dialog box that opens you will see and option for "List separator" in which you can change the comma to a different character –> click Apply then Ok and then Apply again. Now when you go into Excel and choose Export as CSV the new character will be used as the delimiter.