Google Forms are one of the best tools. The ability to connect your Google Form to a spreadsheet elevates what you can do with your data. However, your Google Drive is cluttered with multiple spreadsheets to check. Can’t we just send multiple forms to one Google Sheet? Yes you can.
Create Google Forms
You have probably already done this step. You have a lot of Forms but your responses are scattered all over Google Drive.
Create One Spreadsheet
You can start by creating a spreadsheet at sheets.new or you can link other Forms to an existing Forms spreadsheet. Have this destination spreadsheet ready to go as you link the Forms to it.
Responses Tab in Forms
Select Existing Spreadsheet
From the two options in the link to Sheets pop up, choose “Select existing spreadsheet.” This provides the option to select an already existing spreadsheet.
A New Tab
For each Google Form that you connect to the same Google Sheets spreadsheet a new tab will be created. When a tab in Google Sheets is connected to a Google Form, the Forms icon is shown on the tab.
Having multiple Forms to one Google Sheet will show multiple tabs with a Forms icon.
No, You Can NOT Merge Data
Each time you link a Form to the spreadsheet a new tab is created. You can NOT select a pre-existing tab for the Form data to be added to. If you disconnect your Form from the spreadsheet and then reconnect back to the same spreadsheet, a new tab will be added. You can not continue to add to the previous data tab.
Managing the Google Form from the Sheet
When the active sheet has the Forms icon on it, the Tools menu will show “Manage form.” When switching to another tab in the spreadsheet that is not linked to a Google Sheets spreadsheet the “Manage form” option is not available.
Use the Tools menu in the spreadsheet to manage the linked Form. Suggestion to rename the tab name to remember which Form that Sheet tab is connected to.