Microsoft Forms now offers a live data sync feature to Excel, with automatic updates and coauthor support. This applies to Excel for the web and will be fully available by late July 2024, supporting both group forms and individual forms created in Excel for the web. No admin action is required for rollout.
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 a Microsoft Excel file so you will always have the latest responses, updated automatically. This message applies to Excel for the web. Learn more: Forms data sync to Excel is now fully available with more functionality - Microsoft Community Hub
This message is associated with Microsoft 365 Roadmap ID 374909.
When this will happen:
General Availability (Worldwide): We began rolling out in late June 2024 and expect to complete by late July 2024.
How this will affect your organization:
New features for this rollout
This feature was released with the Preview label in March 2024. We are removing the preview label in July 2024.
After we remove preview label, the new data sync solution will also support two types of forms:
Note: The data sync will be triggered while the workbook is open in Excel for the web. Over time, we will gradually enable data sync for Excel for Desktop.
This feature will be automatically enabled for all users who are able to use Microsoft Forms and Microsoft Excel in your organization. They can find the entry point for this feature from the Forms website and Excel for the web.
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.