TL;DR
Microsoft is expanding the Forms data sync to Excel for personal forms functionality to Group forms and adding more features. Due late June to late July 2024.
Details
Live data sync to Microsoft Excel lets you sync Forms responses to a Microsoft Excel (online) file, so you always have the latest responses, which update automatically.
This functionality was previously restricted to personal Forms but is being extended to forms created in M365 Groups and in Excel for the web.
New features:
- Create an Excel workbook in your OneDrive on the form/quiz responses page
- Form responses will automatically sync to a table in the Excel workbook
- 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

Availability
Due late June to late July 2024.
Source, related links, and references
MC816207.
365 Roadmap ID 374909.
Image(s): Microsoft.
Microsoft Forms | Data sync to Microsoft Excel: Support for migrating from the older solution to the new solution – Super Simple 365.
Forms data sync to Excel is now fully available with more functionality – Microsoft Community Hub.
Create a form with Microsoft Forms – Microsoft Support.
Create a group form or quiz – Microsoft Support.
Ask a question
Discuss and share this update on X/Twitter, Threads or LinkedIn.
Suggested action
Please share this page with your colleagues so they can prepare for this update.
Page originally published
22nd July 2024 and kept up to date.
See what else is late, new, and coming soon across M365 and Teams this month with the latest roundup.
Are you an Update Insider yet? Get early access to the What’s new in Microsoft 365 and Copilot? roundup, have every full update (like this one) delivered immediately to your inbox and gain exclusive rights to share your questions and views on updates across the site. Sign up for a free trial, then just £5 per month. Slide Deck members can also download the latest Evergreen slides to use and present at work.