4

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?

4
  • 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.

3
  • 2
    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
  • 3
    @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.