When using the Text Import Wizard, select Delimited, Comma, and Text in the prompts.
Time stamp or Date/Time question data doesn't show
The info is there, but it's hidden. Edit the cells in Excel:
Right-click on the affected cells and select Format Cells.
Go to the Number tab.
From the Time category, choose the desired format, then click Ok.
File too large
There is a limit of 3000 answers for PDF exports. An answer is the total number of survey responses multiplied by the number of questions in the survey.
No data for rating scale question
If you used a Rating Scale question, you need to add column choices or labels in the survey design in order for the data to export to the spreadsheet.
Go to the Design Survey section of your survey.
Find the Rating Scale question you used.
Add column choices or labels and save.
Go the Analyze Results section of your survey and export again.
Export won't open
If your export won't open, you might need to decompress the file or enable pop-ups in your browser.
Numerical values display as scientific notation in CSV and XLS exports
Occasionally, numbers in CSV and XLS exports display in scientific notation, rather than the number survey takers entered into your survey. In order to see the numbers as entered into your survey, you can change the number’s appearance by applying formatting.
To fix the formatting of your numerical values:
Select the cells you wish to change.
Right-click and select Format Cells.
On the Number tab, highlight Number within the Category field.