When selecting the Microsoft Excel export format, you can select an earlier Excel version if you don't have Microsoft Excel 2007 or later. However, please note that the Excel 2003 format may be discontinued in the near future.
Each section is exported as a separate worksheet. The first 3 columns of each file/worksheet contain key metadata about the submission:
- [Submission Id] – a system generated identifier which is unique to that submission.
- [Fieldworker Name] – the name of the fieldworker who uploaded the submission (based on who was assigned the handset at the time).
- [Fieldworker Id] – a system generated identifier which is unique to that fieldworker. Two fieldworkers with the same name will still have unique identifiers.
If you need to, you can specify one or more fields to appear in every worksheet by using column fixing on the Grid tab.
For repeating sections there are additional columns in the relevant worksheet:
- [Repeats On Question] – the name of the field on which the section repeats. If the section is not repeated, this will be displayed as “N/A”.
- [Repeat Question Value] – the value which was captured for the field on which the section repeats. This is the number of times the section was repeated for a particular submission. It is thus the number of rows which will be generated for that submission in that particular section.
- [Repeating Index] – indicates the repeat number of the row in question. This value is zero-based, i.e. the first repeat is 0, the second is 1 and so on.
Multi-select option naming
There are 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 options'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".
Apart from the actual response data worksheets, each export includes a number of additional worksheets:
- The “Submissions” worksheet contains a summary of all submissions which are included in the export. Only metadata is included.
- The “Codebook” worksheet lists every field used in the form. Each field receives a unique ID from the system. For select-type field, each option is also listed along with its associated value.
- For reference purposes, a “Questions” worksheet is generated which lists each field contained in the form, the field's system-assigned ID, and the text displayed and the field type.
- A “Raw Data” worksheet is produced which is useful for importing the response data into other databases or performing other types of transformations.