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:
- Go to the "Control Panel" of your computer.
- Click "Region"
- 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