Follow these steps if the file is displayed as a long string without any columns when you try to open it:
- Start Microsoft Excel and open the CSV file.
- Select column A, click on “Data” and “Text to columns”. The “Text Wizard” will start.
- Choose”Delimited” and click next.
- Choose”Comma” as delimiters and “{none}” as text qualifier, then click next.
- Choose”General” and click finish.
If it still results in a long string:
- We recommend downloading a new CSV file instead of the one you experienced problem with, as it may have been auto saved in the corrupted format without columns.