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:


convert csv to excel image1


When you're ready to download your results as a CSV file, click Save File rather than Open with


convert csv to excel image2


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.


convert csv to excel image3


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.


convert csv to excel image4


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.


convert csv to excel image5


Now check the box to add Semicolon to the list of Delimiters. Then click Next.


convert csv to excel image6


The Column Data format should be kept as General. Complete by clicking on Finish.


convert csv to excel image7


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 to highlight the entire column.


convert csv to excel image8


Now head to the Data tab and click Text to Columns.


convert csv to excel image9


Now you will see the same screen as in Section 2. Follow the rest of the instructions above.