Tuesday, June 9, 2020

Combining Multiple Google Forms Results into a Single Spreadsheet with Separate Tabs

It is possible to create multiple Google Forms and have them all feed into the same spreadsheet. What makes this technique useful is that you can have different groups of users filling out different forms in different locations, and all of these results can go into the same spreadsheet, but the results will be automatically filtered into the correct tab at the bottom. I say "automatically," but first you will need to set up the form(s) to know where to go. 

I created the video tutorial below because I know I will be referring to it for various scenarios, which include:
  • Teachers who want to give out a copy of the same Quiz in Google Forms to multiple classes but have the results feed into the same Google Sheet.
  • Technology trainers (or any trainers) who provide classes during the year and want to keep a record of all class lists in the same spreadsheet. Using a Google Form for each class session, all of the class lists can feed into the same master spreadsheet.
  • Band directors who send out a form to multiple schools and want the results to be sorted by tab according to which school the students are coming from.
  • High schools receiving students from multiple feeder schools. Each Google Form they fill out can be sent to a specific tab in a Google Sheet.
  • Middle schools receiving students from multiple feeder elementary schools. Each Google Form that students (or parents) fill out can be sent to a specific tab in a Google Form. 
  • Any other groups in which you want to receive data from Google Forms and have that data sorted by specific groups into separate tabs at the bottom of a Google Sheet.
Any time you have multiple groups of people filling out essentially the same Google Form and you want to centralize that data into one spreadsheet, this technique is very helpful in keeping that data in one place. This video shows the process in which to set up the forms and have them feed into specific tabs within the same spreadsheet:  

No comments:

Post a Comment