SPSS Export Format

1. Overview

The SPSS format presents data in the same wide structure as the Wide format export (one row per respondent, one column per question) but also includes additional metadata for each variable. This makes it the preferred choice for researchers using SPSS, Stata, or other statistical tools that can read SPSS files.

Standard SPSS exports are delivered as .sav files, which open in SPSS as well as Stata, R, and other third-party tools that read SPSS files. The Q-optimized bundle uses compressed .zsav data with the same SPSS metadata.

2. File Structure & Layout

• Each row corresponds to one respondent.
• Each column corresponds to one question or metadata field.
• Variable names follow the same convention as Wide format (e.g., V001_respondent_id, V002_Recent_Restaurant_Visit).

Where a question expands into many variables — for example a multi-select question with one variable per option — those expanded fields are given compact indexed variable names rather than long generated names built from the option text. This keeps names within SPSS's variable-name limits and avoids unwieldy or truncated identifiers. The descriptive labels are retained, so each indexed variable still carries the full question and option text as its variable and value labels, and remains readable in SPSS and Stata.

Example (first 5 columns):

V001_respondent_id	V002_Recent_Restaurant_Visit	V003_Age	V004_Gender	V005_Ethnicity
0097ac15-868c-6608-25fc-c0fe2cd884a8	Yes	35	Female	White
012a5d8b-9dc4-2132-782d-73742be4088f	Yes	21	Female	White
022b6b43-6304-2dc5-0830-10d98bd7dee3	Yes	18	Male	White

3. Key Columns

