Contents of Article

1. Issue: Incorrect CSV Formatting
2. Expected Behaviour
3. Cause of Incorrect CSV Formatting
4. Resolution
   
   

Issue: Incorrect CSV Formatting

When exporting to CSV, the CSV file displays all the data in one column:

Expected Behaviour

The CSV data should appear in their own designated columns:

Cause of Incorrect CSV Formatting

This issue usually happens when your PC uses different regional settings to the default settings and uses different characters for decimal places and list separators.

Resolution

1. Go to Start > Control Panel > Regional and Language Options
   
   
2. Click Additional Settings
   
   
   
   
3. For Decimal Symbol, enter a dot: .
   
   
4. For List Separator, enter a comma: ,
   
   
   
   

5. Open a CSV file in Excel and it will automatically find the data fields and separate it appropriately.