Form data location

%3CLINGO-SUB%20id%3D%22lingo-sub-94518%22%20slang%3D%22en-US%22%3EForm%20data%20location%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-94518%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhere%20does%20forms%20store%20the%20Excel%20sheet%20where%20responses%20are%20saved%20to%3F%20We're%20looking%20to%20analyse%20results%20directly%20from%20the%20sheet%20on%20O365%20rather%20than%20the%20'Open%20in%20Excel'%20option%20-%20is%20it%20possible%20to%20change%20which%20sheet%20data%20is%20written%20to%20from%20Forms%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-94518%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-330632%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20data%20location%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-330632%22%20slang%3D%22en-US%22%3EHi%20Alasdair%2C%20thanks%20for%20the%20question.%20There%20isn't%20a%20way%20to%20change%20which%20excel%20sheet%20the%20responses%20are%20saved%20to%2C%20however%20this%20is%20a%20great%20question.%20We'll%20add%20this%20to%20the%20list%20of%20work%20to%20look%20into.%20Thank%20you!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-330451%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20data%20location%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-330451%22%20slang%3D%22en-US%22%3EI%20am%20also%20looking%20for%20this%20information%3F%20Did%20you%20ever%20figure%20it%20out%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-638337%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20data%20location%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-638337%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Si%3C%2FP%3E%3CP%3EYou%20did%20not%20answer%20to%20question%201%20%3A%20where%20is%20the%20excel%20file%20store%20exactly%20%3F%20I%20did%20not%20built%20it%20myself%2C%20and%20I%20cannot%20find%20it%20%3A%20when%201%20click%20on%20Excel%20icon%2C%20this%20download%20to%20my%20desktop%3C%2FP%3E%3CP%3Ethx%20in%20advance%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F159437%22%20target%3D%22_blank%22%3E%40Si%20Meng%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi there,

 

Where does forms store the Excel sheet where responses are saved to? We're looking to analyse results directly from the sheet on O365 rather than the 'Open in Excel' option - is it possible to change which sheet data is written to from Forms?

3 Replies
I am also looking for this information? Did you ever figure it out?
Hi Alasdair, thanks for the question. There isn't a way to change which excel sheet the responses are saved to, however this is a great question. We'll add this to the list of work to look into. Thank you!

Hi Si

You did not answer to question 1 : where is the excel file store exactly ? I did not built it myself, and I cannot find it : when 1 click on Excel icon, this download to my desktop

thx in advance

@Si Meng