How to Save Microsoft Forms to Onedrive?

Last Updated: Feb 10, 2024 by

Microsoft Forms is a powerful tool for creating surveys, quizzes, and polls. It allows users to easily collect and analyze data from respondents. One of the great features of Microsoft Forms is the ability to save responses to a OneDrive Excel file. In this article, we will discuss how to save Microsoft Forms to OneDrive and the benefits of using this feature.

Saving Responses to OneDrive

To save responses to OneDrive, follow these steps:

  1. Create a new form or open an existing one in Microsoft Forms.
  2. Click on the “Responses” tab at the top of the page.
  3. Click on the “Open in Excel” button on the right side of the page.
  4. A pop-up window will appear asking you to choose where to save the Excel file. Select “OneDrive – Personal” or “OneDrive – Business” depending on your account.
  5. Click “Save” and the Excel file will be saved to your OneDrive account.

Benefits of Saving to OneDrive

There are several benefits to saving Microsoft Forms responses to OneDrive:

Easy Access and Organization

By saving responses to OneDrive, you can easily access and organize your data. The Excel file will be automatically saved to your OneDrive account, making it accessible from any device with an internet connection. This also allows you to easily share the file with others who may need to view or analyze the data.

Real-Time Updates

Any changes or updates made to the form will be reflected in the Excel file saved on OneDrive. This means that you will always have the most up-to-date data without having to manually update the Excel file.

Integration with Other Microsoft Tools

OneDrive is integrated with other Microsoft tools such as Excel, Power BI, and SharePoint. This allows you to easily import the data from your Microsoft Forms responses into these tools for further analysis and visualization.

Microsoft Forms vs SurveyMonkey

Microsoft Forms is often compared to SurveyMonkey, another popular survey tool. While both have their own unique features, there are a few key differences between the two:


Microsoft Forms is included in most Microsoft Office 365 subscriptions, making it a more cost-effective option for those who already use Microsoft products. SurveyMonkey, on the other hand, offers a free basic plan but charges for more advanced features.

Integration with Microsoft Tools

As mentioned earlier, Microsoft Forms is integrated with other Microsoft tools, making it a convenient option for those who already use these tools. SurveyMonkey does not have the same level of integration with Microsoft products.

Customization Options

SurveyMonkey offers more customization options for surveys, such as the ability to add custom branding and design elements. Microsoft Forms has a more limited range of customization options.

In conclusion, saving Microsoft Forms responses to OneDrive is a useful feature that allows for easy access, real-time updates, and integration with other Microsoft tools. While SurveyMonkey may offer more customization options, Microsoft Forms is a cost-effective and convenient option for those who already use Microsoft products. Have you tried saving Microsoft Forms to OneDrive? Let us know in the comments.

Gulrukh Ch

About the Author: Gulrukh Ch

Gulrukh Chaudhary, an accomplished digital marketer and technology writer with a passion for exploring the frontiers of innovation. Armed with a Master's degree in Information Technology, Gulrukh seamlessly blends her technical prowess with her creative flair, resulting in captivating insights into the world of emerging technologies. Discover more about her on her LinkedIn profile.