How to move a Forms to OneDrive?

%3CLINGO-SUB%20id%3D%22lingo-sub-197729%22%20slang%3D%22en-US%22%3EHow%20to%20move%20a%20Forms%20to%20OneDrive%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197729%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EAn%20user%20has%20created%20a%20Forms%20directly%20with%20the%20app%20Forms%2C%20so%20now%20when%20she%20wants%20to%20open%20answers%20in%20Excel%2C%20she%20has%20to%20download%20a%20file%20and%20there's%20no%20excel%20file%20in%20OneDrive.%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20%22move%22%20it%20to%20OneDrive%20so%20she%20can%20open%20answers%20in%20Excel%20Online%3F%20Or%20maybe%20make%20it%20as%20a%20Template%20and%20then%20create%20a%20new%20Forms%20in%20OneDrive%20and%20use%20it..%3F%20I%20can't%20find%20any%20solution...%20Thanks%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-197729%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-216929%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20move%20a%20Forms%20to%20OneDrive%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216929%22%20slang%3D%22en-US%22%3EHi%20Carlos%3CBR%20%2F%3E%3CBR%20%2F%3EGood%20question.%20I%20am%20not%20aware%20of%20any%20easy%20method%20to%20do%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20only%20thing%20I%20can%20suggest%20is%20to%20manually%20export%20the%20results%20of%20each%20form%20to%20Excel%20and%20save%20it%20to%20OneDrive%20for%20historial%20record.%3CBR%20%2F%3E%3CBR%20%2F%3EYou'd%20probably%20have%20to%20create%20the%20forms%20as%20per%20my%20suggestion%20above%20in%20OneDrive%20if%20you%20want%20the%20Excel%20file%20to%20be%20live%20data%20moving%20forward.%3CBR%20%2F%3E%3CBR%20%2F%3EChristopher%20Webb%20might%20have%20some%20further%20thoughts%20on%20this.%3CBR%20%2F%3E%3CBR%20%2F%3ESorry%20that%20I%20don't%20have%20better%20news%20for%20you.%20Forms%20is%20still%20in%20the%20early%20days%20of%20its%20life%20and%20more%20useful%20functionality%20will%20likely%20come%20in%20down%20the%20track.%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20wishes%20friend.%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3CBR%20%2F%3EDamien%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-216784%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20move%20a%20Forms%20to%20OneDrive%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216784%22%20slang%3D%22en-US%22%3E%3CP%3EDamien%2C%26nbsp%3BI%20have%20the%20same%20need%2C%20but...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20about%20150%20forms%2C%20mostly%20questionnaires%2C%20originally%20created%20using%20Microsoft%20Forms.%20Having%20them%20separately%20makes%20it%20harder%20to%20use%20all%20that%20data%20to%20produce%20statistics.%20For%20that%20reason%20I%20want%20to%20move%20them%20all%20to%20Excel%2FOneDrive%20or%20even%20a%20database.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20there%20is%20no%20export%2Fimport%20option%2C%20so%2C%20what%20would%20be%20the%20most%20effective%20way%20to%20move%20all%20my%20questionnaires%2C%20with%20data%2C%20to%20Excel%2FOneDrive%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much...Carlos%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-199798%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20move%20a%20Forms%20to%20OneDrive%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-199798%22%20slang%3D%22en-US%22%3EHi%20Caroline%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20addition%20to%20Christophers%20suggestion%2C%20you%20can%20create%20a%20MS%20Form%20directly%20linked%20to%20OneDrive%20by%3A%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20Go%20to%20Office%20365%20online%20in%20your%20web%20browser.2.%20Using%20the%20app%20launcher%2C%20open%20OneDrive.3.%20In%20the%20OneDrive%20menu%2C%20click%20onto%20New%20%26gt%3B%20Forms%20for%20Excel.4.%20Name%20your%20new%20Form%20and%20click%20Create.%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20now%20replicate%20your%20old%20Form%20in%20the%20new%20one%20and%20the%20results%20will%20always%20be%20available%20in%20your%20OneDrive.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20ever%20need%20to%20share%20the%20results%20file%20with%20someone%2C%20you%20can%20just%20share%20the%20Excel%20doc%20as%20you%20would%20any%20other%20doc%20on%20OneDrive%20(right%20click%20onto%20the%20file%20and%20Share).%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20wishes%3CBR%20%2F%3EDamien%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-198133%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20move%20a%20Forms%20to%20OneDrive%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-198133%22%20slang%3D%22en-US%22%3EThank%20you%20for%20your%20help!%20I'll%20try%20this!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197843%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20move%20a%20Forms%20to%20OneDrive%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197843%22%20slang%3D%22en-US%22%3EOnly%20option%20you%20have%20is%20to%20create%20a%20flow%2C%20that%20takes%20responses%20to%20the%20form%20and%20moves%20them%20into%20an%20excel%20file%20that%20lives%20on%20your%20OneDrive%20that%20I'm%20aware%20of.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1636254%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20move%20a%20Forms%20to%20OneDrive%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1636254%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20give%20more%20details%20to%20how%20you%20replicate%20a%20Form%20from%20the%20App%20to%20onedrive.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1646768%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20move%20a%20Forms%20to%20OneDrive%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1646768%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%2F782480%22%20target%3D%22_blank%22%3E%40Tim_Christopher770%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20do%20you%20mean%20by%20replicate%20a%20Form%20from%20the%20App%20to%20OneDrive%3F%20Do%20you%20meant%20he%20actual%20questions%2Fresponse%20options%2C%20or%20the%20results%20as%20discussed%20in%20this%20post%3F%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-1818631%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20move%20a%20Forms%20to%20OneDrive%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1818631%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F134240%22%20target%3D%22_blank%22%3E%40Caroline%20Gauthier%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECaroline%2C%3C%2FP%3E%3CP%3EDid%20you%20ever%20get%20a%20satisfactory%20answer%20on%20how%20to%20move%20MS%20Forms%20to%20have%20the%20excel%20sheet%20responses%20show%20in%20onedrive%3F%20Other%20than%20rebuilding%20the%20form.%20It%20seems%20as%20such%20a%20easy%20thing%20but%20why%20the%20no-export%20or%20import%20not%20allowed%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2187529%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20move%20a%20Forms%20to%20OneDrive%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2187529%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F846079%22%20target%3D%22_blank%22%3E%40JTSsmtxcom%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20did%20anyone%20here%20succeeded%20in%20transfering%20Forms%2C%20that%20originally%20have%20been%20created%20in%20sharepoint%20Forms%20to%20Onedrive%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EO365%20offers%20moving%20the%20form%2C%20but%20only%20to%20other%20shrepoint%20groups%20but%20not%20to%20onedrive.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20not%20want%20to%20create%20all%20my%20forms%20again%20on%20onedrive%20just%20to%20be%20able%20to%20have%20all%20replies%20in%20one%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%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-2187934%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20move%20a%20Forms%20to%20OneDrive%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2187934%22%20slang%3D%22en-US%22%3EI%20use%20Power%20Automate%20to%20move%20all%20results%20to%20an%20Excel%20file%20in%20OneDrive.%20It%20happens%20automatically%20after%20each%20response%20is%20received%20and%20in%20some%20cases%20additional%20things%20happen%20like%20send%20an%20email%20with%20results%20analysis%20or%20warn%20a%20student%20on%20specific%20areas%20for%20improvement.%20All%20automated.%3CBR%20%2F%3E%3CBR%20%2F%3EPower%20Automate%20is%20a%20tool%20with%20superpowers.%20Once%20you%20learn%20the%20basics%20and%20start%20unleashing%20the%20powers%20you%20will%20realize%20you%20can't%20live%20without%20it.%20%3A)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2187958%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20move%20a%20Forms%20to%20OneDrive%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2187958%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46525%22%20target%3D%22_blank%22%3E%40Carlos%20Hurtado%3C%2FA%3E%26nbsp%3BThank%20you%20very%20much%20for%20your%20input.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20played%20around%20with%20power%20automate%20for%20approvals%20and%20mail%20notifications.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20might%20need%20some%20hints%20how%20to%20move%20new%20form%20entries%20into%20a%20certain%20excel.%20Is%20there%20any%20source%20you%20could%20advise%20to%20me%20or%20maybe%20some%20help%20that%20you%20can%20provide%20from%20your%20side%3F%20Any%20help%20appreciated%20%3A-%20)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20I%20was%20wondering%2C%20if%20the%20results%20could%20be%20automatically%20put%20into%20a%20preformatted%20pdf%20and%20that%20is%20going%20to%20be%20send%20around%2C%20all%20automatically.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

