Export results
The export function allows you to download data in a selected format. The system provides both aggregated data formats and row data (each response provided in a separate line).
In order to export survey results :
- Press
![[D]](/UserFiles/640d81fbf8d6/Image/ico_material/baseline_cloud_download_black_18dp.png)
Download button.
- Select the format for the data export.
You can download data in the following formats :
| Format | Min subscription plan | Comments |
|---|---|---|
| .csv | Starter | Comma Separated Values. Text file where values are separated with a comma or semicolon. |
| .xlsx | Advanced | MS Excel file (version 2007 and newer). |
| .por | Advanced | SPSS file. |
| .sav | Advanced | SPSS file. |
| .pptx | Professional | MS PowerPoint file. |
| Professional | PDF. |
NOTE. Export files are updated in real-time or in time intervals that depend on the report size :
report below 1000 responses - in a real-time
reports 1001 - 5000 responses - every 3 hours
reports 5001 - 50000 responses - every 6 hours
reports over 50001 responses - every 24 hours
MS Excel limitations
Old MS Excel versions can have problems with the import of long surveys. Excel 2003 and older versions have a limitation of 256 columns.
- Excel 97, 2000, 2003 (file extension .xls), 65.536 rows, 256 columns.
- Excel 2007, 2010 or later (file extension .xlsx), 1.048.576 rows, 16.384 columns.
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 are saving data each time respondent navigates to the next page. In the final report, you will see only fully completed surveys but on request, you can have also 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. |
To activate partial results on your data export please contact us.
Data export option will be different for each subscription plan.