CSV separate selection / fields |

|
Using the separate selections / fields export question will have its own column. Respondent's rows will contain the answer to the question being in the column. Field based type will be separated into the same number of columns as they are field based types in your questions.
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 Add in 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.
- Respondent Answers Output what value will be used in each respondent row's answer to show his selection type answers.
- Respondent Text Answers Output what value will be used in each respondent row's answer to show his field type answers.
- Export Following Answers we can either export all types of answers or select to export only selection or field based answers.
- Multiple Answers as this method shows the actual respondent answers in each question column we need a way to export also multiple choice questions. We can either choose to merge each respondent's answers from a multiple answer questions into a single column and separate each answer using a separator or we can choose to create a new column for each answer available in the multiple choice question.
If we create multiple columns each column will be formatted using the following format : question's text 1, question's text 2, question's text 3 etc .. until all question's answers have their own column.
- 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.