An user has created a Forms directly with the app Forms, so now when she wants to open answers in Excel, she has to download a file and there's no excel file in OneDrive.

Is it possible to "move" it to OneDrive so she can open answers in Excel Online? Or maybe make it as a Template and then create a new Forms in OneDrive and use it..? I can't find any solution... Thanks for your help!

13 Replies
Only option you have is to create a flow, that takes responses to the form and moves them into an excel file that lives on your OneDrive that I'm aware of.
Thank you for your help! I'll try this!
Hi Caroline

In addition to Christophers suggestion, you can create a MS Form directly linked to OneDrive by:

1. Go to Office 365 online in your web browser.
2. Using the app launcher, open OneDrive.
3. In the OneDrive menu, click onto New > Forms for Excel.
4. Name your new Form and click Create.

You can now replicate your old Form in the new one and the results will always be available in your OneDrive.

If you ever need to share the results file with someone, you can just share the Excel doc as you would any other doc on OneDrive (right click onto the file and Share).

Best wishes
Damien

Damien, I have the same need, but...

 

I have about 150 forms, mostly questionnaires, originally created using Microsoft Forms. Having them separately makes it harder to use all that data to produce statistics. For that reason I want to move them all to Excel/OneDrive or even a database.

 

I know there is no export/import option, so, what would be the most effective way to move all my questionnaires, with data, to Excel/OneDrive?

 

