check before: 2024-02-20
Product:
Forms, Microsoft 365 Apps, Microsoft 365 Groups, OneDrive
Platform:
Web, World tenant
Status:
In development
Change type:
New feature, Admin impact
Links:
Details:
Microsoft Forms offers surveys and quizzes to collect information from your audience. We have added a new feature that lets you quickly and easily sync the responses to an Excel file. Now you’ll always have the latest responses, updated automatically, so you can leverage the full range of Excel functions to analyze your data and collab with your peers.
Feature Experience:
Create an Excel workbook in your own OneDrive on the form/quiz responses page.
Form responses will automatically sync to a table in the Excel workbook where you can start manipulating the data.
New responses will automatically sync while the workbook is open in Excel for the web.
Excel coauthors will also get automatically synced responses in Excel for the web.
Notes:
The live data sync can only be triggered in Excel for the web. If you want to analyze the data in the desktop app, you will also need the file open in Excel for the web to receive the automatic updates.
Edit permissions for the form/quiz and the synced Excel workbook of response data are independent of each other. The form author must grant permissions separately.
Prior to the release of this feature, there were two types of forms that supported an older version of live data sync to Excel, which will continue without change for a short time:
Group form - forms created in your Microsoft 365 group Create a group form or quiz - Microsoft Support
Forms for Excel – forms created from OneDrive for work or school and from new team sites connected with Microsoft 365 Groups. Create a form with Microsoft Forms - Microsoft Support
With this new feature, we are introducing a new data sync solution with higher reliability and faster performance. We will start rolling this new solution out for personal forms/quizzes created from the Forms website, while Group forms and Forms for Excel will continue to use the older solution (the experience will be slightly different from the new solution). Over time, we will gradually migrate all form types to the new solution.
This message is associated with Microsoft 365 Roadmap ID 374909
[When this will happen:]
Standard Release with Preview label: We began rolling out late January 2024 and expect to complete by early March 2024. During the Preview stage, we will iterate on this feature based on your feedback, and we expect to remove the Preview label within 3-6 months after release.
Standard Release with Preview label: We began rolling out late January 2024 and expect to complete by early March 2024.
During the Preview stage, we will iterate on this feature based on your feedback, and we expect to remove the Preview label within 3-6 months after release.
Change Category:
XXXXXXX ...
Scope:
XXXXXXX ...
Release Phase:
General Availability, Preview
Created:
2024-02-06
updated:
2024-02-06
the free basic plan is required to see all details. Sign up here
A cloudsocut.one plan is required to see all the changed details. If you are already a customer, choose login.
If you are new to cloudscout.one please choose a plan.
