Configurable List Widget: Separate data into each column in the downloaded Excel

  • Profile Image
    LEDAGrants
    Asked on June 10, 2020 at 03:14 PM

    Hi,

    We are currently testing our form and have run into a problem. One of our questions uses the "configurable list" widget, which when viewing submissions, leads to a serious issue which is that when we download the submissions in the excel format, the results from the configurable list are all put into one cell. Our application is going to be filled out  by thousands of people, which is why we would like to download the results in the excel format in order to view the submissions altogether, as opposed to having to download the pdf for each individual applicant. Is there any way to have the responses to this widget separated in the excel format?  

    Thanks

  • Profile Image
    EltonCris
    Answered on June 10, 2020 at 06:46 PM

    Unfortunately, the config list widget is configured to display in that format. Anyhow, I'll escalate this to our developers so this will be considered in the future updates.

    For now, you may consider this workaround to separate them into columns.

    1. In a column adjacent to the column with the configurable list data (e.g. G1 to G13), insert the following formula, let says in K1 (or any other free column).

    =SUBSTITUTE(A1,CHAR(10),"^")

    2. Copy this formula down to K13. This will copy the data in G1 through 13 into the corresponding cells in G.

    3. Now highlight the data in G1-G13 and copy the cells (ctrl+c), after that go to Edit --> Paste Special -> Values then OK or Paste Values. This pastes the actual values of the cell instead of its formula. Now you have a column of data with ^ substituted for every carriage return (end of line).

    4. Highlight G1-G13, then go to Data -> Text to Columns. When the Wizard comes up, select Delimited on the first screen and Other on the next screen. In the blank space next to Other, insert ^. Now go to Finish, and your config list data should be listed in separate columns. 

    Here's a visual guide (GIF):

    If you're stuck at some point or if you need further assistance, let us know.