Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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.