Convert CSV to Excel
After you've downloaded the CSV results file (see here to learn how to download results), it's time to take a look at the results. Of course it's exciting to see them, but just wait before opening the file. We need to convert the file because right now it is in CSV format and looks like this:
When you're ready to download your results as a CSV file, click Save File rather than Open with.
If you were so eager to see your data and you've already opened the CSV file in Excel, skip to Section 3.
Once you have saved the file, open a blank workbook in Excel. If you're working with recent version of Excel, follow these steps, otherwise read the later steps.
1 Latest Excel versions
Go to the Data tab and click From Text/CSV.
Choose the file that you have just downloaded from the software.
Now you'll see the screen below. Check the Delimiter is set to Semicolon then click Load at the bottom of the box.
Now your data should be divided into separate columns, one column for each question of the questionnaire. Make sure you save the Excel file!
2 Older Excel versions
If you have an older version of Excel, you can convert the CSV file to an Excel file by clicking on the Data tab and select From Text.
Select the file you have just downloaded from the software.
Now you will see this screen. Make sure Delimited is selected as the file type, and then click Next.
Now check the box to add Semicolon to the list of Delimiters. Then click Next.
The Column Data format should be kept as General. Complete by clicking on Finish.
Now all your data will be in separate columns and you can save your Excel file.
3 Converting the CSV file when it's already open in Excel
If you were so eager to see your results and you've already opened the CSV file in Excel, here's how to convert the data into separate columns so you can read it easily and perform analysis.
All of your data will be in Column A. Click A to highlight the entire column.
Now head to the Data tab and click Text to Columns.
Now you will see the same screen as in Section 2. Follow the rest of the instructions above.