In July 2024, we communicated in MC816207 that Microsoft Forms supports live data sync to Microsoft Excel with more functionality.
Coming soon: A new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. New Forms created from Microsoft OneDrive and Microsoft SharePoint online after this rollout will use the new data sync solution.
[When this will happen:]
General Availability (Worldwide): We will begin rolling out mid-October 2024 and expect to complete by mid-November 2024.
[How this will affect your organization:]
Before this rollout, Forms created from OneDrive and SharePoint Online used the old data sync solution. The Excel file was created automatically when creating the forms, and the Forms data was pushed to Excel file through Graph API.
With this rollout, Forms created from OneDrive and SharePoint Online will use the new data sync solution. The Excel file will not be created automatically. The user can create the Excel file from the Forms result page after responses have been received.
Workflow
1. Create a new form from SharePoint Online or OneDrive for business: Select New > Forms survey (before rollout, this was called Forms for Excel).
2. After receiving responses to the form, create an Excel file from the Forms result page to sync the data:
3. The Excel file will be created in the SharePoint folder where the form was created.
Note: The new data sync can only be triggered in Excel for the web. If users want to receive new Forms response data in the Excel desktop app, open the file in Excel for the web, and then wait for the desktop app file to sync from the web file. (Support for other versions of Excel is in progress.)
This feature will be on by default.
[What you need to do to prepare:]
This rollout will happen automatically by the specified date with no admin action required before the rollout. You may want to notify your users about this change and update any relevant documentation.
Learn more: Create a form with Microsoft Forms – Microsoft Support (will be updated before rollout begins)
Source: Microsoft
The upcoming update for Microsoft Forms is set to bring a new data sync solution for Microsoft Excel for the web in Microsoft SharePoint Online and OneDrive. This means that Forms created from OneDrive and SharePoint Online will use a more reliable data sync solution, enhancing the user experience.
For admins, this update will require them to inform users about the change and update any relevant documentation. Users, on the other hand, will notice a shift in how Forms response data is synced to Excel. Instead of the Excel file being created automatically, users will now have the flexibility to create the Excel file from the Forms result page after receiving responses.
In terms of criticality, this update is important for ensuring a smoother data sync process between Forms and Excel, ultimately improving efficiency and user control over data management. So, get ready to embrace this change and make the most out of the enhanced features coming your way!
Remember, the new data sync feature will be on by default, so no need to worry about turning it on. Just sit back, relax, and let the update work its magic!