When you have a form with a multiple choice question that has more than one answer selected, the answers are displayed in the same cell, separated by commas.

When you export all your results as an Excel file or CSV file, your results will also be in the same row and column, like this:

If you’d like the answers to be divided into separate columns, here’s how to do this using Google Sheets and Excel:

Google Sheets

See this Google help article for more information.

Excel

See the instructions for excel here.

Did this answer your question?