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

    How to get checkboxes values in individual cells in Excel?

    Asked by digital_soul18 on November 21, 2012 at 02:40 AM

    Hello,

    I have tried making a checkbox in the form with two options say 'test1' and 'test2' but when I fill in this form and select both and then output the report in excel I notice that the the corresponding cell says just 'test1 test2' with both values merged into one cell.

    This is a major issue as I would like to run reports on how many reports filled 'test1' and which others filled 'test2' but since the field is concatenated in excel this becomes very difficult. Is there any way around this? ie. I would like to see 'test1' in one column and 'test2' in another column or in some way that I can easily get reports.

     

    Any suggestions? I'm still new to your platform!

    checkboxes excel Reports checkbox fill
  • Profile Image
    JotForm Support

    Answered by idarktech on November 21, 2012 at 04:04 AM

    Hi,

    That is how it works actually since the two options are on the same field. Columns are created by field question not by its options. This means, if you'd create two separate check box fields containing "test1" and the other one is "test2", they'll be generated with each column.

    Also, how about creating visual report, would this suffice your needs? How to create a Visual Reports with your Form Submissions

    Do let us know if you have further questions. Thanks!

  • Profile Image

    Answered by JoshAtJ on December 17, 2014 at 05:31 PM

    Hi, I just wanted to say that this is an amazing inadequacy, that we can't differentiate and tally checkbox selections from within a given question.

    Furthermore, now that our survey is complete, there's no way I can reconstruct the survey and make people take it again with a format that could handle this SIMPLE TABULATION ACTIVITY.

    My enthusiasm for JotForm is diminishing since you basically have forced me into a situation where I wasted a lot of peoples' time, because can't extract meaningful data from their responses.

    Thanks.

  • Profile Image

    Answered by KriyaYogaVienna on January 15, 2015 at 02:39 PM

    @JoshAtJ: you are right, that is a big disadvantage.

    But you can fix that in Excel.

    Add the amount of columns you need right to the column with the data

    Highlight that (ONE) column and click

    Data-->Text to column

    and choose the textoperator which separates the data. Then the data will devide into the new columns.

  • Profile Image
    JotForm Support

    Answered by KadeJM on January 15, 2015 at 03:52 PM

    I'm not sure if there was a follow-up response for your thread other than the split thread that was different as well as KriyaYogaVienna's response to agreeing on your complaint while providing an alternative method of doing so inside Excel.

    For the most part Excel is very customizable but I can understand how for some that might create double the work instead of keeping it simple. However, you are more than welcome to open up a new thread requesting a new feature or even an improvement suggestion to an existing feature as these sort of changes are based on demand, feasibility, and how beneficial they would be.