Forum Discussion
How to move a Forms to OneDrive?
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....
KyleSC53 you would only have the Forms for Excel link if you'd created a Microsft 365 group. But you can still create a form and share it.
Click the M365 app launcher (often called the waffle menu) to open the list of M365 apps. Click on Forms:
Create your form then click the 3 dots on the top right and select Collaborate or Duplicate:
Click the link in the Add collaborators section which will give you the link you can give to your team. They will then be able to view all the responses, But don't forget that it will also give them the ability to change the form.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- This may help - I figured out how to copy the responses Excel spreadsheet to a folder and it automatically updates when the original one does. I will try this - thank you!
Damien_Rosario Thanks for the browser suggestion! However I can't locate the form on the folder where I chose "New..." after I created it. I tried searching for the form name on the mobile app of OneDrive and found it, added a response, but now when I search again there's nothing. I wasn't able to find an Excel file with the responses. Is there something I'm missing?
To add some context in case it's interesting, I'd like to do something similar to what the original poster wanted, to create a form and/or capture data, if possible on mobile and if possible offline (synchronizing it later with OneDrive), and add it to an Excel file for me to later analyze and aggregate. I'm not personally interested in having lots of people collaborate on that form, but I'd like to have it available across devices.
- like my colleagues, i'm also straggling to Process Microsoft Forms drop_down Responses to sharepoint list. under datatype, we only have the option of "choice". Can the choice work instead of drop down?
TonnyTosh254 in my SharePoint I always have a single line of text column to store the answer from a dropdown in Forms.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Hi dormideira
Hope you are doing well.
Once you go to OneDrive in your web browser and create using Forms in Excel, the file will live in My Files.
It should also appear in your Microsoft Forms screen under Recent.
When you're in the Form, you can also see the Excel file under Responses and click Open in Excel. It will open the Excel file in your OneDrive.
Lastly, forms does not work offline so you are out of luck there!
Hope the above helps and best wishes with your Form.
Cheers
Damien
Damien_Rosario I have gotten this far in my Form creation but I would like to move the Form to a Shared folder. Is this possible?
