How to display the submission data of the "Configurable List" widget in separate columns of excel spreadsheet?

  • Profile Image
    mohammadaslam
    Asked on August 08, 2020 at 01:28 AM

    I created the questions in Configurable List, but answer comes in single cell, How can we make separate answer as per the question.


    Kindly do the needful,

    regards,



    Screenshot
  • Profile Image
    Sam_G
    Answered on August 08, 2020 at 05:13 AM

    Hi Mohammadaslam,

    Thank you for contacting Support.

    Unfortunately, using a configurable list widget will only render a single column in the submissions.

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

    15968779108.9 config.png

    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 finish.

    15968779698.9 config2.png

    You can check this guide for more information:https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7?ui=en-us&rs=en-us&ad=us

    Hope this information helps.

    Let us know if you need further assistance.

  • Profile Image
    mohammadaslam
    Answered on August 08, 2020 at 06:28 AM

    Mam,

    In this single question, There are four option to give answer with add more row, As you know that in Configurable List, We can add more row if require. In this case, how can we separate it with column and row.

  • Profile Image
    gerardw
    Answered on August 08, 2020 at 07:57 AM

    Hello,

    It looks like you have removed the Configurable List widget in your form "202051831925045" and replaced that with the Input table. Is that correct?

    Please note that when you export submissions in excel, it will always display the data in separate columns for each column of the input table (i.e. all entries will be a separate cell shown in a single row).

    Unfortunately, it is not possible to show the data of input tables in separate rows of exported excel or excel reports. You would need to manually move them to separate rows.