Microsoft Forms: New data sync solution for Microsoft Excel for the web in Microsoft SharePoint Online and OneDrive

Microsoft Forms will soon introduce a new data sync solution for Excel on the web in SharePoint Online and OneDrive, replacing the old sync method. Rollout starts mid-October 2024 and should complete by mid-November 2024. This feature will be default and requires no admin action before rollout.

In July 2024, we communicated in MC816207 that Microsoft Forms supports live data sync to Microsoft Excel with more functionality.

Coming soon: A new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. New Forms created from Microsoft OneDrive and Microsoft SharePoint online after this rollout will use the new data sync solution.

When this will happen:

General Availability (Worldwide): We will begin rolling out mid-October 2024 and expect to complete by mid-November 2024.

How this will affect your organization:

Before this rollout, Forms created from OneDrive and SharePoint Online used the old data sync solution. The Excel file was created automatically when creating the forms, and the Forms data was pushed to Excel file through Graph API.

With this rollout, Forms created from OneDrive and SharePoint Online will use the new data sync solution. The Excel file will not be created automatically. The user can create the Excel file from the Forms result page after responses have been received.

Workflow

1. Create a new form from SharePoint Online or OneDrive for business: Select New > Forms survey (before rollout, this was called Forms for Excel).

user controlsView image in new tab

2. After receiving responses to the form, create an Excel file from the Forms result page to sync the data:

user controlsView image in new tab

This feature will be on by default.

3. The Excel file will be created in the SharePoint folder where the form was created.

user controlsView image in new tab

Note: The new data sync can only be triggered in Excel for the web. If users want to receive new Forms response data in the Excel desktop app, open the file in Excel for the web, and then wait for the desktop app file to sync from the web file. (Support for other versions of Excel is in progress.)

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.

Learn more: Create a form with Microsoft Forms – Microsoft Support (will be updated before rollout begins)

Message ID: MC901820


Comments are closed.


I've been working with Microsoft Technologies over the last ten years, mainly focused on creating collaboration and productivity solutions that drive the adoption of Microsoft Modern Workplace.

%d bloggers like this: