---
title: Split multiple-question responses into separate columns | Paperform Help Center | Paperform
description: Multiple choice and dropdown questions that have multiple answers separate answers with commas when exported. Here's how you can split them out into separate columns.
url: "https://paperform.co/help/articles/how-to-split-multiple-question-responses-into-separate-columns"
type: static
generatedAt: "2026-04-04T00:42:02.198Z"
---

How do I split multiple question responses into separate columns?
### Submissions
        ![(iframe)](https://www.loom.com/embed/bb7a0c34f459405f8d1ff235c79fa926?hide_owner=true&hide_share=true&hide_title=true&hideEmbedTopBar=true)

When collecting responses with multiple answer selections, it helps to understand how the data appears in integrations, CSV exports, and the Submissions dashboard so you can easily analyze your results.

### How do multiple selection answers appear in the Submissions Dashboard?

When a question allows multiple answers—such as Rank, Multiple Choice, or Dropdown—the Submissions page displays the results in a single cell, separated by commas.

![Submissions page view](https://img.paperform.co/fetch/f_auto,w_1400/https://d3gw2uv1ch7vdq.cloudfront.net/img/submissions-page-view.png)

### How do multiple selection answers appear when I export my submissions?

When exporting the data to a CSV file, the responses are structured in two ways:

 - **All answers in one cell** — Reflects how they appear in the Submissions page. This format helps quickly review selections at a glance without needing to analyze separate columns.
 - **Each option as a separate column** — This format is useful for sorting, filtering, and performing calculations, such as counting how many times a specific option was chosen.

This dual structure makes it easy to process data for different types of reporting and analysis!

### Example of a Ranking Question Exported to CSV

![Rank question answers split into multiple columns](https://img.paperform.co/fetch/f_auto,w_1400/https://d3gw2uv1ch7vdq.cloudfront.net/img/csv-split-answers-into-columns.png)

In this example, the "Rank" question column contains all selected options in the order they were ranked. In addition, each option (e.g., Banana, Pineapple, etc.) also has its own column. The number in each row under these columns represents the assigned rank for that option.

### Example of a Multiple Choice Question Exported to CSV

![Multiple Choice question answers split into multiple columns](https://img.paperform.co/fetch/f_auto,w_1400/https://d3gw2uv1ch7vdq.cloudfront.net/img/csv-mc-split-answers-into-columns.png)

In this example, the "Multiple Choice" column displays all selected answers in a single cell, mirroring the Submissions page format. In addition, each individual choice (e.g., Carrot, Broccoli, etc.) has its own column; a value of 1 indicates the option was selected, while a 0 means it was not.

## How do multiple selection answers appear when you send the data through an integration like Google Sheets?

When you set up an integration such as [Google Sheets](https://paperform.co/help/articles/integrate-with-google-sheets/), multi-select answers will come through as a single cell.

![Multiple select answers mapped to Google Sheets.](https://img.paperform.co/fetch/f_auto,w_1400/https://d3gw2uv1ch7vdq.cloudfront.net/img/screen-shot-2023-01-20-at-10.39.47-am.png)

You can split the results by highlighting the cells you would like to separate, by clicking Data → then clicking on the Split text to columns option. This will automatically try to detect the items to be separated and move them to new columns.

![Split text to columns](https://img.paperform.co/fetch/f_auto,w_1400/https://d3gw2uv1ch7vdq.cloudfront.net/img/split-text-to-columns-highlight.png)

You also have the option to select the separator type by commas, semi-colons, periods, and spaces. See [this Google help article for more information](https://support.google.com/docs/answer/6325535?co=GENIE.Platform%3DDesktop&hl=en).

![Separator selection ](https://img.paperform.co/fetch/f_auto,w_1400/https://d3gw2uv1ch7vdq.cloudfront.net/img/separator-selection-highlight-screenshot.png)

### Related Articles
  [How can I share form results and get my data to others?  There are several features available to help you share your data with others by exporting, integrating, and printing results.](/help/articles/share-form-submissions/)
[Can I export to Excel?  We don't support exporting directly to Excel. However, you can export to CSV which is compatible with Excel, along with many other spreadsheet applications (Numbers, Google Sheets, etc).](/help/articles/export-to-excel/)
[When exporting form's results to CSV file can I use a semicolon rather than a comma?  Form results exported as a CSV file will need to use a comma in order to separate values. It is not possible to change this to a semicolon.](/help/articles/when-exporting-forms-results-to-csv-file-can-i-use-a-semicolon-rather-than-a-comma/)