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
![](https://i0.wp.com/supersimple365.com/wp-content/uploads/2024/07/image-35.png?resize=696%2C195&ssl=1)
Availability
Due late June to late July 2024.
Source, related links, and references
MC816207.
365 Roadmap ID 374909.
Image(s): Microsoft.
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.
🎦 Want to find innovative ways to drive efficiency across your organisation using the M365 apps you are already paying for, using just one person? Re-watch my webinar with The Inform Team: ‘Efficiency at its finest: Making sure innovation is at the heart of your organisation’. Watch on YouTube (30 mins).