I need to create a Google form using Google Docs, for surveying purposes. Several of the questions I am incorporating in the form consist of multiple choices, which my colleague has listed down in an Excel spreadsheet.
As of now, the only way I know to put these choices into each question is cutting & pasting each one of them into the appropriate text box.
Is there a faster / more efficient way of doing this (maybe, using some script)?
(For example, something like copying from a spreadsheet column directly into the Google form creation interface)
Best Answer
In your spreadsheet copy the column of cells with your choices. (Don't copy the whole column.)
In the form's multiple choice question select "Option 1".
Paste in your cells. (CTRL-V or CMD-V on Mac)