Checkboxes Excel report output into mutlple columns

  • annhall
    Asked on April 7, 2015 at 5: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.

    Jotform Thread 547950 Screenshot
  • jonathan
    Replied on April 7, 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.

     

     

     

     

  • exchangepress
    Replied on June 29, 2015 at 1: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.

  • Aurora JotForm Support
    Replied on June 29, 2015 at 2: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.