Change delimiter checkboxes Google Forms

Question

I need to change the delimiter when getting responses from a Checkbox-question when using Google Forms.

I'm writing the values in a google doc, but I need to be able to split the answers.

Simply replacing all comma's doesn't work, because there are comma's in the answers.

Anyone an idea?

Answer 1

Recently had a similar problem, I'll reply in case anyone ends up here (like I did). When exporting Forms responses to a Spreadsheet, the separator is a comma (which is a problem if you have commas in the checkboxes values).

But if instead you use the option "Download responses (.csv)" 9which is right beside the export to spreadsheet button), the resulting CSV has all values quoted, and uses a semicolon for separating within the checkbox column.

Answer 2

Seems like there is no way to change the delimiter: https://productforums.google.com/forum/#!topic/docs/h0fopNaKqzM

You may want to add a dot / double spaces to the end of each box's value, so that you can separate using that.

Let me know if you need another solution.