Online Support Centre

Follow

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

 

Was this article helpful?
0 out of 0 found this helpful

Comments