How can I have every answer exported to a multiple choice element in a different cell or column in my spreadsheet ?

  • aylin77
    Asked on November 10, 2018 at 1:37 PM

    Hello, in my survey  I have  a mutiple choice question ( people can pick several answers ) .

    However, when I export the results of my survey in xls or on google sheet, the different answers are all packed in one cell. Is there any way to have each answer in an individual cell on the spreadhseet?

    I know I can fix it on Excel (or google sheet) but it would be wonderful if Jotform could allow this option and save us  time:).

    Thank you very much for your help.


    Jotform Thread 1639126 Screenshot
  • DonaldHag
    Replied on November 10, 2018 at 7:37 PM

    Unfortunately, this is not possible. A workaround is to add each option on a separate multiple choice field and then we can provide you the required CSS to hide the labels and reduce the spacing between the options.

  • aylin77
    Replied on November 11, 2018 at 4:12 PM

    Hello thank you for the info.