JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Checkboxes Excel report output into mutlple columnsAsked 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.
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.
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.
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.