Populate responses to a Google Form to an Existing Sheet

Is it possible to populate the responses from a Google Form to an existing Google Sheet? When I tried linking the sheet to the form, the responses enter on a new row and move everything down.

0 2 302
2 REPLIES 2

Hi, 

Here is how it should work 

- Open a form in Google Forms.
- In the top left under โ€œResponses,โ€ click Summary.
- In the top right, click More Select response destination.
- Choose an option:
Select existing spreadsheet: Choose from your existing spreadsheets in Google Sheets to store responses
- Click Create or Select.

Hi Sergio,

Thank you for your response. When I link the existing spreadsheet, it creates a new tab for the responses. I want the responses to file to the already existing information.

fairaweb_0-1701458884496.png

fairaweb_1-1701458922819.png

Is there a way to do this? I have a formula set up, but the system pushes it down one row and it doesn't file correctly.