Is there a way to get a individual items(camps) listed on an excel form?

  • Profile Image
    Asked on February 25, 2016 at 04:22 PM

    Last year we had individuals sign up for each camp on a seperate submission.  We were then able to have each camp listed individually on our excel form. These individuals then indicated they did not like the inconvenience of doing multiple submissions. This year we decided to list all camps on one submission form to make it more convenient for them. But now we are finding the camps are not listed individually on the excel spreadsheet, they all run together in the cell.

    Is there a way to have individuals still select camps on one form but have them individually listed on the excel spreadsheet so we can sort and find how many kids are signed up for what camp?


    Thanks for your help,


  • Profile Image
    Answered on February 25, 2016 at 04:46 PM

    Unfortunately, there is not option to separate the answers in your form, this is because all are answers of a same question, this is the reason why they are being saved on the same field. 

    If you would like to have each selected option in different cells in your spreadsheet, you will need to add each answer as a field, so for example, if for one question you have 10 answers, then you will need to split it in 10, so you will receive one selection in different cells.