How to export data from multiple Forms to a single excel spreadsheet?

%3CLINGO-SUB%20id%3D%22lingo-sub-215336%22%20slang%3D%22en-US%22%3EHow%20to%20export%20data%20from%20multiple%20Forms%20to%20a%20single%20excel%20spreadsheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-215336%22%20slang%3D%22en-US%22%3EHi!%20I%20created%20a%20few%20Forms%20but%20I%20need%20to%20extract%20data%20from%20all%20these%20Forms%20into%20A%20single%20excel%20spreadsheet%20so%20that%20I%20can%20filter%20and%20analysis%20the%20data.%20For%20example%2C%20I%20need%20to%20extract%20the%20people%20details%20that%20have%20completed%20the%20Forms%20from%20multiple%20Forms.%20Is%20there%20a%20way%20to%20do%20it%3F%20Right%20now%2C%20I%20can%20only%20export%20data%20from%20one%20Form%20to%20an%20excel%20spreadsheet%20and%20if%20I%20will%20to%20do%20that%20for%205%20Forms%2C%20I%20will%20need%20to%20do%20it%205%20times%20and%20I%20will%20have%205%20spreahsheets.%20Any%20simple%20work%20around%20solution%3F%20Appreciate%20all%20comments!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-215336%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-215858%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20export%20data%20from%20multiple%20Forms%20to%20a%20single%20excel%20spreadsheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-215858%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Watefishy%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20aware%20of%20any%20feature%20that%20will%20allow%20you%20to%20download%20multiple%20results%20and%20consolidate%20to%20one%20spreadsheet%20at%20this%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20maybe%20that%20you%20will%20need%20to%20copy%20and%20paste%20the%20data%20from%20the%20sheets%20into%20one%20of%20your%20feedback%20forms%20to%20get%20those%20results.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes%20with%20your%20Forms!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-870436%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20export%20data%20from%20multiple%20Forms%20to%20a%20single%20excel%20spreadsheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-870436%22%20slang%3D%22en-US%22%3EHi%20Watefishy%2C%3CBR%20%2F%3EThis%20is%20the%20exact%20issue%20I%20have%20too%20and%20I%20joined%20this%20group%20to%20figure%20out%20how!%3F%20Did%20you%20manage%20to%20sort%20this%3F%20I%20was%20thinking%20of%20using%20a%20flow%20connector%20and%20squirt%20it%20into%20Excel%20online%20but%20still%20coming%20up%20against%20the%20one%20survey%20per%20export%20issue....%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1422604%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20export%20data%20from%20multiple%20Forms%20to%20a%20single%20excel%20spreadsheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1422604%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20same%20position%20wish%20they%20would%20allow%20to%20collate%20for%20reporting%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F164509%22%20target%3D%22_blank%22%3E%40watefishy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor
Hi! I created a few Forms but I need to extract data from all these Forms into A single excel spreadsheet so that I can filter and analysis the data. For example, I need to extract the people details that have completed the Forms from multiple Forms. Is there a way to do it? Right now, I can only export data from one Form to an excel spreadsheet and if I will to do that for 5 Forms, I will need to do it 5 times and I will have 5 spreahsheets. Any simple work around solution? Appreciate all comments!
5 Replies

Hi Watefishy

 

I am not aware of any feature that will allow you to download multiple results and consolidate to one spreadsheet at this time.

 

It maybe that you will need to copy and paste the data from the sheets into one of your feedback forms to get those results. 

 

Best wishes with your Forms!

 

Cheers

Damien

Hi Watefishy,
This is the exact issue I have too and I joined this group to figure out how!? Did you manage to sort this? I was thinking of using a flow connector and squirt it into Excel online but still coming up against the one survey per export issue....

In the same position wish they would allow to collate for reporting @watefishy 

@watefishy the only way to do this really is to have one flow in Power Automate for each of your forms with the "When a new response is submitted" trigger on each, but to have each response added as a row into the single spreadsheet.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User