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

  • Annparrish
    Asked on December 21, 2017 at 8: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!


  • BJoanna
    Replied on December 21, 2017 at 10:08 AM

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

    1513868294choose Screenshot 10

    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).