Tech is Easy logoTech is Easy

How to Link Google Forms to Google Sheets (Live Responses)

Updated Nov 14, 2026Time needed: 1 minuteComputer (Google Forms in a browser)

To link Google Forms to Google Sheets, open your form, click the Responses tab, click Link to Sheets, then choose Create a new spreadsheet (or Select existing spreadsheet) and click Create. This connects your form responses to a sheet that updates on its own. Handy for sign-ups, orders or surveys you want in a sortable table.

How to Link Google Forms to Google Sheets (Live Responses) video

Before you start

Google's own help page, Choose where to save form responses, covers the same options plus how to unlink a sheet, which we explain below.

1Open the Responses tab

Open the form whose responses you want to connect and click Responses, the second tab at the top.

Google Forms Responses tab showing 2 responses and the Link to Sheets button

2Click Link to Sheets

At the top right of the responses card, click Link to Sheets.

Link to Sheets button in Google Forms with the Sends responses to a spreadsheet tooltip

3Choose a new or existing spreadsheet

The Select destination for responses window gives you two options: - Create a new spreadsheet makes a fresh Google Sheet just for this form. - Select existing spreadsheet lets you pick a sheet you already have. Google adds a new tab to that spreadsheet and puts all the responses there.

Select destination for responses window with Create a new spreadsheet and Select existing spreadsheet options

4Name the sheet and click Create

If you are creating a new spreadsheet, type a name for it in the box next to that option. Then click Create.

New spreadsheet renamed in the Select destination for responses window, ready to click Create

5Check your linked spreadsheet

The new sheet opens with a table of all your responses, one row per person and one column per question. The link is live, so every new form submission is added as a new row automatically.

Google Sheets table with linked Google Form responses in columns

Tips / troubleshooting

Working with the responses in Sheets

The first column is a Timestamp showing when each person submitted the form, followed by one column per question in the order they appear in the form. Google Sheets puts the data in a table, so you can sort and filter it straight away.

A few habits keep the sheet tidy as more answers arrive: - If you add a question to the form later, Google adds a new column for it. Older rows simply stay blank in that column. - Put formulas, charts and summaries on a separate tab of the same spreadsheet. New responses are added as rows on the responses tab, so keeping your own work elsewhere means nothing gets overwritten. - Use filter views instead of deleting rows when you only want to hide some answers. Everyone else working in the sheet still sees the full list.

How to unlink the spreadsheet

If you no longer want answers going to the sheet, open the form, click Responses, click the More (three dots) icon at the top right and choose Unlink form, then confirm with Unlink. New responses stop going to the spreadsheet, but everything already in it stays. The form keeps collecting answers as usual, and you can reconnect a sheet at any time.

The form and the spreadsheet are separate files. Deleting the spreadsheet does not delete the form or its responses, and deleting the form does not delete the spreadsheet.

FAQ

How do I connect Google Form responses to an existing Google Sheet?

Click Link to Sheets on the Responses tab and choose Select existing spreadsheet. Google creates a new tab inside that spreadsheet and fills it with your responses.

Do new responses show up in Google Sheets automatically?

Yes. The table is live, so every time someone submits the form their answers appear in a new row without you doing anything.

Can I export responses that came in before I linked the sheet?

Yes. When you create the link, all the responses you have already received are added to the sheet, and new ones follow as they come in.

How do I stop Google Forms from sending responses to a sheet?

On the Responses tab, click the More (three dots) icon and choose Unlink form, then Unlink. The data already in the sheet stays, and new answers only stay in the form.

Who can see the linked spreadsheet?

You, plus anyone who was a collaborator on the form when you created the sheet. People who fill out the form cannot see it unless you share the sheet with them.