This is reached from Export data to CSV/Excel/TXT to set the type of output.
Notes for CL users.
CL variables are called entries in Companion.
CL Items in svars and mvars are called responses in Companion.
Type of file to produce
You can choose from:
•Spreadsheet (Excel)
•CSV file
•CSV display
•TXT (text)
CSV display does not create a new file; it displays the data list in a window. The file can be saved from there if needed.
The TXT output can be useful for checking data because all the output is visible because it is not restricted to column widths.
Each row in the output file will contain
You can choose from:
•All selected entries for one record
•One entry with values and text (many rows per record)
The first option is a normal data list and can be used to create a new CSV data file.
The second option cannot be used with TXT output because there are no columns in the output.
Add entry text
For normal data lists a second row can be added which contains the entry texts for each question.
For entry lists an extra column is added that shows the entry text.
For single and multi entries
For entries with a response list (CL svars and mvars) you can choose:
•Response as texts
•Responses as values
For multi entries
For multi-coded entries (CL mvars) you can choose:
•As a single column
•Every response in its own column
•As multiple columns (spread)
Be careful with the second option because entries with many responses will create a lot of columns
With the third option the data is scanned to see the maximum responses for a record. The first actual response for a record is put in the first column, the second actual response in the second column and so on.
Where more than one column is used the entry name is followed by an underscore and the column sequence number.