Update to the new solution for syncing forms responses to Excel
We are excited to announce that we have a new and improved solution for syncing your form responses to Excel, with better reliability and performance! Previously, some Forms supported an older version of live data synchronization with Excel. This older solution will be gradually discontinued and completely replaced by the new solution by October 20th, 2024.Ultimate Polling and Quiz Experience with Polls app: The Replacement for Forms app in Teams meeting
Initially Forms app was launched in Teams - for different experiences based on the sync vs async user scenarios, as it points to polling experience in meetings for quick creation to launch, while it points to survey experience in the context of Teams channel.To provide an intuitive and easy-to-access experience , Polls app was launched - a dedicated app for all your polling and quiz needs in Teams meeting and chat. We are glad to see that hosting an effective and interactive meeting just got easier after the launch of Polls.What’s new in Forms for EDU – Sep 2024
With the new semester just around the corner, we're excited to introduce some fantastic new features in Forms to enhance your teaching and learning experience. Now, you can enjoy an improved data sync function to stay up to date, set rules to collect more accurate responses, pre-fill forms and quizzes, and easily manage response notifications. Let’s dive in and check more details.Validate open text responses in Microsoft Forms
I'm excited to share that you can apply more rules to your open text questions in Microsoft Forms, enhancing the accuracy and quality of the data collected! Now you can create rules that help you validate the format of answers like emails and URLs. You can also require specific text in the answer and provide minimum or maximum length requirements. Let’s dive in and see how we can better use this in our daily work.You can now sync Forms response to Excel desktop
We are thrilled to introduce a powerful new feature in desktop versions of Excel that is set to transform your data collection process. With the latest update, you can now create a new Microsoft Form directly within an Excel workbook, linking the form to the workbook seamlessly. This feature, previously available in Excel for the Web, is now available in the Windows app, with Mac support coming soon. reate a new linked form from the Excel desktop app This new integration is particularly beneficial for users who frequently collect data from other people. By enabling the creation of a form directly from an Excel workbook, you can streamline the data collection process, making it more efficient and less prone to errors. Whether you are gathering survey responses, feedback, or any other form of data, this feature ensures that all information is centrally located and easily accessible. For example, consider a team working on a project that requires input from multiple stakeholders. Using this new feature, the project manager can create a form to collect updates and feedback, and all responses will be automatically reflected in the project’s Excel workbook. This eliminates the need for manual data entry and consolidation, saving valuable time and reducing the likelihood of errors. How it works On the Insert tab, select Forms > New Form A new browser tab will open, presenting you with a blank form to customize according to your needs. Simultaneously, a linked table will appear in your workbook, ready to sync with the form. As you edit the form or receive new submissions, the linked table in your workbook will automatically update, ensuring that your data is always current and accurate. After creating your form, you can access several other capabilities from the Forms menu: **Preview Form:** This option will open the form in preview mode in a new browser tab, allowing you to see how the form will look to respondents. **Edit Form:** This option will open the form in edit mode in a new browser tab, so you can make changes to the form as needed. **Send Form:** This option will open the form in a new browser tab and show the dialog letting you send the form out to respondents and begin collecting responses. Availability and System Requirements The new Microsoft Forms integration is available to all Current Channel users running Version 2410 (Build 16.0.18227.20000) or later. You can check which version you’re using by going to File > Account. If you are using an earlier version, we recommend updating your Excel app to take full advantage of this feature. Mac users can also look forward to this integration in an upcoming update. Feedback We would love to hear your thoughts on this new feature! Please send any feedback and suggestions by selecting Help > Feedback.Introducing Forms data sync to Excel
The highly anticipated feature – Forms data sync to Excel is now available in Microsoft Forms. With just one click, you can now easily access all your form responses in Excel for the web and take advantage of Excel’s rich functions to analyze and visualize your data. With automatic syncing of new responses in real-time, you can keep working on your existing spreadsheet without missing a beat. No more juggling multiple copies of the same file, making it easier than ever to stay on top of important data. Ready to check out this feature? Let’s get started!Pre-fill Responses in Your Microsoft Forms
We are excited to share that Microsoft Forms now supports pre-filled links, making your data collection process more efficient and improving data accuracy. This feature not only allows you to set default answers for your questions, it empowers you to strategize how you would like the responses categorized. To help you better understand how to leverage this new feature, let's try it together with an online training feedback survey.Migrate Your Google Forms to Microsoft Forms in Microsoft 365 Admin Center
Now you can migrate your Google forms to Microsoft Forms for the full Microsoft 365 experience. This feature is currently available in the Microsoft 365 admin center and is designed as an admin and tenant-level feature, enabling admins to bulk migrate their Google forms to Microsoft forms through the Microsoft 365 admin center. Individual users can then access the migrated forms on the Forms website after the migration. In the initial phrase, we’re -leveraging the existing document migration process in the Microsoft 365 admin center to support forms migration under personal Google drives. Now, let's delve into the end-to-end process.Forms data sync to Excel is now fully available with more functionality
We’ve been gradually rolling out Forms data sync to Excel . During this process, we actively collected user feedback and iterated to enhance the feature for various use cases. I’m excited to announce that this feature is now fully available for all customers, complete with additional capabilities. Let’s explore these updates together.
