Microsoft Forms fixes one of the biggest issues with syncing data to Excel
Microsoft is rolling out a new syncing solution that keeps data in sync across Forms and Excel for the web.
When you purchase through links on our site, we may earn an affiliate commission.Here’s how it works.
What you need to know
Keeping up to date with Microsoft Forms responses is about to get better and more reliable.Microsoft just announcedan improved syncing solution for keeping data in sync between Microsoft Forms and Microsoft Excel.
Until now, some forms relied on an older syncing solution that left room for improvement regarding reliability and performance. Additionally, data sync was only available for two types of forms: Forms made with OneDrive for Business and Excel for the web and group forms made with SharePoint Online, Teams, and Microsoft 365 Group. The new syncing solution works with a wider range of forms.
The older syncing solution is being phased out and will be replaced by October 20, 2024. Ahead of that cutoff, you’ll need to upgrade any current workbooks to the new syncing solution if you’d like data to continue to be synced. If you don’t upgrade a workbook, the data will still be there, but it won’t be updated with new responses from Microsoft Forms.
🎒The best Back to School deals📝
If you open a form that uses the old syncing solution through the Forms website, you’ll see a pop up prompting you to upgrade the form. Clicking “Update sync in Excel” will complete the process. Upgrading syncing through Excel on the web requires a similar process, though the prompt will appear in the pane on the right side of Excel. If you upgrade through Excel on the web, the workbook will create a second sheet so you can see the original data and the data that’s now powered by the new syncing solution.
At the moment, syncing only works with Excel for the web but Microsoft is working on bringing the same functionality to Excel for Windows and macOS.
If you’re unsure if a workbook has been upgraded, you can check by looking at the UI that appears when viewing results. If Forms shows “Open in Excel” with an ellipsis menu, you’re on the old sync solution.
Improving Microsoft Forms
I use Microsoft Forms quite a bit to track responses from my American football team. I have photo release forms, team quizzes, and other bits of information I need to stay on top of when managing my team. Having responses sync with workbooks reliably saves me from using incomplete or incorrect data. It also prevents confusion created by juggling several static workbooks based on the same forms.
Get the Windows Central Newsletter
All the latest news, reviews, and guides for Windows and Xbox diehards.
I’ve played around with the new syncing solution a bit and it seems to work as advertised. I have some forms with hundreds of responses that I need to be able to browse ahead of games. For example, since my team has players under the age of 18, I have to have certain forms filled out by parents or guardians. Being able to trust that those forms are up to date before a specific event is key to my team.
Sean Endicott is a tech journalist at Windows Central, specializing in Windows, Microsoft software, AI, and PCs. He’s covered major launches, from Windows 10 and 11 to the rise of AI tools like ChatGPT. Sean’s journey began with the Lumia 740, leading to strong ties with app developers. Outside writing, he coaches American football, utilizing Microsoft services to manage his team. He studied broadcast journalism at Nottingham Trent University and is active on X @SeanEndicott_ and Threads @sean_endicott_.
