How to split the output of Infinite Widget into multiple columns in Excel

  • lcmg
    Asked on March 30, 2015 at 8: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)?

  • Ben
    Replied 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