CSV individual answers |

|
Using the individual answers export each answer inside a question will have its own column. Selection type answers which have been answered will be marked in the respondent's row using the Answer selection mark, all selection answers that have not been selected will be marked by the Answer unselected mark. Field based types will ouput directly the respondent text entry of the field.
Data Export
- Export Encoding is the format in which the file will be saved. If we are using a multi-language we strongly suggest to use UTF-8 as this will allow us to see entries written in any language.
- Respondent Export Filter is the filter that will be applied to respondents. We can create a filter using the report filter creator.
- Export Answers we can either export all answers from the survey or a sub-set of answers we select.
- Export From / To Date is the date interval from which we want to export respondents.
- Include Security Addin Data do we include activated security add in data. E.g: The token security add in will generate extra data in the export to export the token information.
Export Formatting
- Columns Header Template allows us to format as we need the header column . {0} will be replaced by the answer text or id or display order and {1} will be replaced by the question text or id or display order. Note that both are optional and that you can format them in any custom string you like.
- Column Header Output will define what values to use to replace the {0} / {1} inside the header template column .
- Answer Selection Mark is the value that will be shown in each row where a respondent has answered to an answer. Note that field type answers will show what the respondent entered in the field.
- Answer Unselected Mark is the value that will be shown in each row where a respondent has not answered to an answer. Note that field type answers will show what the respondent entered in the field.
- Field Delimiter is the char that will act as a delimiter between the exported answers columns inside a CSV.
- Text Delimiter is the char that will act as a delimiter between the text entries inside a CSV.
- Replace CR is the char that will replace "new line" character. Some tools like Excel or Access might encounter problems with "new line" characters inside a row. We suggest replacing it with a custom char before replacing it again after having imported the data inside the target tool.
- Use Reporting Aliases we can export the column names using the reporting aliases instead of using the full answers / questions label text.
Data Output Example
In order to better understand we have compiled a few example of questions and how their output is organized
.