Sometimes, the comments or other survey-related data are mixed up in the exported CSV file due to a transcoding issue.

To fix this, you'd need to import the CSV formatted data to Excel.

First, you need to export and save the CSV file to your chosen location. Then, start an Excel with a blank workbook open.

Select Data on the ribbon, and then From Text. (If the menu options are greyed out this could be because you do not have a workbook open).

Browse for the CSV file you want to open, click Import.

In the delimiters section, select Comma. The text qualifier box should show the double-quote symbol. Click Transform Data.

Did this answer your question?