Split muliple choice fields into separate columns in Excel

  • ParallelEd
    Asked on June 19, 2020 at 3:22 PM

    Is there a way, when exporting data to an Excel report, that with a multiple choice question, each answer can go to a separate column on the exported spreadsheet?

  • John Support Team Lead
    Replied on June 19, 2020 at 4:47 PM

    The Multiple Choice field is considered as one field only. That's the reason why it is placed in one column of the Spreadsheet.

    To separate the options in different columns you can use the Text to column feature in MS Excel as a workaround: Distribute the contents of a cell into adjacent columns

    There's also a guide if you are using Google Sheets: How to Split Text into Columns in Google Sheets

    Another workaround is to separate each option of the Multiple Choice field into separate Multiple Choice fields. In that way, the data will be added into separate columns as well in the submission page.