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

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

    Asked by bkbarnes 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?

    Page URL:
    https://www.jotformpro.com/form/61957856094976?preview=true

    infinite list list widget infinite list widget excel name first name all
  • Profile Image
    JotForm Support

    Answered by Nik_C 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!