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

    Check box to excel issue

    Asked by kffdn on November 05, 2014 at 12:33 PM

    When I have multiple check boxes to answer 1 question, when I export to excel all the answers (the boxes that were checked) are pushed together with no delimiter all in one column.  Is there a way to have each checked box appear in it's own column or to have a delimiter placed between values in the one column?

    Ex:

    What options?

    A.

    B.

    C.

    D.

     

    If they choose A,C and D, the value in the excel column 'what options' is ACD.  and I need to count the number or AS, Bs, etc in the whole worksheet.

     

    Thanks for any advice!

    excel check checked
  • Profile Image

    Answered by Ben on November 05, 2014 at 01:04 PM

    Hi,

    I would recommend using Grid Listing report: How to create a Grid Listing report

    It should be showing the values differently for you.

    Could you please also tell us which jotform is this happening on please since I see that you have over 60 of them?

    Also can you please tell us a few more details, such as should they only choose one option or several of them and if you use these values somewhere in the jotform?

    Best Regards,
    Ben