Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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 have four surveys (google forms) from which I want responses to go to a single response spreadsheet (each on a different sheet). It appears in the form view that I can select to have the response go to a new sheet in an existing spreadsheet, but when I select that option on the second form, I get a message saying that the spreadsheet is already in use. How do I get this feature to work properly? I want all the pre- and post- survey data in one single spreadsheet!!

share|improve this question

Maybe this has changed in new Google Sheets because in the second and subsequent Forms it seems possible to select Responses, Choose response destination:

WA41689 first example

New sheet in an existing spreadsheet..., Choose:

WA41689 second example

find the Response Sheet for the first Form, Select and for this to work.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.