Merge results of two separate forms?

%3CLINGO-SUB%20id%3D%22lingo-sub-2281588%22%20slang%3D%22en-US%22%3EMerge%20results%20of%20two%20separate%20forms%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281588%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20training%20PowerPoint%20that%20includes%203%20separate%20Microsoft%20forms%20minis%20quizzes%20for%20review%20throughout%20the%20presentation.%20It%20is%20possible%20to%20merge%20and%20calculated%20the%20results%20of%20each%20quiz%20into%20a%20single%20excel%20spreadsheet%3F%20Please%20tell%20me%20that%20this%20is%20possible%20and%20hopefully%20a%20simple%20fix.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2281588%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuiz%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2300287%22%20slang%3D%22en-US%22%3ERe%3A%20Merge%20results%20of%20two%20separate%20forms%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2300287%22%20slang%3D%22en-US%22%3EForms%20does%20not%20provide%20this%20functionality.%20However%2C%20I've%20seen%20people%20do%20this%20with%20Excel%20Scripting%20or%20PowerAutomate%20(Flow).%20If%20this%20is%20a%20one-off%20case%2C%20typically%20i%20recommend%20just%20exporting%20each%20to%20separate%20excel%20files%20and%20then%20copy%20pasting%20to%20merge%20the%20contents%20together%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%2C%3CBR%20%2F%3E-jon%3CBR%20%2F%3EMicrosoft%20Forms%20-%20Senior%20Program%20Manager%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, 

I have a training PowerPoint that includes 3 separate Microsoft forms minis quizzes for review throughout the presentation. It is possible to merge and calculated the results of each quiz into a single excel spreadsheet? Please tell me that this is possible and hopefully a simple fix.

1 Reply
Forms does not provide this functionality. However, I've seen people do this with Excel Scripting or PowerAutomate (Flow). If this is a one-off case, typically i recommend just exporting each to separate excel files and then copy pasting to merge the contents together

Thanks,
-jon
Microsoft Forms - Senior Program Manager