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

    Is there a way to manage Checkbox output?

    Asked by pbwithew on June 06, 2014 at 02:20 AM

    I am making a registration form for a retreat. I have a checkbox field asking users to indicate all the days they will be staying -- eg, Monday, Tuesday, Wednesday, Thursday, Friday. When I output the data into Excel, the data from this field comes concatenated in one cell. For example, MondayWednesdayFriday. I am finding it difficult in Excel to manipulate this text. It would be easier if the data were dumped into separate columns, or at least, if there were a comma or space between each day -- then I could manipulate them better in Excel. Any words of wisdom?

    Thanks,

    Peece

    checkbox registration form checkbox field excel
  • Profile Image
    JotForm Support

    Answered by EltonCris on June 06, 2014 at 05:51 AM

    Hi Peece,

    Here's a way on how to separate them per column using your Excel program, hopefully this workaround will help.

    http://www.jotform.com/answers/290516#290557

    Let us know if you need further assistance.

    Regards!