SOLVED

Linking an excel work book/sheet to online MS form data entry

%3CLINGO-SUB%20id%3D%22lingo-sub-3198374%22%20slang%3D%22en-US%22%3ELinking%20an%20excel%20work%20book%2Fsheet%20to%20online%20MS%20form%20data%20entry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3198374%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20link%20a%20workbook%20or%20an%20excel%20sheet%20to%20online%20MS%20data%20entry%20for%20so%20that%20the%20data%20is%20entered%20into%20the%20workbook%2Fsheet%20without%20copying%20and%20pasting%20the%20contents%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest.%3C%2FP%3E%3CP%3EHika%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3198374%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3202752%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20an%20excel%20work%20book%2Fsheet%20to%20online%20MS%20form%20data%20entry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3202752%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%2F1314471%22%20target%3D%22_blank%22%3E%40Hika330%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyes%2C%20that's%20possible.%20But%20as%20far%20as%20I%20know%20this%20only%20works%20with%20a%20M365%20business%20version%20and%20OneDrive%20for%20Business.%3C%2FP%3E%3CP%3EFrom%20your%20M365%20account%2C%20you%20have%20to%20open%20Excel%20in%20a%20browser.%20There%20you%20will%20find%20in%20the%20insert-menue%20a%20button%20%22Forms%22.%20So%20you%20need%20to%20create%20the%20form%20directly%20from%20within%20Excel%20for%20the%20Web%2C%20than%20all%20the%20form%20responses%20will%20show%20up%20directly%20in%20this%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20a%20German%20screen%2C%20but%20you%20should%20recognize%20the%20menue%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DTE_0-1645603237693.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350627i3FC7EEB31768DD46%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DTE_0-1645603237693.png%22%20alt%3D%22DTE_0-1645603237693.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3220003%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20an%20excel%20work%20book%2Fsheet%20to%20online%20MS%20form%20data%20entry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3220003%22%20slang%3D%22en-US%22%3E%3CP%3EWelnoted%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F48469%22%20target%3D%22_blank%22%3E%40DTE%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20about%20linking%26nbsp%3B%20the%20online%20version%20with%20the%20offline%20one%20so%20that%20the%20online%20can%20populate%20the%20offline%20automatically%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi Guys, 

 

Is it possible to link a workbook or an excel sheet to online MS data entry for so that the data is entered into the workbook/sheet without copying and pasting the contents? 

 

Best.

Hika 

4 Replies

Hi @Hika330 

 

yes, that's possible. But as far as I know this only works with a M365 business version and OneDrive for Business.

From your M365 account, you have to open Excel in a browser. There you will find in the insert-menue a button "Forms". So you need to create the form directly from within Excel for the Web, than all the form responses will show up directly in this file.

 

It's a German screen, but you should recognize the menue:

DTE_0-1645603237693.png

 

 

Welnoted@Martin_Weiss 

 

Thank you. 

 

How about linking  the online version with the offline one so that the online can populate the offline automatically?

 

Best

best response confirmed by Hans Vogelaar (MVP)
Solution

Hi @Hika330 

 

as you have to store the Excel file anyway on OneDrive in order to use it with the Excel for Web application, it will be synchronized automatically to your local OneDrive folder (depending on your local OneDrive sync-settings, of course) 

wenoted@Martin_Weiss 

 

Thank you so much,

 

Best,