3

This question already has an answer here:

I have a form, a Google form, and I'd like to post the user's responses to a specific sheet in the Google spreadsheet. Is this possible?

marked as duplicate by Rubén, serenesat, jonsca Jan 30 at 23:10

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • Do you mean that responses by different users should go to different sheets? Or that responses by one particular user should to a separate sheet? Or that all responses should to go some sheet other than the one that the form created? Please clarify. Meanwhile, the questions listed here may already have an answer. – user79865 Jul 7 '15 at 6:39
  • I meant that all responses should go to one sheet other than the one the form originally created. I took a look at the link provided but did not see a match to my question/issue. Thank you. – フレヂィ Jul 7 '15 at 7:00
  • I think I found the answer here – フレヂィ Jul 7 '15 at 7:04
  • That answer I linked above helped, although, it still doesn't explain how to put the responses in a specific sheet, the example above would still add the responses to the first sheet created. – フレヂィ Jul 7 '15 at 7:23
3

Step 1: Open the form.

Step 2: Click on "Responses" from toolbar.

Step 3: Click on "Change response destination".

Step 4: If you want to save responses in existing spreadsheet with a new sheet, choose "New sheet in an existing spreadsheet" or if you want to save responses to a new spreadsheet choose "New Spreadsheet" and "Type the name" for a new spreadsheet.


You're done now.

  • 1
    Question says "I'd like to post user's responses to a specific sheet"... this does not answer how that question, it answers a completely different question, "If you want to save responses in existing spreadsheet with a new sheet". I don't want to save to a new sheet, I want to save to an existing one! – Michael May 17 '18 at 22:33
  • @Michael You can also select existing sheet in a spreadsheet by following the same instructions. – Umar Ahsan May 18 '18 at 9:27
  • 2
    @UmarAhsan Sorry, the terminology "sheet" is somewhat overloaded here, as it both refers to the whole spreadsheet itself, which is what you are indicating, and to individual sheets in the spreadsheet. When I select an existing spreadsheet it creates a new sheet in that spreadsheet and I'm looking for a way to instead use an already existing sheet in the spreadsheet I select. – Michael May 18 '18 at 17:02

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