ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
How to change delimiter for CSV Export
book
Article ID: 159979
calendar_today
Updated On:
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.