Microsoft Forms now supports live data sync to Microsoft Excel with more functionality

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

• Create an Excel workbook in your Microsoft 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.

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:

• Group forms created in your Microsoft 365 group. Learn more: Create a group form or quiz - Microsoft Support
• Forms created in workbooks in Excel for the web

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.