Forum Discussion
How to move a Forms to OneDrive?
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 "...
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
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 - 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.
