The download responses in csv file are messed up | Community
Skip to main content
Answered

The download responses in csv file are messed up

  • October 31, 2021
  • 3 replies
  • 213 views
S

I downloaded the responses in the csv file, but I see the multiple choice answers are on the first row as the questions. How I can solve this. Your help is appreciated. 

 

Thanks

Sophia 

Best answer by Liz

Hi @SophiaT Welcome to the community! The multiple choice answers will appear as their own separate rows in the exported files, so what you’re seeing is expected behavior. Then, if the respondent answered with one of those multiple choice options, you’ll see that in their response data. It isn’t possible to merge all of the multiple choice answers into one singular row at this time. 

I hope this helps clarify! Let me know if you think of any other questions. 

View original
    Gabi Amaral
    1 person likes this
    • Gabi Amaral
      Gabi Amaral

    3 replies

    Liz
    Community Team
    Forum|alt.badge.img+5
    • Liz
    • Tech Community Advocate
    • 14893 replies
    • Answer
    • November 1, 2021

    Hi @SophiaT Welcome to the community! The multiple choice answers will appear as their own separate rows in the exported files, so what you’re seeing is expected behavior. Then, if the respondent answered with one of those multiple choice options, you’ll see that in their response data. It isn’t possible to merge all of the multiple choice answers into one singular row at this time. 

    I hope this helps clarify! Let me know if you think of any other questions. 

    Life is a series of awkward moments separated by snacks.
    john.desborough
    P
    2 people like this
    • john.desborough
      john.desborough
    • P
      Paulo
    O
    • ohmygift
    • Explorer
    • 3 replies
    • August 19, 2022
    Liz wrote:

    Hi @SophiaT Welcome to the community! The multiple choice answers will appear as their own separate rows in the exported files, so what you’re seeing is expected behavior. Then, if the respondent answered with one of those multiple choice options, you’ll see that in their response data. It isn’t possible to merge all of the multiple choice answers into one singular row at this time. 

    I hope this helps clarify! Let me know if you think of any other questions. 

     

    Hey @Liz! 
    I think my question can be relevant to this thread. I have a multiple choice question, which create an array of answers in the results https://prnt.sc/ljW84bD0kfvs. Is there a way to have each answer in a separate ROW instead?

    At the end I am running an Alloy workflow, which takes the answer and ads them into a table:

    Person 1 - Urban Vitamin wireless ANC headphone - delivery address

    Person 1 - Kindle - - delivery address

     

    Thanks!

    Gabi Amaral
    T
    2 people like this
    • Gabi Amaral
      Gabi Amaral
    • T
      Taichivienna
    Liz
    Community Team
    Forum|alt.badge.img+5
    • Liz
    • Tech Community Advocate
    • 14893 replies
    • August 19, 2022

    Hi @ohmygift Thanks for stopping by! We don’t have any additional formatting options in the table view, but if you export the results, it should show each answer in a different column (but not in a row). 

    Life is a series of awkward moments separated by snacks.

    Reply


    Still need help?

    Don't be shy and ask the community.

    Ask your question here!
    Community T&Cs