![]() Responses view, to analyze the responses you have collected, the last slide and last question when save per question or save and continue is enabled.You can also see graphical representations of the results of each question separately and the results of each question block of your survey. Charts view: allows you monitor the number of responses, the completion rate and the average duration of your surveys.If you want to separate your values with something else than a comma, for example with a semicolon ( ), you can click on Custom and enter your separator " "Īfter you import your data, you can delete any additional columns that you don't want. Choose the Import location and Separator type. You can also convert text to numbers, dates, and formulas. Converting CSV to Google Sheetsįirst, go ahead choose File and click Import to upload your CSV file into Google Sheets.Īfter you choose your file, the Import file window will pop up. Now all your data will be in separate columns, and you can save your Excel file. The Column Data format should be kept as General. Now check the box to add Semicolon to the list of Delimiters. Make sure Delimited is selected as the file type, and then click Next. Select the file you have just downloaded from the software. Click on the Data tab and select From Text. Once you have saved the file, open a blank workbook in Excel. Sometimes Excel places headers by default that need to be removed Your data should be divided into separate columns, one column for each question of the questionnaire. Check the Delimiter is set to Semicolon, then click Load at the bottom of the box. ![]() Go to the Data tab and click From Text/CSV.Ĭhoose the file that you have just downloaded from the software. When you're ready to download your results as a CSV file, click Save File rather than Open with. We need to convert the file because right now, this is how it looks like: Of course, it's exciting to see them but just wait before opening the file. Each line of the file is separated by commas.Īfter you've downloaded the CSV results file, it's time to take a look at the results. It can be used for sharing data between different programs. A CSV file is a text file containing a data list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |