Sign InGet Started Free
Back to All
improved

More data and control when exporting study results CSV

over 1 year ago by Nikhil Patel

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.

Completion

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.

Attributes

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.

Themes

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 2)
  • Multiple Choice Multiple Select: One column will be created for every choice, containing a 1 if the user selected that choice
  • Questions that contain themes: One column will be created for every theme, containing a 1 if 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).