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.
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?
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.
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.
I opened a separate thread for you and we will attend it here: https://www.jotform.com/answers/1127555 shortly.