How to make Excel data from Infinite list show in multiple columns instead in one cell?

  • bkbarnes
    Asked on July 18, 2016 at 4:32 PM

    I am using the Infinite List widget in a form called Sukkot 2016. When I download the excel report, all of the fields in the infinite list widget are in one field on the report. 

     

    Here are the options for my form:

    First name, last name, Gender, Age, Volunteer area(s).

    I need for each of these to be in their own excel column, for each member that get's added. Is there a way this can be done?

    Page URL: https://www.jotformpro.com/form/61957856094976?preview=true
  • Nik_C
    Replied on July 18, 2016 at 5:59 PM

    Unfortunately, it is just a limitation of the Excel. But there is a workaround for this.

    1. You can open your Excel file and select the cell where your infinite list data is.

    2. Click Data and then Text to Columns.

    How to make Excel data from Infinite list show in multiple columns instead in one cell? Image 1 Screenshot 40

    3. Make sure to select Delimited on next screen:

    How to make Excel data from Infinite list show in multiple columns instead in one cell? Image 2 Screenshot 51

    4. And for Delimiter choose Comma:

    How to make Excel data from Infinite list show in multiple columns instead in one cell? Image 3 Screenshot 62

    That should split your data into four columns.

    If you need further assistance please let us know, also you can check this article for more information.

    Thank you!

  • dmichaels
    Replied on April 24, 2017 at 3:51 PM

    I'm having a similar issue with the Infinite List widget. If we, for example, have 3 columns, Name, Phone, Email and the user enters 20 lines of data, it's pretty obvious that a report, whether it be Excel, CSV or whatever, should be formatted in such a manner that the names are in one column, the Phone numbers in another and the Email in a third.

    Similarly, the native JotForm Input Table has the same shortcoming.

    I feel like we've somehow missed the point in how data should be formatted in a usable manner.

    I should note that the E-mail message comes through looking just perfect. Rows and columns of data, laid out as we'd expect, with a column of names, a column of addresses, etc.

    Is there another tool that works as I've described?

    As I'm thinking about this, what I'm describing would break with the "One Form / One Record" model. Each form submitted would need to be appended to the previous results.

    As a temporary work-around, I've built a Excel worksheet that can transform the JotForm generated Excel report and move the columns around as needed, but it's clumsy and not terribly elegant.

    Any thoughts?

    Thanks,

    David

     

  • Nik_C
    Replied on April 24, 2017 at 5:16 PM

    @dmichaels,

    I opened a separate thread for you and we will attend it here: https://www.jotform.com/answers/1127555 shortly.

    Thank you!