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

    Checkboxes Excel report output into mutlple columns

    Asked by annhall on April 07, 2015 at 05:42 PM

    I've created a form that has several check boxes for answers, allowing people to click all that apply. How to I get a report of all submissions that enables the answers to be filtered in excel? Right now it lists each answer as one long answer versus their 4 or 5 selections, and then the filter doesn't work (see attached screenshot). Thank you for your help.

    Page URL:
    http://www.jotform.com//?formID=50777093619162

    Screenshot
    excel Submissions check all submissions
  • Profile Image
    JotForm Support

    Answered by jonathan on April 07, 2015 at 10:09 PM

    Unfortunately this is how the conversion of submissions to Excel works for Checkboxes/Radio button and Matrices.

    It converts a Checkbox field as a single column/header only in EXcel file even though the Checkbox have multiple option listed.

    If you require the Checkboxes options/lost to appear as separate column for each options, you will have to split the options/list into multiple Checkboxes on the form instead.

     Some users have success splitting the Checkboxes into multiple columns in Excel by using the function Text to Column tool of the Excel Application.

    Perhaps you can check this option also.

    Hope this help. Let us know how we can be of further assistance.

    Thanks.

     

     

     

     

  • Profile Image

    Answered by exchangepress on June 29, 2015 at 01:05 PM

    I would like to add my vote for this feature to be updated.  It is very difficult to work with data fields that aren't independent.  The suggestion of creating separate questions may sound good, but then much of the functionality that goes with a checkbox question is lost (ie - requiring minimum or maximum number of responses).  The data can be manipulated in Excel, but that can be very time consuming.  It would be significantly better if the data were exported with each option in its own column.

  • Profile Image
    JotForm Support

    Answered by Aury on June 29, 2015 at 02:06 PM

    As per your above request, I am forwarding this feature request to our next level so they will consider to implement said feature.

    Unfortunatelly I cannot give you an estimated window time as of when this cuold be implemented. We should put in contact with you as soon as we have updates on this matter.

    Thank you so much for your understanding.