How to view individual respondents in exported spreadsheets

When you download your data in spreadsheet format, you will see each participation individually in its own data row. Data columns will show you questions and their respective answers.

* The above data are fake.

The above table shows an example of a downloaded spreadsheet file. First row shows survey questions, and each of the next rows represent one respondent. In this example, we only show first columns of such a file. In an originally downloaded data-sheet, you will see more information (columns), automatically generated or tracked by SurveyLegend, such as the time and date at which each participant has started and submitted your survey, geo-location of participants, their IPs, and more…

Filter responses based on submission status

In the columns, you will also be able to see when a visitor has opened your survey link, when participation has started, and when the survey was submitted. you can also see the total time spent on the questionnaire.

This way, you can easily filter out those participants that have not finished the survey (those which do not have a “completed” time), and filter them out in your spreadsheet application. However this is functionality is inbuilt in Individual responses view.