The CSV format is widely supported and can be read by many spreadsheet applications such as Microsoft Excel, Numbers and Google Docs. Raw response data is exported into one or more CSV files. In addition to the raw response data, the form's code book, field reference list, and submission metadata are also exported into separate CSV files for interpreting and analysing the raw response data:

  • The “Submissions” file contains a summary of all submissions which are included in the export. Only metadata is included.
  • The “Codebook” file lists every field used in the form. Each field receives a unique ID from the system. For select-type fields, each option is also listed along with its associated value.
  • For reference purposes, a “Questions” file is generated which lists each field contained in the form, the field's system-assigned ID, the text displayed and the field type.


When selecting the CSV export format, you will be able to manage a few export options:



Repeating sections

You can choose how to handle repeating sections in your export:

  • By selecting "Export each section as a separate CSV file", a separate CSV file will be created for each section. These will all be zipped up into a single archive which you can extract after downloading.
  • By selecting "Export repeating sections as separate CSV files", all non-repeating sections will be merged into a single CSV file. Each repeating section will generate its own CSV file. All files will be zipped up into a single archive which you can extract after downloading. 
  • By selecting "Merge repeating sections as additional rows into a single CSV file", all sections will be merged into a single CSV file. A separate row will be generated for each iteration. For example, if there are two repeating sections in the survey, "Section A" and "Section B", and for a particular submission "Section A" repeats 3 times and "Section B" repeats 4 times, the file will contain 4 rows for the submission.
  • By selecting "Merge repeating sections as additional columns into a single CSV file", all sections will be merged into a single CSV file. For repeating sections, additional columns will be generated to accommodate the maximum number of repeats in the data and the column/variable headings will be suffixed with "_0", "_1", "_2" as needed to indicate each instance.


Multi-select option naming

There are also two options which can be used to determine the naming convention for multi-select field types. When exporting multi-select fields, a column/variable is generated for each available option which is then represented as "selected" (1) or "not selected" (0).


Assume you have a multi-select field "HOUSEHOLD_ITEMS" with 3 options: Television (value: TV), Radio (value: R) and Fridge (value: F):

  • By selecting "Append option values to question name", the column/variable names generated for each option will be labelled by appending the relevant option's value to the field name. E.g. "HOUSEHOLD_ITEMS_TV", "HOUSEHOLD_ITEMS_R", "HOUSEHOLD_ITEMS_F".
  • By selecting "Append option labels to question name", the column/variable names generated for each option will be labelled by appending the relevant option's label to the field name. E.g. "HOUSEHOLD_ITEMS_Television", "HOUSEHOLD_ITEMS_Radio", "HOUSEHOLD_ITEMS_Fridge".


Single-select option naming

There are also two options which can be used to determine the type of data exported for single-select field types. When exporting single-select fields, you can choose whether the selected option is exported using the label or value of the option.


Assume you have a single-select field "HOUSEHOLD_ITEMS" with 3 options: Television (value: TV), Radio (value: R) and Fridge (value: F):

  • By selecting "Use the selected question's label", the option's label will be exported. E.g. "Television" is exported if you selected "Television".
  • By selecting "Use the selected question's value", the option's value will be exported. E.g. "TV" is exported if you selected "Television".