Below is a description of the exported values for different question types.
Text field: exports as the value entered directly in the field.
Canned response: exports as the response value associated with the response text.
Canned response with specify detail: exports with the specify text and the response value separated by a dash (e.g., 2 - two cups of coffee).
Multi-select responses: the response value for each response selected exports in an individual cell. The first value's header is the question ID. After the first value, each subsequent value's question ID header is followed by a dash and number. Each number iterates by the number of responses selected.
Calculated field: exports as the value resulting from the calculated field formula. If enabled, !WithErrors! will also be appended to the value if there were missing or blank responses returned by the question IDs in the formula.
VAS: exports the value indicated on the scale.
Multi-instance questions: each instance of a response exports in an individual cell. The first value's header is the question ID. After the first value, each subsequent value's question ID header is followed by an underscore and number. Each number iterates by the number of instances entered.
List generation: each response entered exports in the same cell, separated by a carriage return.
Comments