Excel is not splitting my export file into columns

If you have Excel 2016 installed on your computer, your CSV settings may not be correctly set to split a CSV file based 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

7. Click OK