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

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).

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

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

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.)

This feature will be on by default.

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)