More data and control when exporting study results CSV
We've made a number of improvements to increase the amount of data, as well as the control you have, when exporting your study's results as a CSV.
There is a new
completedAt column that records the timestamp that the user completed the study.
Secondary header row
The second row of all CSVs will now contain more information about the header columns. You can see the question text, choice text, or other relevant context all within the CSV — no need to swap back and forth between Sprig.
Previously, all attributes were combined into one column, which required some Excel magic to separate into their own columns. Now, attributes will be split out into their own column, and you can select which set of attributes you'd like included in the CSV.
Like attributes, themes were combined into one column. Now, themes will also be split out into their own columns, and you can select which questions' themes you'd like included in the CSV.
Values and labels
Depending on your preferred analysis workflow, you can select whether you'd like the data for responses as columns that contain values, labels, or both.
If you select labels:
- Multiple Choice Single Select: One column will contain the text of the user's choice
- Multiple Choice Multiple Select: One column will contain a comma-separate list of all choices selected by the user
- Questions that contain themes: One column will contain a comma-separated list of all themes present in the user's response
If you select values:
- Multiple Choice Single Select: One column will contain the numeric value of the user's choice (e.g. if the user selected the 2nd option, the column will contain
- Multiple Choice Multiple Select: One column will be created for every choice, containing a
1if the user selected that choice
- Questions that contain themes: One column will be created for every theme, containing a
1if the theme is present in the user's response
Other question types
Consent / Legal, Recorded Task, and Voice & Video questions will have their data broken out into separate columns (similar to the change made to attributes).