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 data example


Choose which section of this guide is relevant for you:

  1. Latest Excel versions
  2. Older Excel versions
  3. Converting the CSV file when it's already open in Excel


1 Latest Excel versions

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


convert csv to excel save file


Once you have saved the file, open a blank workbook in Excel. Go to the Data tab and click From Text/CSV.


convert csv to excel - get data


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 semicolon delimiter


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

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


convert csv to excel save file


Once you have saved the file, open a blank workbook in Excel. Click 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 - delimited


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


convert csv to excel choose semicolon delimiter


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


convert csv to excel finish text to columns


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 - highlight column


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


convert csv to excel - data text to columns


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