Export results

The export function allows you to download data in a selected format. The system provides two types of reports : summary report – aggregated data formats, and detailed report (row data) – each response is presented in a separate line.

To export survey results :

Press Download button.
Select the format for the data export.
[Optionally] Go to the SETUP tab and select which columns will be exported and the coding standard.

You can download data in the following formats :

Format	Required subscription plan	Comments
.csv	Starter	Comma-Separated Values. Text file where values are separated with a comma.
.xlsx	Advanced	MS Excel file (for files below 1 M rows).
.sav	Advanced	IBM SPSS Statistics file.
.pptx	Professional	MS PowerPoint file.
.pdf	Professional	PDF (Portable Document Format).

Export file settings

Codes

Code	Description
-77	Code for seen but omitted questions.
-78	Code for not seen and omitted questions.
0	Code for empty values in multi-choice questions.

Report update time

Number of responses	Report update frequency
< 1000	in a real-time
< 5000	1 h
< 50000	3 h
> 50000	6 h

NOTE. Each zip exported from SurveyLab contains flattened files. It means that the file doesn’t contain ENTER characters, which may cause problems with proper data import into MS Excel or SPSS.

Depending on Account Settings, data in export files can have one of the following formats: DD-MM-YYYY, MM-DD-YYYY, YYYY-MM-DD, where DD – means day, MM – month, and YYYY – year.

Partial results

Partial results are results for the abandoned surveys. We save data each time a respondent navigates to the next page. In the final report, you will see only fully completed surveys. On request, you can also have access to partially completed surveys.

If you have partial results functionality activated, then in the raw data export folder, you will find four files instead of two. Two additional files contain partial data results for surveys that have not been finished.

Type	Description
report	Survey results data.
report compact	Survey results data. Single-choice questions are presented in a single column.
report partial	Partial survey results data.
report compact partial	Partial survey results data. Single-choice questions are presented in a single column.

NOTE. Partial results files are available only for the main survey report. To check the data for the selected collector, you need to filter the file.

Partial data functionality is available in the Enterprise plan.

NOTE. MS Excel has a limit of 1,048,576 rows by 16,384 columns. Files with more than 1 M responses are not available in Excel format. For more info, check Microsoft documentation.

Data export options are different for each subscription plan.