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 split the output of Infinite Widget into multiple columns in Excel

    Asked by lcmg on March 30, 2015 at 08:43 AM

    I have 4 inputs in an infinite list.  Works beautifully in the submission.  However, when I need to download the submissions to excel, the infinite list is one string of text with the labels and data input.  IS there any way to download it so the data is treated as if it were separate lines so it goes into excel as separate columns (fields)?

  • Profile Image

    Answered by Ben on March 30, 2015 at 11:36 AM

    Unfortunately this is a limitation by Excel, but one that is easily fixed.

    To achieve this you should download and open your Excel file.

    Once you do this you can click on the Data Tab and select the text that you want to split (under Data Tools). Once you do that you should select the delimiter to split the values into new columns by and hit the Finish button.

    Once you do that it will split the data and show it in new columns.

    You can see a more in depth info here: Split text into different cells