Export to SPSS

You can export your survey results into SPSS to perform advanced data analysis.

To export your survey results into SPSS select the report, click the Publish button from the right pane. You can also navigate to the SPSS Export option directly by clicking the Export to SPSS link from the right pane.

1. Select the 'Export to SPSS' option.
2. Setup export options:
   • Select the 'Export labels only' to export the report with labels only.
     
   • Select the 'Export values only' to export the report with values only.
     
   • Select the 'Export values and labels' to export the report with both values and labels.
   • Select the Export labels and values that toggle option to export to SPSS with the ability to toggle between values and labels.
     
     
   • Select the 'Default' option to use the default encoding while exporting your report to SPSS.
   • Select the 'Other' option to open a drop-down box for choosing the proper encoding, if your report contains data in any language other than English.
   • Select the Show Overall Respondent # option to show respodents' actual sequence numbers within the report. This option is commonly used if you filter responses but need to keep their original sequence numbers.
   • The Support multiple response sets option is used to create multiple response sets. more...
3. Click Export To SPSS.
4. When the dialog box pops up click Open to open the document in SPSS or click Save to save it in SPSS format (.sav) to your computer.

While exporting survey report to SPSS, the data will be arranged in the following way:

1. Each response (respondent's answers to all survey questions) appears in one row.
2. The sequence of columns will be as follows:
   • 1st column: the respondent's sequence number;
   • 2nd column: the date and time the survey was submitted;
   • 3rd column: respondent's email (if the survey was distributed via our mail system and was not anonymous);
   • starting from the 4th column the sequence of columns is the same as the order of questions and answer choices in the exported report and contains values and labels that toggle.

   Note If you click the 'Data View' tab you see answers to the questions with the questions represented as variables. If you click the 'Variable view' you see questions and full information about variables.

3. The number of columns used for each question depends on the question type, number of answer choices, answer labels and values set.
   Accordance of questions and columns will be as follows:
   • 'Multi-Line Text Response' - one column per question. The column contains response text.
   • 'Single Line Text With Pre-Format Options' and 'Numeric Allocation' - a column per answer field. Each column contains corresponding response text or numeric value.
   • 'Compare One Against Another' - a column for each answer choice. The number in the column reflects how many times this answer choice has been selected.
   • 'Rate Different Items Along The Scale Of Your Choice' - a column per answer choice. The number in the column is the order number of the selected rank in the rating scale.
   • '3D Matrix' - a column per answer choice. The heading of the column contains variables q, a, s with numbers; q refers to the number of survey question, a and s are used to identify the matrix row and column numbers correspondingly. For example, q1a2s3 refers to the answer in the survey question N 1, in the matrix row N 2 and in the matrix column N 3.
     The cells of 3D Matrix will be exported accordingly to their format:
     • 'Pick One', if the radio button has been selected the column will contain number '1', otherwise it will be empty.
     • 'Check All That Apply', if the check box has been selected the column will contain number '1', otherwise it will be empty.
     • 'Dropdown Box', if the answer has been selected the column will contain the order number of the selected answer, otherwise it will be empty.
     • 'General', if the text field has been filled in the column will contain the text, otherwise it will be empty.
   • 'Pick One or 'Other'' And 'Dropdown Box' - one column per answer. This column contains text of the selected answer choice.
   • 'Check All That Apply' And 'List Box' - a column per answer choice. If the answer choice has been selected, the column will contain text of the answer choice, otherwise it will be empty.

Multiple Response Set
This feature is applicable for the Export labels and values that toggle option and is commonly used to create multiple response sets for the multi-choice types of questions such as Check All and List Box. In this case responses will be exported in the following way:

• Values - 1 for selected response, 0 for thos that are not selected.
• Labels - Yes for selected response, No for thos that are not selected.