If you use Google Forms, you want to link a Google Sheets spreadsheet to it. Once you’re in the spreadsheet, how do you manage Google Forms in Google Sheets?
Responses Tab
In Google Forms, click on the “Responses” tab to find a green spreadsheet icon. This will say “Link to Sheets” if you do not already have a spreadsheet for the Form. Otherwise, it will say “View in Sheets.”
Sheets are a Copy of the Google Form Data
When the Google Form is filled out, a COPY of the response is sent to Google Sheets. This means if edits are made in the spreadsheet, they are NOT reflected in the Google Form. If a response is deleted in the Form, they are NOT deleted from the spreadsheet.
This is very helpful to allow you to delete responses from your Form to keep reusing the Form without losing your data.
Managing Google Forms in Google Sheets
From the Google Sheets spreadsheet you want to use the TOOLS menu to access the actual Form. On the tab in Google Sheets that links to a Google Form you will see the Forms logo. When you are on that tab and go to the Tools menu there is the option to “Manage form.”
Go to Live Form
One of the most common reasons I want to use the Tools menu to “Manage form” is to fill out the Form in order to add new data to the spreadsheet. For the tab with the Form icon it is not advised to add new data rows manually. Instead, always fill out the Form in order to add new data rows.
More Than One Form in a Spreadsheet
You can have more than one Google Form linked to a single spreadsheet. This means you will have multiple tabs with a Form icon on the tab. They will say “Form Responses 1” and “Form Responses 2”, etc… This is why it is important that you are actually on the tab with the Form icon so you can use the Tools menu to access THAT Form.
- Manage Multiple Google Accounts
- Students Submitting YouTube Videos
- How To Make a Form from Google Sheets
- How to Add a Google Form to Google Classroom
- Managing LAST MINUTE PILE of Late Work
-
10 Ways Teachers Can Unleash the Power of Appsheet
AppSheet lets teachers build their own apps without code! Here are 10 ways to use AppSheet for teachers for custom classroom solutions.
-
CTRL L: Leveling Up Student-Centered Learning with a Simple Shortcut
The simple shortcut Ctrl+L might seem insignificant, but it can be a powerful tool in a student-centered classroom.
-
Chrome for the Classroom: Essential Updates Every Teacher Should Know
Chrome is always improving. If you use Chrome for the classroom you will want to check out these essential updates.
-
30 Keyboard Shortcuts That Teachers Need
The secret to feeling more confident on the computer is keyboard shortcuts! Here are 30 Keyboard Shortcuts That Teachers Need
-
Hide All Tabs – Google Sheets
Have a lot of tabs in your Google Sheets spreadsheet? Here is how to hide all tabs at once, quickly.
-
Transform Your Lessons: The Power of Desmos Classroom Computation Layer
Take Desmos Classroom even further with the computation layer. Customize your lesson with the CL.