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

  • mohammadaslam
    Asked on August 8, 2020 at 10:00 AM

    how the answer or output look like in excel?

  • Vanessa_T
    Replied on August 8, 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:

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

    Excel:

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

  • capability.development2
    Replied 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

  • roneet
    Replied on August 20, 2020 at 2: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.

    How the configurable list answer or output look like in excel? Image 1 Screenshot 20

    Another alternative would be to use the Input table field:

    1536040096Screen Shot 2018 09 04 at 7 Screenshot 31

    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!