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

    Excel and CSV exported submissions - answers going to same column

    Asked by yanaluae on August 28, 2015 at 11:52 AM
    3. For fields where multiple check-boxes are selected - each checkbox should be a separate export column upon export rather than one column with the fields separated by ';' (semi-colons). This would make data analysis upon export much simpler.
  • Profile Image
    JotForm Support

    Answered by Boris on August 28, 2015 at 12:31 PM

    I am sorry if this may not look intuitive to your workflow, but such an implementation would unfortunately be incompatible with third-party services and integrations, such as the Google Spreadsheet integration as an example, and would pose significant difficulties for many common tasks.

    The reason is that for programmatic data manipulation, field columns and their headers should remain consistent. If we were inserting new columns in the spreadsheet for each of the multiple answers that are selected to a single question, that would make the spreadsheet columns variable and unpredictable, preventing many functions that depend on having solid position of data (such as formulas depending that answers to specific questions are in column D for example, or Import Range functions for importing data from one spreadsheet into another).

    For this reason, answers to a single field/question always go to one column. If you wish to split data from one column to multiple columns, you can create empty columns after the initial column, and use the Text To Columns function:


    I hope this helps. Please let us know if you need further assistance.