Connect your form to a sheet in three clicks

When you create a Google Form, you can send responses directly to a Google Sheet without any extra setup or coding. Google does this automatically — you just need to tell the form where to send the data. The moment someone submits your form, their answers appear as a new row in the sheet.

The connection happens during form creation, but you can also set it up afterward if you forgot. Either way, the process takes less than a minute and requires only that you have a Google account and edit access to both the form and the sheet.

Key Takeaways

  • Google Forms can send responses to a new sheet or an existing sheet, and you choose which one during or after form creation.
  • Each response becomes a single row in the sheet, with each question answer in its own column.
  • Once connected, responses arrive in the sheet automatically — you do not need to read or transfer anything manually.
  • You can disconnect a form from a sheet at any time, and the sheet will keep all the data already collected.

Connect a form to a new sheet during creation

Start in Google Forms and create your form as usual. Add your questions, set the question types (multiple choice, short answer, rating scale, and so on), and arrange them in the order you want. You do not need to finish the entire form before connecting it to a sheet — you can do this at any point.

Once you have at least one question in your form, click the Responses tab at the top of the form editor. You will see a summary of responses (currently empty) and a green spreadsheet icon. Click that icon. Google Forms will ask whether you want to create a new sheet or use an existing one. Choose Create a new spreadsheet. Name the sheet if you want, or accept the default name (which includes your form title and the date). Click Create.

Google Forms now has a sheet waiting for your responses. You can close this dialog and keep building your form. The connection is complete — you do not need to do anything else.

Connect a form to an existing sheet

If you already have a Google Sheet where you want responses to land, or if you forgot to connect during creation, you can link them now. Open your Google Form and click the Responses tab. Click the green spreadsheet icon again. This time, choose Select existing spreadsheet.

A dialog will appear asking you to pick a spreadsheet. If the sheet is in your Google Drive, you can search for it by name or scroll through your recent files. Click the sheet you want. Google Forms will then ask which tab (worksheet) within that sheet should receive the responses. If your sheet has only one tab, it will be selected automatically. If you have multiple tabs, pick the one where you want the data to go. Click Select.

Google Forms will add a header row to your chosen sheet with the name of each question. The next response will start on row 2. If the sheet already has data in it, Google Forms will add the headers and responses below whatever is already there — it will not overwrite existing content.

What happens when someone submits the form

Each time someone fills out your form and clicks Submit, their answers appear as a new row in your connected sheet. The first column shows a timestamp (the date and time they submitted). The remaining columns show their answer to each question in the order the questions appear in your form.

If a question is multiple choice or a dropdown, the sheet shows the exact answer they selected. If it is a short answer or paragraph text, the sheet shows what they typed. If it is a rating scale, the sheet shows the number they chose. If someone skips a question, that cell in the sheet stays blank.

The data arrives in the sheet within seconds of submission. You do not need to refresh the page — if you have the sheet open, you may see the new row appear on its own. If you are not watching, the row will be there the next time you open the sheet.

Disconnect a form from a sheet

If you no longer want responses going to a particular sheet, you can break the connection. Open your Google Form and click the Responses tab. Click the green spreadsheet icon. A menu will appear showing the sheet the form is currently connected to. Click the three-dot menu icon next to the sheet name and select Unlink form.

Google Forms will ask you to confirm. Click Unlink. The form is now disconnected from that sheet. All the data already in the sheet stays there — unlinking does not delete anything. If you want to send future responses somewhere else, you can connect the form to a different sheet using the same spreadsheet icon.

Organize your data after responses arrive

Once responses start coming in, you can treat the sheet like any other Google Sheet. You can sort responses by date, filter by a particular answer, add new columns with formulas, or create charts from the data. Google Forms creates the header row and adds new response rows, but everything else in the sheet is yours to edit.

If you add a new question to your form after responses have already arrived, Google Forms will add a new column to the sheet with that question's header. Responses submitted before you added the question will have a blank cell in that column. Responses submitted after will show the answer.

You can also manually add rows or edit existing responses directly in the sheet if you need to fix a typo or add information. Google Forms will not overwrite your manual changes — the sheet is yours to manage once the connection is set up.

Frequently Asked Questions

Can I connect one form to multiple sheets?

No. A Google Form can send responses to only one sheet at a time. If you need the same data in two places, you can copy the sheet after responses arrive, or you can use a tool outside Google Forms to duplicate the data. You can also disconnect the form from one sheet and reconnect it to another, but responses will only go to the currently connected sheet.

What if I delete the sheet the form is connected to?

If you delete the sheet, the form will no longer have anywhere to send responses. The next time someone submits the form, Google Forms will show an error. You can fix this by connecting the form to a different sheet using the Responses tab. The deleted sheet's data is gone unless you recover it from your trash within 30 days.

Can I see who submitted each response?

Only if you turn on response collection in your form settings. By default, Google Forms does not ask for email addresses or names. If you want to track who answered what, open your form's settings, find the "Responses" section, and turn on Collect email addresses. The next responses will include an email column in your sheet.

Do I need to give people permission to see the sheet?

No. The sheet does not need to be shared with anyone for the form to send data to it. People filling out your form do not see the sheet — they only see the form itself. You can keep the sheet private and share only the form link.