Download Responses (CSV, XLSX, SPSS-XLSX).

In This Article:

From any dashboard you can export every individual response (one row per respondent) in three formats:

• Choose which questions to include
• Text Format in CSV
• Numeric Format in XLSX
• SPSS Compatible Numeric Format in XLSX

To open the export menu, click the Download button (the down-arrow icon) in your dashboard toolbar.

The same menu also offers Workbook (xlsx) and PowerPoint (pptx) at the top — those export your tables and charts, not individual responses. See Download Tables & Charts.

Choose which questions to include

Each of the three response exports — All Responses (csv), All Responses (xlsx) and All Responses (spss-xlsx) — opens a second menu. Click a format to choose which questions come across in your file:

• All questions (incl. hidden) — every question in your survey, including any you've hidden. Use this for a complete raw dataset.
• Visible questions in Editor — only the questions currently visible in your survey Editor (the Build tab). Questions you've hidden there are left out.
• Visible questions in Dashboard — only the questions shown as views in the dashboard you're exporting from. Use this when you want a file that matches exactly what you've been analysing.

The three options work the same way for CSV, XLSX and SPSS.

Back to top

Text format in CSV

Click the Download button, choose All Responses (csv), then pick which questions to include. This format has 1 tab and can be plugged straight into Q.

Back to top

Numeric format in XLSX

Click the Download button, choose All Responses (xlsx), then pick which questions to include. This format has 2 tabs and is perfect for Excel users.

The 1st tab shows your survey data in numeric format

The 2nd tab is a Datamap with 3 columns so you can convert the numbers back to text.

1. Column A: Variable label - shows you the question text
2. Column B: Value - shows you the numeric answer
3. Column C: Value label - shows you the text answer

Back to top

SPSS compatible numeric format in XLSX

Demo Video:

Click the Download button, choose All Responses (spss-xlsx), then pick which questions to include. This format has 4 tabs and can be plugged straight into SPSS.

The 1st tab shows your survey data in spss compatible numeric format.

The 2nd tab shows spss compatible variable labels with 3 columns to convert your Question Numbers into Question Text.

1. Column A: Variable shows you the question number, AND:
   • statement number in matrix
   • choice number in rank and multiple choice
   • statement number and choice number in matrix multiple choice
2. Column B: Position shows you the column number of this question in the Numeric Data tab
3. Column C: Label shows you the question label (and ...loop ...statement ...choice labels where relevant)

The 3rd tab shows spss compatible value labels with 3 columns to convert your Numeric Answers back to Text Labels.

• Column A: Variable shows you the question_loop_statement_choice number
• Column B: Value shows you each answer's numeric code/value
• Column C: Value Labels shows you each answer's text label

The 4th tab is a magical syntax you can use in SPSS to instantly import both the Variable Labels AND the Value Labels from XLSX into SPSS.

How?

Simply:

1. Click the Download button (the down-arrow icon) and
2. Select All Responses (spss-xlsx), then choose which questions to include
3. After your Export is built, click Download

After your XLSX has downloaded:

4. Open IBM SPSS
5. Open the Download Folder containing your XLSX data and drag the XLSX data file from the Download Folder straight into SPSS (see Demo Video) OR
6. In SPSS, select File > Import > Excel > select your XLSX data file (in the Download Folder).

Then:

7. Open the XLSX and go to the Import Syntax tab (4th tab)
8. Click Cell A1
9. Press ctrl+a on your keyboard to select the entire syntax in Excel.

10. In SPSS, go to File > New > Syntax
11. Paste your syntax into SPSS (ctrl+v)
12. Press ctrl+a on your keyboard to select the entire syntax (again! but this time in SPSS)
13. Click the "Play" button (i.e. the green triangle) to execute.

Your Export to XLSX > Import to SPSS is now complete with all your data✅, variables✅, and values✅! 🎉

Back to top