How the configurable list answer or output look like in excel?

  • Profile Image
    mohammadaslam
    Asked on August 08, 2020 at 10:00 AM

    how the answer or output look like in excel?



    This is a re-post of a comment on How to Set Up the Configurable List Widget

  • Profile Image
    Vanessa_T
    Answered on August 08, 2020 at 10:40 AM

    The data is stored in one cell. Each column is comma separated, while the rows are added in a new line within the same cell.

    Below is an example of how it actually looks when exported to Excel.

    Form:

    159689756001238.jpg

    Excel:

    159689727501240.jpg

  • Profile Image
    capability.development2
    Answered on August 20, 2020 at 12:12 PM

    Sorry to jump in but how to split data row1col1, row1col2, row2col1, and row2col2 into 4 different cells? not in 1 cell. while using text to column, the result is Column1:row1col1... etc... (I only consider row1col1, row1col2,row2col1, and row2col2 in 4 different cells)

     

    Thank you

  • Profile Image
    roneet
    Answered on August 20, 2020 at 02:08 PM

    Unfortunately, it is not possible to segregate the data from the configurable list into different columns.

    You may also take a look at our Grid Report, the information will be separated by columns.



    Another alternative would be to use the Input table field:

    1536040096Screen Shot 2018-09-04 at 7.47

    Or, which will work best, to have all fields created with separate basic fields:

    Since only that will ensure that each field is exported to separate cells in Excel.

    Let us know if you have any further questions.

    Thank you!