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 Sheets icon. 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 Sheets icon 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
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. Make sure the form has at least one question set up, since Sheets needs a header row to map responses to columns.
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 along with icons for viewing individual responses and exporting data.
Step 3
Select the green Sheets icon
In the top-right corner of the Responses tab, click the green Sheets icon. A dialog box titled 'Select response destination' will appear 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, 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 (or Select for an existing file). Google Sheets opens automatically in a new tab, showing a header row generated from 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 instantly as a new row in 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 the green Sheets icon 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 do this from my phone?
Yes, the Google Forms mobile app lets you open Responses and tap the Sheets icon the same way as on desktop, though creating a form from an existing spreadsheet is easier on a computer.
Can I create a form starting from a spreadsheet instead?
Yes. Open a Google Sheet, click Insert in the menu bar, choose Form, and Google Sheets will generate a linked form using your column headers as questions.
Create interactive demos like this one — free, no coding required.
Start for free →