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

  • Profile Image
    Asked on July 18, 2016 at 04: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?

  • Profile Image
    Answered on July 18, 2016 at 05: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.

    3. Make sure to select Delimited on next screen:

    4. And for Delimiter choose Comma:

    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!

  • Profile Image
    Answered on April 24, 2017 at 03: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?




  • Profile Image
    Answered on April 24, 2017 at 05:16 PM


    I opened a separate thread for you and we will attend it here: shortly.

    Thank you!