Allow different forms' responses to sync into the tabs of one Excel Spreadsheet
Allow different forms' responses to sync into the tabs of one Excel Spreadsheet. Thus, merging forms' responses into the same spreadsheet.
Margit Schindler commented
It would be really helpfull for us since we work with many different teams but want to ask them the same things and merge the results. Thank.
This will allow creating a form template to be used for similar activities and then collate the data easily.
It is very useful if one workbook for different forms.
Guillaume Cyr commented
That would be great for evaluation analysis for teachers.
Matthew Bassett commented
Seriously! This is such a critical feature! It plays right into the ability to also take an existing form and give it a destination sheet to dump its data into (Which could just be a tab). That way a form created in forms and not excel could still after the fact be linked to a spreadsheet in excel. This solves so many outside use cases too that are tangential to this, like when you duplicate a form, it can't be synced into a workbook at all unless its been created from excel or one drive first.
Peter Wang commented
It's not easy to find an solution to allow different people fill in same one Form.