Connecting an already created Microsoft Form to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-867242%22%20slang%3D%22en-US%22%3EConnecting%20an%20already%20created%20Microsoft%20Form%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-867242%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20already%20created%20a%20web-based%20Microsoft%20Form%20and%20would%20like%20to%20know%20if%20this%20form%20can%20be%20linked%20to%20an%20Excel%20I%20can%20create%20at%20this%20point%3F%26nbsp%3B%20If%20not%2C%20is%20there%20a%20way%20to%20access%20the%20Excel%20sheet%20behind%20the%20form%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20that%20there%20is%20an%20option%20to%20create%20a%20Flow%20and%20push%20the%20data%20from%20the%20Form%20in%20to%20Excel.%26nbsp%3B%20But%20was%20wondering%20if%20there%20is%20an%20easy%20way%20of%20accessing%20the%20Excel--without%20using%20the%20download%20data%20option.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-867242%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-869628%22%20slang%3D%22en-US%22%3ERe%3A%20Connecting%20an%20already%20created%20Microsoft%20Form%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-869628%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412447%22%20target%3D%22_blank%22%3E%40mano1982%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDepending%20on%20where%20you%20have%20created%20the%20form%2C%20you%20can%20access%20the%20Excel%20doc%20usually%20in%20%3CSTRONG%3ESharePoint%3C%2FSTRONG%3E%20or%20%3CSTRONG%3EOneDrive%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EElse%20you%20can%20also%20find%20it%20in%20the%20form%20itself%20when%20you%20click%20onto%20%3CSTRONG%3EResponses%3C%2FSTRONG%3E%20and%20%3CSTRONG%3EOpen%20in%20Excel%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20900px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133084i66731BB767CDFE98%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22capture20190923121805379.png%22%20title%3D%22capture20190923121805379.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20does%20the%20trick%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%20and%20best%20wishes%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423833%22%20slang%3D%22en-US%22%3ERe%3A%20Connecting%20an%20already%20created%20Microsoft%20Form%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423833%22%20slang%3D%22en-US%22%3ECan%20I%20connect%20a%20form%20that%20is%20already%20created%20to%20excel%20online%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1425381%22%20slang%3D%22en-US%22%3ERe%3A%20Connecting%20an%20already%20created%20Microsoft%20Form%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1425381%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F682300%22%20target%3D%22_blank%22%3E%40CHasprey%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EForms%20generates%20its%20own%20Excel%20doc.%20I%20have%20not%20seen%20it%20allow%20the%20use%20of%20an%20existing%20doc%20and%20do%20not%20believe%20it's%20currently%20possible%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have already created a web-based Microsoft Form and would like to know if this form can be linked to an Excel I can create at this point?  If not, is there a way to access the Excel sheet behind the form?  

 

I know that there is an option to create a Flow and push the data from the Form in to Excel.  But was wondering if there is an easy way of accessing the Excel--without using the download data option. 

 

Thanks.

3 Replies
Highlighted

Hi @mano1982 

 

Depending on where you have created the form, you can access the Excel doc usually in SharePoint or OneDrive.

 

Else you can also find it in the form itself when you click onto Responses and Open in Excel.

 

capture20190923121805379.png

 

Hope that does the trick?

 

Cheers and best wishes

Damien

Highlighted
Can I connect a form that is already created to excel online?
Highlighted

Hi @CHasprey 

 

Forms generates its own Excel doc. I have not seen it allow the use of an existing doc and do not believe it's currently possible to do.

 

Cheers

Damien