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

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,

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.

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.

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.

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.

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.