Exports are survey data files that you can download for use with programs such as Excel or SPSS. To create a new export, click Export Survey Data in the Analyze button group, or click the New Export button while in Deliverables.
Overview
Creating an export is similar to creating a report. Customize your export by selecting respondent statuses, applying filters, and choosing the relevant survey fields to focus on the specific data you need.
- Export Options: There are several file types available, including Excel, ASCII, SPSS and more.
- Records: Use the Records dropdown to define which respondent statuses should be included in the report.
- Filters: Use the Filters dropdown to select previously created data cuts (found in the Pre-Built dropdown) or to build a new one. Date/Time and ID filters are also found here. For more information on creating data cuts, see Expression Builder.
-
Fields: Click Select All to include all survey fields or click in the Fields box to select only the fields you need. The report displays the survey fields in the order they are selected, but they can be reordered at any time by dragging and dropping them within the box or click the
to reorder them by dragging the
handles.
- Field Type: Filter by question type (e.g., text or numeric) to limit the export to specific fields.
- Display Draft Version: Use this toggle to pull data from either the most recent Draft or Published version of the survey. This toggle is only available when the latest version of the survey hasn't been published.
-
Advanced Export Options: Extra formatting settings vary by file type. Click on the
icon for additional information.
File types
The following file type options are available for export.
| File Type | Description |
| ASCII Text, Delimited | Creates delimited rows of text in a basic file that can be read as .txt or .csv. |
| ASCII Fixed Field | Works with a mapping file that describes how many sequential characters from each row are assigned to each field description. |
| Excel 95-2003 | Creates an older Excel-compatible export (.xls) with size constraints of 65k rows by 256 columns. The spreadsheet includes a tab describing each field. |
| Excel (.xlsx) | Default; creates an Excel-compatible export (.xlsx) with size constraints of 1M rows by 16k columns. The spreadsheet includes a tab describing each field. |
| JSON | Creates a text file that displays the data in a structured format using key-value pairs. |
| SPSS Binary Format (.sav) | Creates a file in a proprietary data format for use with IBM's SPSS statistical analysis platform. |
| Triple-S | Saves the file in a "survey interchange standard" format, enabling survey data sharing between platforms. |
| Verticalized (Tableau) | Displays responses in a "verticalized" output with a single column for each question and multiple rows for each respondent record. Only certain field types are verticalized (e.g., checkboxes are, whereas radios are not). |
| Quota Panels | Creates an export of the quota totals and caps set in Quotas. |
| Flattened, Delimited | Downloads data organized by respondent record, with all selected fields and listed vertically by respondent. Rendered as a .csv file. |
| Verticalized by List (.xlsx) | BETA; takes a single list from the survey to display vertically ("verticalized") in order to analyze it alongside the list's related survey fields. Exported as an Excel file. |
Downloading and saving exports
After choosing your export settings, click Export. A progress pop-up appears in the lower-right corner and stays visible even if you leave the page.
The file downloads automatically when complete. To save it for later, enter a name in the text field and click the icon.
Saved exports can be found in Deliverables. Before downloading a saved export, rerun it to ensure it's up-to-date.
Response reports vs. Excel exports
Response reports vs. Excel exports
Response reports and Excel exports both provide survey data but format checkbox (multiselect) questions differently:
- Response reports: Display all selected options in a single column as a comma-separated list.
-
Excel exports: Display each option in its own column with values of
1(selected) or0(not selected). Column headers append the option number (e.g.,Q2.5for Q2, option 5).
Excel export files also include a Questions tab mapping question and option IDs to column headers, which response reports do not provide.
Below is an example of a Response report, with the checkbox question Q2.
Below is the same example report, but downloaded as an Excel export.
Comments
0 comments
Please sign in to leave a comment.