SPSS Exports

SPSS Export

Paid feature

You can export your surveys results to use in SPSS (Statistical Package for the Social Sciences)—a popular computer program used for statistical analysis. See example exports »

SPSS exports are available for All Responses Data exports. All Responses Data exports allow you to see the complete answer set for each respondent.

To export your survey results:

Go to the Analyze Results section of your survey.
Select Save As at the top of the page.
Select Export files.
Select the All Responses Data export type.
Choose SPSS, select your export options, and click Export.
To download your file, select Exports from the toolbar, then select the export. Exports are stored here for 14 days.

The export includes SAV file. We recommend using SPSS 17.0.1 or greater to open the file.

The following information will help you get started analyzing in your SPSS program:

Variable View vs. Data View
- The Variable View defines each question and answer choices.
- The Data View is a spreadsheet-style view with all the responses.
- Questions are labeled as q0001, q0002, q0003, and so on. You can edit these labels in the cells of the Variable View, which updates the column headers of the Data View.
- Answer choices are assigned both a numeric value and a variable label name. Use the Variable View to reference the values and names. In the Data View, click View > Value Labels in the toolbar to show the variable label names instead of the numeric values.
Measure & Question Types
Measure
Measure is determined from the question type.
- Scale = Ranking and Numerical Textbox questions
- Nominal = all other question types
Multiple Choice
SPSS assigns a numeric value to answer choices, which you can reference in the Variable View. If multiple answers are allowed, the data will be separated into multiple columns in the Data View since multiple answers cannot exist in one cell.
Ranking and Matrix Questions
The data is separated into multiple columns (as many columns as you have in your question).
SPSS assigns the numeric value by the weighted value, which is not necessarily how you have the answer choices ordered in the survey. This means column one is whatever answer choice was assigned the weight of 1 in the survey, column two is the answer choice with the weight of 2, and so on.
The N/A column is coded as 0. If you assigned the weight of 0 to another answer choice, the cell will show .00 and you'll need to manually fix this.
Skipped Responses

Get Quick Insights with Analyze with AI

Analyze Multiple Surveys Together

How to Analyze Results

SurveyMonkey

SPSS Exports

Related Articles