Open downloaded responses in Excel

When downloading the responses from your dashboard, a CSV-file is sent to your e-mail. Sometimes, when opening a downloaded CSV file in Excel the columns and rows are not correctly divided in the sheet. To get a clear overview, with all data in a neat sequence, read the support article on Microsoft or take the following steps:

Step 1: Save your CSV-file on your computer;
Step 2: Open Excel en select  Import in File;
Step 3: Select CSV file when selecting the type of file you want to import;
Step 4: Select Delimited below Original data type;
Step 5: Select Comma and Tab as delimiters and press Next;
Step 6: Check the box wit General below Column data and click on Finish.

You're now able to read the CSV-file: every answer is stated in a separate column. Below, you find screenshots of the steps described above.

Step 2:

Step 3:

Step 4:

Step 5:

 

Step 6:

 

 

Have more questions? Submit a request