• V001_respondent_id - Unique identifier for each respondent.
• Question columns (V###_...) - Same as Wide format but with metadata.
• Weight column (e.g., V171_weight) - Statistical weight for the respondent.
• Timing columns (e.g., V172_start_time, V173_end_time) - Survey start and completion timestamps.

4. Data Representation

Single-choice questions

Stored as one column per question with the selected answer recorded.

Multi-choice questions

Each option is represented as a separate column. The value assigned to each selected option indicates the order in which the respondent selected it (e.g., -1 = not selected, 1 = selected first, 2 = selected second, 3 = selected third, etc.). This preserves the sequence of selections, which can be useful for analyzing which options respondents considered first.

If the respondent selects an exclusive option (such as "None of the above" or "Prefer not to say") after previously selecting one or more non-exclusive options, the exclusive option is recorded with a value reflecting the order in which it was clicked, and all previously selected non-exclusive options are deselected at that point (reset to -1). Only the exclusive option will appear as selected in the final data.

You may want to consider defining MRSETS within SPSS to facilitate easy reporting, as this is not something that MX8 Labs includes in the export file.

Numeric questions

Stored directly as numeric values. "Don't know" responses are coded as -999 and flagged as an SPSS missing value, so they are automatically excluded from means, medians, and other numeric summaries.

Rating and NPS questions

Rating and Net Promoter Score (NPS) questions are stored as their numeric scale value (for example, a 1–5 rating or a 0–10 NPS score), so they can be analyzed directly as scale variables — means, top-box, and NPS calculations all work without re-coding. The descriptive value labels are retained alongside the numeric values, so labeled categories still display in SPSS and Stata.

Fractional scale values are preserved exactly as captured (for example, a 3.5 on a half-point rating scale is exported as 3.5, not rounded), so half-point and other non-integer scales analyze correctly.

Open-end questions

The standard coded SPSS export includes only the coded values for open-end questions, not the raw verbatim responses. This keeps the file aligned with a statistical analysis workflow where categorical codes are more useful than free text.

• Each coded open-end appears as a labeled numeric variable, with value labels mapping each code to its human-readable category.
• Until the open-end field has been closed (i.e., coding is finalized for the field), all responses in that variable are marked as "To be classified" in the export. Once the field is closed, the export reflects the final code assignments.
• If you need the raw, uncoded verbatim responses, download the data in CSV or one of the other non-SPSS formats, which include the full response text.

Use an uncoded SPSS export, Long Excel, or raw CSV when you need the original verbatim response instead of the finalized open-end code.

Uncoded exports

The SPSS format is also available as an uncoded export, which returns the underlying response value as it was captured rather than the recoded category. Use it when you want to analyze or re-derive the original answers, including open-ended verbatims, instead of the recoding applied for reporting. Select an Uncoded card in the download dialog; the variable structure and metadata are otherwise unchanged.

Q-optimized exports

Choose Q-optimized SPSS File and Codebook when you plan to import the data into Q and want multi-select questions detected as Pick Any questions.

The export creates two related groups for each multi-select question:

• Selection variables show whether each option was selected. Respondents who were not shown an option are excluded from that option's base.
• Selection-order variables retain whether an option was selected first, second, or later. These variables use _order in their names.

This preserves both the Pick Any base and the order in which options were selected, including for rotated or selectively exposed options.

The download is a ZIP archive containing a compressed .zsav dataset and an Excel codebook.

To check the import in Q:

1. Keep Automatically detect data file structure enabled when importing the .zsav file.
2. Confirm each multi-select selection group appears as one Pick Any question.
3. Check one respondent who saw all options, one who saw a subset, and one who was not shown the question.
4. Confirm the _order group retains first, second, and later selection positions.

Analysis-ready bundles

Choose SPSS Analysis Bundle when repeating responses need to be analyzed separately from one-row-per-respondent data.

After extracting the ZIP:

1. Start with bundle_index.xlsx. Its Datasets and Variables sheets explain what each file and variable represents.
2. Use respondents.sav for one-row-per-respondent analysis.
3. Use the relevant stack_*.sav file when analyzing a repeating response. Each row represents one respondent at one unique combination of the stack dimensions listed for that file.
4. Use the respondent details included in a stack file when you need demographics or weights in the same analysis.
5. To open every dataset in SPSS, set the working directory to the extracted folder and run open_all_tables.sps.

Use README.txt for guidance included with the bundle. Choose Uncoded SPSS Analysis Bundle when you need the original captured values instead of coded reporting values.

5. Metadata Provided

The SPSS format includes additional metadata that makes analysis easier:

• Variable labels - Full question text (e.g., "What is your gender?").
• Value labels - Mappings of codes to human-readable labels (e.g., 1=Male, 2=Female, 3=Non-Binary).
• Measurement levels - Nominal, ordinal, scale, etc., depending on the question type.
• Missing value definitions - Explicitly marked missing values (e.g., -1 = Not selected).
• Variable types - Numeric, string, date/time.

This metadata ensures the dataset is analysis-ready in SPSS and other statistical software.

6. Missing & Special Values

• -1 typically denotes unselected or non-applicable options.
• Empty cells may represent skipped questions.
• "Prefer not to say" appears as a standard category.
• All missing values are flagged as SPSS missing values in the export — including any negative sentinel codes (e.g., -1, -2, -99). This means SPSS, Stata, and other compatible tools will automatically exclude these values from calculations such as means, frequencies, and cross-tabs, without requiring you to define missing values manually.

7. Weighting

• Apply the weight column in analysis to ensure results reflect target population.

8. Best Practices

• Use the built-in metadata in SPSS/Stata to reduce manual labeling.
• Leverage variable labels to quickly identify questions.
• Use value labels to decode numeric response values.
• Match V### codes with reporting_id from the Long format if you need to cross-reference.

9. Stacked Exports

The SPSS format supports stacked exports, where the data is organized by the tags assigned to each question in the survey editor. In a stacked export, each respondent row is repeated for every tag group, and only the variables belonging to that tag are included alongside the respondent identifier and metadata variables (weight, timing). All SPSS metadata — variable labels, value labels, and measurement levels — is preserved for each variable in the stacked output.

To generate a stacked export, select the Stacked option in the download dialog. The resulting file will contain a Tag variable indicating which tag group each row belongs to.

This is particularly useful when you want to run separate analyses on different sections of a survey (e.g., "Brand Awareness" vs. "Purchase Intent") without manually subsetting the data.

10. Choose an SPSS export

Choose	When to use it	Rows in the file
SPSS File or SPSS File and Codebook	General work in SPSS, Stata, R, or another compatible tool.	One row per respondent.
Q-optimized SPSS File and Codebook	Q analysis that should detect multi-select options as Pick Any questions while retaining selection order.	One row per respondent, with separate binary selection and ordinal order groups.
Raw Data in SPSS (Stacked) or its codebook bundle	Analysis organized by survey tags where repeating respondents in one file is intentional.	A respondent can appear once per tag group.
SPSS Analysis Bundle	Complex repeating responses that should be separated into analysis files.	One respondent file plus separate files for each repeating structure.

Choose the corresponding Uncoded card when you need original captured values instead of the coded categories used in reporting. If you are unsure, start with SPSS File and Codebook; use Q-optimized for Q, or an analysis bundle when repeating responses need separate files.

For the download-dialog workflow, see Downloading data and reports.