After clicking the Download raw data button in the analysis overview, the Download screen appears allowing you to configure the raw data download before exporting the raw survey data.
- The survey language used to draw up the questions and answers. You can only select a language in this field, if the survey has been conducted in more than one language.
- The interview status
If, for example, you select Completed, only the results of the surveys that have been closed by the participants will be included in the export file. Unfinished surveys and surveys that have led to a screenout by a participant, are not included in this case. - The file format
The raw data can be downloaded in 2 formats: Excel or SPSS (see below).
When selecting Excel, you can also specify whether the raw data should be downloaded with:
- variables and values. The following data will then for example be displayed in the downloaded Excel file:
- the variable screen codes which have been defined for all questions
- a variable value indicating whether a specific answer option has been selected (= 1) or not (= 0)
- the numerical values selected by participants and assigned to the various answer options of a question (e.g. 3 = the colour Blue)
- the numerical values specified by the participants which must lie between 18 and 99 (here: age)
- question text and answer option labels. The following data will then for example be displayed in the downloaded Excel file:
- the question texts which have been formulated for all survey questions and sub-questions
- a variable description indicating whether a specific answer option has been selected (= checked) or not (= unchecked)
- the answer options of a survey question selected by the participants (e.g. the colour Blue)
- the numerical values specified by the participants which must lie between 18 and 99
Note: For answers to open questions, the selected option (with variables and values OR with question text and answer option labels) does not play any role. Numbers such as age, e-mail addresses, dates, etc. are displayed identically for both.
Worksheets
The Excel file contains 3 worksheets:
- Interviews
This worksheet displays all data from the survey (each variable in a column and each questionnaire in a row). - Code Plan
This worksheet contains the structure of the survey. For each column, the following data are listed: variable name or value, data type, question variable, question element (e.g. Multiple Choice), question text, row text, choice/column text and the different values and labels.
The variable name in column A of this worksheet (from top to bottom) is displayed in the same order (from left to right) in row 1 of the Interviews worksheet. Thus, you can use this second worksheet to search for the question and answer which correspond to the value in the Interviews worksheet. - Filters
This worksheet lists the filters used to export the data.
The raw data file for the SPSS statistics software package is fully labelled. This implies that the question text and the labels of the choices are extracted directly from the survey, within the data structure.
There are different reasons why a respondent doesn’t answer a question. The following table illustrates the various representations of missings depending on the output format:
| Respondent saw question but did not respond | Respondent saw question and chose N/A option | Respondent didn’t see question because of filter condition | Respondent didn’t see question because of interview drop out | |
|---|---|---|---|---|
| Condition | If question is NOT mandatory | If N/A is selected as a choice option when creating a survey | ||
| MS Excel | Empty cell | #N/A | Empty cell | Empty cell |
| SPSS | Empty cell (system missing) | 9999999 (user missing) | 8888888 (user missing) | Empty cell (system missing) |
| API | Null | 9999999 | 8888888 | Not present |