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

  • DennisWoodard
    Asked on July 20, 2015 at 4: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
  • jonathan
    Replied on July 20, 2015 at 5: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

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

     

    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.