Excel is not splitting my export file into columns

If your CSV export isn't splitting into columns in Excel, your Windows regional settings may not be set to split on commas. This may result in all data appearing in one column.

To resolve this:

1. Go to the Control Panel of your computer
2. Click Region
3. Click Additional Settings displayed under Date and Time Formats

4. Enter a comma (,) into the field 'List Separator'

5. Click Apply

6. Click OK, and OK again