how to a get boxes to sort separately on excel sheet?

  • Profile Image
    Annparrish
    Asked on December 21, 2017 at 08:34 AM

    When parents place order for lunch, all the items appear in the same field when I export data.  How do I get each lunch item to be in a different field when I export to excel without having to have separate boxes for all the different lunch choices?


    Thank you!


  • Profile Image
    BJoanna
    Answered on December 21, 2017 at 10:08 AM

    I assume that your question is related to the fields 'Choose'.

    1513868294choose.JPG

    Unfortunately, it is not possible to separate the selected items inside of the Excel, because all items are options of the same fields and they will be shown inside of the same column inside of the Excel Spreadsheet. 

    You can only separate them manually by editing your spreadsheet. 

    The only other way is to edit your form and separate your items into multiple fields (one field for each item).