Multiple Choice: How to have the selected options in one cell when exporting to Excel?

  • Profile Image
    raceform
    Asked on November 15, 2017 at 08:07 AM

    I use the multiple form element to gather information on which rodeo event the person is in.  The downloaded Excel spreadsheet puts all the events into one cell.  Is there a way to have each event in a specific excel cell? 

    Rephrase of question:  Is there a way to have each selected multiple choice option go to a specific cell on your downloaded excel spreadsheet?

    As it is now, all the multiple choice selections go into one cell. 



  • Profile Image
    Kevin_G
    Answered on November 15, 2017 at 09:23 AM

    Unfortunately, it's not possible to have the selected options in different cells, you will need to split your options on different fields in order to have them displayed as you want. 

    I hope this helps.