How to connect Google Forms to Google Sheets
Step-by-step guide to connecting Google Forms responses to a Google Sheets spreadsheet, including creating a form directly from an existing sheet.

Quick answer
Open your Google Form, click the Responses tab, then select the green Link to Sheets button. Choose to create a new spreadsheet or link an existing one, and every form submission will automatically appear as a new row in that sheet, ready for sorting, filtering, and further analysis without manual exporting.
Steps at a glance
- Open your Google Form and click the Responses tab
- Click the green Link to Sheets button above the response summary
- Select create a new spreadsheet or use an existing one
- Click Create to generate the linked spreadsheet
- Confirm new submissions appear as rows automatically
- Optionally build a form directly from a spreadsheet instead
Interactive demo
Summary
Connecting Google Forms to Google Sheets sends every quiz, survey, or registration response straight into a spreadsheet as a new row. This removes the need to manually download or import response data and lets you use spreadsheet tools to sort, filter, and calculate results in real time.
Step-by-step guide
Step 1
Open your Google Form
Go to Google Forms and open the form whose responses you want to send to a spreadsheet. The form needs at least one question, because each question becomes a column in the spreadsheet.
Step 2
Click the Responses tab
At the top of the form editor, click Responses next to Questions and Settings. This tab shows a summary of submissions, with Summary, Question and Individual views.
Step 3
Select the green Sheets icon
On the Responses tab, click the green Link to Sheets button. A dialog titled 'Select destination for responses' appears with two options for where responses should be stored.
Step 4
Choose a new or existing spreadsheet
Select 'Create a new spreadsheet' to generate a fresh file named after your form, with '(Responses)' added to the name, or choose 'Select existing spreadsheet' to send responses into a file you already have. If you pick an existing sheet, you may want to first add a new sheet tab to keep form data separate from other content.
Step 5
Click Create to link the files
After choosing your destination, click Create. Google Sheets opens automatically in a new tab, showing a Timestamp column and a column for each of your form questions.
Step 6
Test the connection with a sample response
Submit a test response through your live form and check that it appears as a new row in the Form Responses 1 tab of the linked spreadsheet. Each submission is timestamped, making it easy to track when responses arrive.
Step 7
Analyze and visualize the data
Once responses are flowing into Sheets, use built-in tools to sort answers, filter by criteria, or build a summary. You can even create a chart directly from the response data to spot trends at a glance.
Why this matters
You're running a signup form or customer survey and need responses organized for quick calculations, charts, or sharing with teammates. Connecting Google Forms to Sheets saves you from manually copying data, letting you filter, sort, and analyze submissions the moment they arrive instead of downloading CSV files.
Frequently asked questions
Can I connect a form to a spreadsheet I already created?
Yes. In the Responses tab, click Link to Sheets and choose 'Select existing spreadsheet' instead of creating a new one, then pick the file from your Google Drive.
Do responses update automatically or do I need to import them?
Once linked, every new submission is added automatically as a new row. There's no manual import or export step needed, unlike working with downloaded CSV files.
Can I create a form starting from a spreadsheet instead?
Yes. Open a Google Sheet, click Tools in the menu bar, and choose Create a new form. Google creates a form linked to that spreadsheet.
Related guides
Continue with more step-by-step guides for getting work done.
How to add a new sheet in Google SheetsLearn how to add, rename, duplicate, and organize new sheets in Google Sheets on desktop and mobile, including shortcuts and templates.
How to filter data in Google SheetsLearn how to filter data in Google Sheets using column filters, filter by condition, and filter by values on the free plan.
Create and customize a chart in Google SheetsCreate a chart in Google Sheets with Insert > Chart, then customize titles, colors, legend, and labels in the Chart editor. Fixes for charts that plot wrong.
How to convert CSV to Google SheetsLearn how to convert a CSV file to Google Sheets format, preserve your column structure, and save it as a native Sheets file.
How to count cells with text in Google SheetsLearn how to count cells with text in Google Sheets using COUNTA, COUNTIF, and wildcards for exact or partial text matches.
How to create a filter in Google SheetsLearn how to create a filter in Google Sheets to sort, hide, and analyze data quickly using the built-in filter tool on any free account.
Create interactive demos like this one — free, no coding required.
Start for free →