Is it possible to split data from the configurable list?

  • mz.maclay
    Asked on August 8, 2019 at 5:45 PM

    Is it possible to export the results from the configurable list so that each field shows up as a separate column and each entry a new row? I want my users to fill out this form once, but I need to have that data separated out while the form is live so I can compare and find results.

  • John Support Team Lead
    Replied on August 8, 2019 at 6:33 PM

    Currently, there is no option to separate the values entered in a configurable list widget when being viewed in the Submissions Page or exported to an Excel file. But, you can try these two workarounds below:

    1. If you use our Grid Report, the information will be separated by columns.

    Is it possible to split data from the configurable list? Image 10

    2. You can split the data manually with the help of Text-to-column feature of Microsoft Excel.

    This guide will help you: 

    https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7

    You can use commas as a separator to make columns within Excel.

    Go to the Data tab and select text to columns under data tools then select delimiters and hit next. Then select comma as the delimiter and hit the finish.

    Please try that and let us know how it goes.


  • TuckCE
    Replied on August 19, 2019 at 1:49 PM

    Hi, this is not working as most of the data selected has no spaces between or the conversion is only selecting the first response. Is there another alternative because separating out the selections is key for data analysis.

    Thanks!

  • John Support Team Lead
    Replied on August 19, 2019 at 2:01 PM

    Hi @TuckCE,

    Could you please provide us a link to the form you're working with? In that way, we could check for possible workaround specific to your forms.

  • TuckCE
    Replied on August 19, 2019 at 2:20 PM