What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Checkbox Field: On Excel Report, show each check option in a separate column

    Asked by GuyPalinckxLS on September 26, 2016 at 07:32 AM

    Hi,

     

    When I use a question with a checkbox (multiple answers are possible) I found the data in excel in 1 cell.

    e.g.  when I have an option "Monday", "Tuesday", "Wednesday", "Thursday", "Friday" and I choose for Monday and Thursday, in my report, it' says MondayThursday in 1 cell.

    Sometimes I need to filter this but like this, it's very hard.

     

    Is there another solution for separation of data?

     

    Thanks in advance

     

    Guy

    checkbox excel multiple answers thanks
  • Profile Image

    Answered by kate on September 26, 2016 at 09:41 AM

    To create a separation of data, first,  create a different checkbox field for each option, as you see below:

     

    Here is the result:

     

    Please give this a try and if you have any questions please let me know.