Thank you very much...Carlos  

 

Thank you

Hi Carlos

Good question. I am not aware of any easy method to do it.

The only thing I can suggest is to manually export the results of each form to Excel and save it to OneDrive for historial record.

You'd probably have to create the forms as per my suggestion above in OneDrive if you want the Excel file to be live data moving forward.

Christopher Webb might have some further thoughts on this.

Sorry that I don't have better news for you. Forms is still in the early days of its life and more useful functionality will likely come in down the track.

Best wishes friend.

Cheers
Damien

@Damien Rosario 

 

Can you give more details to how you replicate a Form from the App to onedrive.

Hi @Tim_Christopher770 

 

What do you mean by replicate a Form from the App to OneDrive? Do you meant he actual questions/response options, or the results as discussed in this post?

 

Cheers

Damien

@Caroline Gauthier 

 

Caroline,

Did you ever get a satisfactory answer on how to move MS Forms to have the excel sheet responses show in onedrive? Other than rebuilding the form. It seems as such a easy thing but why the no-export or import not allowed?

@JTSsmtxcom 

Hi did anyone here succeeded in transfering Forms, that originally have been created in sharepoint Forms to Onedrive ?

 

O365 offers moving the form, but only to other shrepoint groups but not to onedrive.

 

I do not want to create all my forms again on onedrive just to be able to have all replies in one spreadsheet.

 

Thanks in advance

 

 

 

 

I use Power Automate to move all results to an Excel file in OneDrive. It happens automatically after each response is received and in some cases additional things happen like send an email with results analysis or warn a student on specific areas for improvement. All automated.

Power Automate is a tool with superpowers. Once you learn the basics and start unleashing the powers you will realize you can't live without it. :)

@Carlos Hurtado Thank you very much for your input.

 

I have played around with power automate for approvals and mail notifications.

 

I might need some hints how to move new form entries into a certain excel. Is there any source you could advise to me or maybe some help that you can provide from your side? Any help appreciated :- )

 

Also I was wondering, if the results could be automatically put into a preformatted pdf and that is going to be send around, all automatically.

 

Cheers 

I'd say the best place to start is to use a very basic template that you can use in Power Automate that does exactly that: add every response to Excel. Do a search in PA with forma and excel keywords. Let me know if you don't find it to jump into the computer and do the search. In my cellphone it's harder to do so.

With respect to PDF, sure you can do that. There are actions to create PDF documents and share via email with subscribers. 100% automated.
When you follow the instructions Damien gave and create the form, the form will automatically suggest your questions from the latest form, so you will be able to easily select the questions from the "old" form.