How to link Google Forms to Google Sheets
Send Google Forms responses to a spreadsheet: open the Responses tab, click Link to Sheets, create a new spreadsheet, and open it from the form.
Quick answer
Open your form in Google Forms, switch to the Responses tab, and click Link to Sheets. In the Select destination for responses dialog, keep Create a new spreadsheet selected, name it, and click Create. Then click View in Sheets to open the linked spreadsheet that receives the form's answers.
Steps at a glance
- Open your form and go to the Responses tab
- Click Link to Sheets
- Choose Create a new spreadsheet
- Name the spreadsheet in Spreadsheet title
- Click Create
- Click View in Sheets to open it
Interactive demo
Summary
Linking a form to a spreadsheet sends its responses to a sheet you can sort, filter, and share. You set it up once from the Responses tab of the form.
Step-by-step guide
Step 1
Open the Responses tab
Open your form in the editor. Click the Responses tab at the top, next to Questions and Settings. This tab is where the form's answers are collected.
Step 2
Click Link to Sheets
On the Responses tab, click Link to Sheets. The button's description says it sends responses to a spreadsheet. A dialog titled Select destination for responses opens.
Step 3
Choose Create a new spreadsheet
In the dialog, keep Create a new spreadsheet selected. The Spreadsheet title field is filled in for you, and you can replace it with a name that fits the form. Select existing spreadsheet is the other option.
Step 4
Click Create
Click Create to confirm. The dialog closes and you stay on the Responses tab.
Step 5
Click View in Sheets
The Link to Sheets button now reads View in Sheets. Click it to open the linked spreadsheet.
Why this matters
You collect answers in a form but need to sort them, build a chart, or share them with a teammate who does not need form access. Linking the form to a spreadsheet gives you that working copy in a few clicks.
Frequently asked questions
Where is the Link to Sheets button?
It is on the Responses tab of your form, near the response count.
Can I rename the spreadsheet?
Yes. The dialog has a Spreadsheet title field that is filled in for you. Edit it before you click Create.
Related guides
Continue with more step-by-step guides for getting work done.
How to see Google Form responsesSee Google Form responses in three views: a summary chart, question by question, or one submission at a time, plus the Link to Sheets option.
How to share a Google FormPublish a Google Form and copy its responder link so anyone with the link can fill it in. Covers naming the form, publishing, and sharing the link.
How to add conditional logic in Google FormsLearn how to add conditional logic in Google Forms by splitting a form into sections and sending each multiple choice answer to its own section.
Create interactive demos like this one — free, no coding required.
Start for free →