Forum Discussion
How to move a Forms to OneDrive?
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
I am trying to save a MS Form from the MS 365 site to OneDrive. Following your steps...however I do not get "Forms to Excel" when selecting new? I have opened the form on 365 then click on OneDrive App. Am I doing something wrong?
Hi Kate_Merit02
Hope you are well.
Make sure you are in OneDrive in your web browser before proceeding.
You'll need to recreate the questions in your new form but the data will then live in OneDrive which is what I assume you're looking to have?
See how you go?
Cheers and best wishes
Damien
Damien_RosarioI don't have New Form for Excel in my Office 365? I am desperately trying to create a form for a team, share the darn thing, and have everyone have access to the responses and forms.
This has been beyond frustrating....
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
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
- 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.
- 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
