Export matrix table responses to Google Sheets | XM Community

Export matrix table responses to Google Sheets

  • 3 May 2022
  • 1 reply
  • 50 views

Userlevel 3
Badge +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

Userlevel 3
Badge +10

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