How to change delimiter for CSV Export

Products

• Data Loss Prevention Enforce

Issue/Introduction

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.

 

Resolution

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.