Export matrix table responses to Google Sheets | XM Community
Skip to main content

Export matrix table responses to Google Sheets

  • May 3, 2022
  • 1 reply
  • 97 views

JR33
QPN Level 2 ●●
Forum|alt.badge.img+10
  • QPN Level 2 ●●
  • 75 replies

I'm trying to export answers under Google Sheets through a Qualtrics workflow. I have a problem with a multiple choice matrix question. How to retrieve each choice in a single column like I can via manual export ? (by checking the box separate multiple answers into several columns)
${q://QID37/ChoiceGroup/SelectedAnswers/x10}
Is it possible to go further in this formula to display the answer for a single choice to the modality "x10".
Thank you

1 reply

JR33
QPN Level 2 ●●
Forum|alt.badge.img+10
  • Author
  • QPN Level 2 ●●
  • 75 replies
  • May 4, 2022

Capture.PNGfor info here is my matrix.
I therefore want to retrieve 27 independent results to assign them in my export to 27 different columns


Leave a Reply