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:

Excel Data

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.
SurveyMR Export Tab

Click onto the ‘Export’ tab, enter the date range that you would like to download results from, then click ‘Download’.

SurveyMR Export Options

Your CSV download will be accessible through the waiting room.