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

    Google Spreadsheet: Separate each selected checkbox options into each column

    Asked by mijot on April 19, 2016 at 09:55 AM

    I ran into this old post by searching for a solution to the same problem. I will share my workaround to this issue and also kindly ask the amazing team of developers at JotForm to come up with a solution to this very annoying problem.

    I often use jotforms to collect study data. These studies always have multi-select questions. What I have done is create hidden field and conditional logic for each of the options on a multi-select question to be able to write them on separate cells in the spreadsheet.


    Please consider the request,


  • Profile Image
    JotForm Support

    Answered by EltonCris on April 19, 2016 at 10:06 AM

    Again, thank you for sharing your workaround. I have escalated this as a feature request. I can't promise you anything but rest assured once this is added on Google Spreadsheet Integration, we'll let you know via this thread. 

    Just to ensure that I have understood it correctly, this is the image I added on the request ticket.

    By the way, you might also want to consider the workaround I've shared on this thread about separating stack data in a single cell into different columns (applicable for downloaded form submissions).

  • Profile Image

    Answered by Tom  on July 31, 2016 at 04:26 PM

    I have a similar issue.  I have a scholarship application form with 20 scholarships.  Students choose a scholarship and fill out personal data.  I can allow them to check off multiple scholarships but their response shows up in one row and I cannot easily sort by scholarship.  If I limit them to only one scholarship choice per form, they are forced to retype all their personal information for every scholarship application.  Can this be avoided?

  • Profile Image
    JotForm Support

    Answered by BDAVID on July 31, 2016 at 06:18 PM

    @Tom, your inquiry will be addressed on the following thread: http://www.jotform.com/answers/894779-