How to download SurveyMR data to Excel
Download data from SurveyMR into Excel in just a few simple clicks for further, detailed analysis.
You can download your survey results to a CSV file, this produces a download with one set of responses per row, and each question in a column:
Multiple choice questions and grids have a column for each answer choice in binary format, where:
· 0 = answer has not been chosen
· 1 = answer has been chosen
The columns at the end of the file include:
- System unique ID, user name
- The date and time the survey was started
- The date and time the survey was finished
- The average time
- Any user fields which are set to be shown in the CSV download
Date Range Download
In addition to downloading full results as an Excel CSV document, SPSS or Triple-S file, you can also download an Excel CSV file of survey responses between two selected dates.
You can access this from the ‘Export’ tab via: Back Room > Research tools > SurveyMR and clicking into your chosen survey.
Click onto the ‘Export’ tab, enter the date range that you would like to download results from, then click ‘Download’.
Your CSV download will be accessible through the waiting room.