Convert CSV to Excel

Convert CSV to Excel

You may have chosen to download your survey results as a CSV file if you have a large dataset. Downloading the CSV version of results is faster and consumes less memory than downloading as an Excel sheet when you have a large amount of data.


A CSV file is a text file containing a data list. They can be used for sharing data between different programs.


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:


CSV format 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.


tipTip: Sometimes Excel places headers by default that need to be removed.


When else might you want to convert your CSV file to an Excel file?

  • If you are sending out your survey in multiple languages, one of the ways to set up the translations is to download the list of everything that needs translating and do the translation work in Microsoft Excel. The export will download as a CSV file, which you’ll then want to convert for editing in Microsoft Excel. Once you have done the translations, the file will need to be saved back to CSV format, ready for importing to Survey Anyplace.
V
Vincent is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.