Paperform logo
ProductTemplatesPricingResources
ProductTemplatesPricingResources
Sign inTry Free

In my submissions export, how do I split multiple question responses into separate columns?

Help Results & Sharing Submissions

Submissions

Can I capture info besides answers, like IP address or the device type?Can I disable storage of submissions on Paperform?Can I export to Excel?How are Drop-off questions calculated?How can I create a unique ID for a submission?How can I create a unique number for a submission?How can I restrict submissions to one per user?How can I search for a particular submission?How can I share form results and get my data to others?How can I tell where leads are coming from on my form? How do I change the order of date values that display on my reports and submission summaries?How do I delete submissions?In my submissions export, how do I split multiple question responses into separate columns?How do I view a submitter's uploaded files?How do I refund my customers from Paperform submissions?How do I view and share Partial Submissions?What action can I take to find duplicate submission entries?When exporting form's results to CSV file can I use a semicolon rather than a comma?Where is my submission data stored?Why am I losing partial submissions?Why is my respondent's signature image black?

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

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

Multiple responses populated in cells

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

You also have the option to select the separator type by commas, semi-colons, periods, and spaces.

Separator selection

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.

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