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 export checkbox field with multiple options to separate columns in an Excel report?

    Asked by tracyalexander on April 25, 2016 at 05:26 PM

    Hi

     

    I cant get this to work as when I pull it into excel there is nothing between the end of one entry and the start of another so how do I get excel to see that there is actually 2 entries in this colum

    excel checkbox text to column split column excel column
  • Profile Image
    JotForm Support

    Answered by jonathan on April 25, 2016 at 09:06 PM

    I assume you were doing this on your form http://www.jotformeu.com/form/60675308484361

    I cloned your form and made a test submission data on my end to test the conversion to column of the Checkboxes data.

    #1 My test submission data

     

    #2 When you download the Excel data of submission, you can see in the Excel data that the delimiter being used by consecutive data on Checkboxes is a carriage return (Enter) key.

     

    #3 Now to separate the Checkbox data into separate column (using Excel Text-To-Column), simply indicate in the "Other" delimiter the carriage return key.  See image below for guidance.

     

    The separation of the Checkbox data into separate column in Excel can be achieve this way.

    Hope this help. Let us know if you need further assistance.

  • Profile Image

    Answered by tracyalexander on April 26, 2016 at 12:39 AM

    Hi

    Apologies I was not clear.

    It is when the information is in one colum for the configurable list widget.  There is no character between the end of the first entry and the beginning of the second entry so I can separate them out using in excel.  You will see in my screen print 64654Class No: 8

     

    64654 is from entry 1

    Class No: 8 is the start of entry 2

     

    Please help

    Thanks

  • Profile Image
    JotForm Support

    Answered by beril on April 26, 2016 at 07:33 AM

    Thank you for providing additional details. You can separate them by double clicking on it. At that situation, there will be a line break as you see below:

    If you have any question or issues, please do not hesitate contacting us. We will be glad to assist you.

  • Profile Image

    Answered by Jeeshi  on April 26, 2016 at 07:43 AM

    Thank for knowledgeable information and jot form in support from checkbox and check the index. The check box content is align the documents in jot forms.

     

    Thank you!

     

    <atarget="_blank" href="http://www.thinkittraining.in/software-testing-training" rel="nofollow"> Software Testing Training in Chennai </a>

     

  • Profile Image
    JotForm Support

    Answered by beril on April 26, 2016 at 09:03 AM

    You're most welcome.=)

     Jotform in support from checkbox and check the index. The check box content is align the documents in jot forms.

    I am not sure that I understand your concern correctly. Could you please provide us more details of your concern? At that time, we can assist more properly. We'll wait for your response.

    Thank you.