Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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)

share|improve this question

1 Answer 1

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)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.