How to Connect Google Forms to Google Sheets

Send every form response straight into a spreadsheet, live, so you can filter, chart, and analyze it. Here's how to link a form to a sheet, what the data looks like, and how to unlink.

By the Quiriz Team · Published July 25, 2026 · 3 min read

The quick version: in your form's Responses tab, click Link to Sheets, and create or pick a spreadsheet. Every submission then drops into the sheet as a new row. Details below.

Link the form to a sheet

Open your Google Form and click the Responses tab. Click Link to Sheets (the green Sheets icon), then choose Create a new spreadsheet or Select existing spreadsheet. Confirm, and the connection is live.

Where the data lands

Responses fill a tab called Form Responses 1 — a Timestamp column plus one column per question, one row per submission. New responses append to the bottom automatically, so the sheet is always current.

💡 Tip: pre-fill a form to speed responses. In the form's three-dot menu choose Get pre-filled link, fill the fields you want defaulted, and share that link — responders open the form with those answers already in.

Now you can work with it

Once it's in Sheets you can filter it, chart it, or summarize it with QUERY and COUNTIF.

Unlink

In the Responses tab, open the three-dot menu and choose Unlink form. Existing rows stay; new responses stop syncing.

💬 Skip the formula: once responses are in your sheet, ask about them in plain English — =QUIRIZ("how many responses picked each option, as a table", "table") — instead of building a summary by hand.

Turn form responses into answers

Quiriz reads your Google Sheets responses and answers questions about them in plain English with =QUIRIZ(). Free to start.

Try Quiriz free →

Frequently asked questions

How do I link Google Forms to Google Sheets?

Open the form, go to the Responses tab, click Link to Sheets (the green icon), and choose to create a new spreadsheet or use an existing one. Responses then populate that sheet automatically.

Where do Google Form responses go in the sheet?

They land on a tab named "Form Responses 1," one row per submission, with a Timestamp column plus one column per question. New responses append to the bottom in real time.

Can I connect a form to an existing spreadsheet?

Yes. In Responses > Link to Sheets, choose "Select existing spreadsheet" and pick the file. Sheets adds a new "Form Responses" tab to it.

How do I unlink a form from a sheet?

In the form's Responses tab, open the three-dot menu and choose "Unlink form." Existing responses stay in the sheet, but new ones stop syncing there.