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

    Can you change the data format to have the entries go to unique cells when exported to EXCEL?

    Asked by DennisWoodard on July 20, 2015 at 04:39 PM

    TAMPA BAY RAYS

    TAMPA FL U5GE015362
          U5GE015363
          U5GE015364
          U5GE015365


    desired:

    TAMPA BAY RAYS TAMPA FL U5GE015362
    TAMPA BAY RAYS TAMPA FL U5GE015363
    TAMPA BAY RAYS TAMPA FL U5GE015364
    TAMPA BAY RAYS TAMPA FL U5GE015365

    or:

    TAMPA BAY RAYS TAMPA FL U5GE015362 U5GE015363 U5GE015364 U5GE015365
  • Profile Image
    JotForm Support

    Answered by jonathan on July 20, 2015 at 05:39 PM

    You must be using a field or widget on the form that allows multiple entries.

    Example, Checkboxes, Radio options, Matrix table...

    Just like in your jotform http://www.jotform.us/form/51826032506146

     

    If you view the submission data you will see that it will only have 1 column/field. This will be also the same once you get the Excel output/download of the submission data.

    If you want them to be in separate column/cell, then you must create a separate field/question for them. This way the resulting submission data will also have its own column/cell for each field/question separately.

     

    There is a workaround though for Excel output.

    You can use the TEXT-to-Column function in Excel Application. 

    link: https://support.microsoft.com/en-us/kb/214261

     

    Hope this help. Let us know if there is more we can assist you with.

    Thanks.