SOLVED

Exporting data from forms to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1288679%22%20slang%3D%22en-US%22%3EExporting%20data%20from%20forms%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1288679%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20anyone%20tell%20me%20if%20there%20is%20an%20option%20to%20automatically%20export%20data%20from%20new%20responses%20to%20an%20existing%20spreadsheet.%26nbsp%3B%20This%20would%2C%20for%20example%2C%20already%20hold%20the%20data%20from%20all%20previous%20responses%20and%20is%20supported%20by%20google%20forms!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1288679%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1288873%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20data%20from%20forms%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1288873%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F612770%22%20target%3D%22_blank%22%3E%40Ashburton2020%3C%2FA%3E%26nbsp%3Byou%20can't%20do%20this%20within%20Forms%20itself%20but%20you%20can%20save%20forms%20responses%20to%20a%20table%20in%20an%20existing%20spreadsheet%20via%20a%20flow%20in%20Power%20Automate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1288959%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20data%20from%20forms%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1288959%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20%E2%80%A6%20could%20you%20give%20me%20a%20pointer%20to%20Power%20Automator%20and%20is%20it%20suitable%20for%20an%20experienced%20but%20not%20professional%20IT%20user%3F%26nbsp%3B%20I'm%20just%20trying%20to%20automate%20it%20for%20a%20Food%20Bank.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Can anyone tell me if there is an option to automatically export data from new responses to an existing spreadsheet.  This would, for example, already hold the data from all previous responses and is supported by google forms!

2 Replies
best response confirmed by Ashburton2020 (Occasional Contributor)
Solution

@Ashburton2020 you can't do this within Forms itself but you can save forms responses to a table in an existing spreadsheet via a flow in Power Automate.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Thanks … could you give me a pointer to Power Automator and is it suitable for an experienced but not professional IT user?  I'm just trying to automate it for a Food Bank.