MC855685 – Microsoft Forms | Data sync to Microsoft Excel: Support for migrating from the older solution to the new solution

OneDrive for Business logo

*For this entry exists the more relevant or more recent entry (MC943681)

check before: 2024-08-31

Product:

Forms, Microsoft 365 Apps, Microsoft 365 Groups, OneDrive, Power Automate, SharePoint, Teams

Platform:

Online, US Instances, Web, Windows Desktop, World tenant

Status:

Rolling out

Change type:

Feature update, Retirement, Updated message, User impact

Links:

(MC943681)
MC816207
410988

Details:

Summary:
Microsoft Forms introduces a new data sync to Excel for the web, replacing the older version by January 13, 2025. Users must manually update to the new solution before this date. Notifications and support for migration are provided, with automatic rollout starting in late October 2024.

Details:
Updated November 20, 2024: We have updated the images and rollout timeline below. Thank you for your patience.
As communicated in MC816207 Microsoft Forms now supports live data sync to Microsoft Excel with more functionality (July 2024), Microsoft Forms is introducing a new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. Before this rollout. Forms supported an older version of live data sync to Excel. The older version of live data sync will be replaced by the newer solution on January 13, 2025. This message describes the support that we will provide for migrating from the older solution to the newer solution.
This message is associated with Microsoft 365Roadmap ID 410988.
[When this will happen:]
General Availability (Worldwide): Support for migrating the older data sync to the new solution will begin rolling out in late October 2024 (previously early October). We expect to complete by late November 2024 (previously early October).
General Availability (GCC) Support for migrating the older data sync to the new solution will begin rolling out in late November 2024. We expect to complete by mid-December 2024.

Change Category:
XXXXXXX ... free basic plan only

Scope:
XXXXXXX ... free basic plan only

Release Phase:
General Availability, Preview

Created:
2024-08-09

updated:
2024-11-21

Public Preview Start Date

XXXXXXX ... free basic plan only

Task Type

XXXXXXX ... free basic plan only

Docu to Check

XXXXXXX ... free basic plan only

MS How does it affect me

XXXXXXX ... free basic plan only

MS Preperations

XXXXXXX ... free basic plan only

MS Urgency

XXXXXXX ... free basic plan only

MS workload name

XXXXXXX ... free basic plan only

linked item details

XXXXXXX ... free basic plan only

Pictures

XXXXXXX ... free basic plan only

summary for non-techies**

Microsoft Forms is upgrading its data sync feature with Microsoft Excel, retiring the older version by January 13, 2025, requiring users to transition to the new system for automatic updates and compatibility with workflows like Power Automate.

Direct effects for Operations**

Please, look at the most relevant linked item for details

explanation for non-techies**

XXXXXXX ... free basic plan only

** AI generated content. This information must be reviewed before use.

a free basic plan is required to see more details. Sign up here


A cloudsocut.one plan is required to see all the changed details. If you are already a customer, choose login.
If you are new to cloudscout.one please choose a plan.



change history

DatePropertyoldnew
2024-11-21MC Last Updated11/18/2024 17:58:392024-11-20T23:56:39Z
2024-11-21MC MessagesUpdated November 7, 2024: We have updated the images and rollout timeline below. Thank you for your patience.
As communicated in MC816207 Microsoft Forms now supports live data sync to Microsoft Excel with more functionality (July 2024), Microsoft Forms is introducing a new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. Before this rollout. Forms supported an older version of live data sync to Excel. The older version of live data sync will be replaced by the newer solution on January 13, 2025. This message describes the support that we will provide for migrating from the older solution to the newer solution.
This message is associated with Microsoft 365Roadmap ID 410988.
[When this will happen:]
General Availability (Worldwide, GCC): Support for migrating the older data sync to the new solution will begin rolling out in late October 2024 (previously early October), and we expect to complete by late November 2024 (previously early October).
Updated November 20, 2024: We have updated the images and rollout timeline below. Thank you for your patience.
As communicated in MC816207 Microsoft Forms now supports live data sync to Microsoft Excel with more functionality (July 2024), Microsoft Forms is introducing a new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. Before this rollout. Forms supported an older version of live data sync to Excel. The older version of live data sync will be replaced by the newer solution on January 13, 2025. This message describes the support that we will provide for migrating from the older solution to the newer solution.
This message is associated with Microsoft 365Roadmap ID 410988.
[When this will happen:]
General Availability (Worldwide): Support for migrating the older data sync to the new solution will begin rolling out in late October 2024 (previously early October). We expect to complete by late November 2024 (previously early October).
General Availability (GCC) Support for migrating the older data sync to the new solution will begin rolling out in late November 2024. We expect to complete by mid-December 2024.
2024-11-21MC End Time01/06/2025 09:00:002025-01-27T09:00:00Z
2024-11-19MC MessagesUpdated November 7, 2024: We have updated the images and rollout timeline below. Thank you for your patience.
As communicated in MC816207 Microsoft Forms now supports live data sync to Microsoft Excel with more functionality (July 2024), Microsoft Forms is introducing a new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. Before this rollout. Forms supported an older version of live data sync to Excel. The older version of live data sync will be replaced by the newer solution on January 13, 2025. This message describes the support that we will provide for migrating from the older solution to the newer solution.
This message is associated with Microsoft 365Roadmap ID 410988.
[When this will happen:]
General Availability (Worldwide): Support for migrating the older data sync to the new solution will begin rolling out in late October 2024 (previously early October), and we expect to complete by late November 2024 (previously early October).
Updated November 7, 2024: We have updated the images and rollout timeline below. Thank you for your patience.
As communicated in MC816207 Microsoft Forms now supports live data sync to Microsoft Excel with more functionality (July 2024), Microsoft Forms is introducing a new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. Before this rollout. Forms supported an older version of live data sync to Excel. The older version of live data sync will be replaced by the newer solution on January 13, 2025. This message describes the support that we will provide for migrating from the older solution to the newer solution.
This message is associated with Microsoft 365Roadmap ID 410988.
[When this will happen:]
General Availability (Worldwide, GCC): Support for migrating the older data sync to the new solution will begin rolling out in late October 2024 (previously early October), and we expect to complete by late November 2024 (previously early October).
2024-11-19MC Last Updated11/08/2024 01:04:092024-11-18T17:58:39Z
2024-11-08MC MessagesUpdated October 9, 2024: We have updated the images and rollout timeline below. Thank you for your patience.
As communicated in MC816207 Microsoft Forms now supports live data sync to Microsoft Excel with more functionality (July 2024), Microsoft Forms is introducing a new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. Before this rollout. Forms supported an older version of live data sync to Excel. The older version of live data sync will be replaced by the newer solution on January 13, 2025. This message describes the support that we will provide for migrating from the older solution to the newer solution.
This message is associated with Microsoft 365Roadmap ID 410988.
[When this will happen:]
General Availability (Worldwide): Support for migrating the older data sync to the new solution will begin rolling out in late October 2024 (previously early October), and we expect to complete by late November 2024 (previously early October).
Updated November 7, 2024: We have updated the images and rollout timeline below. Thank you for your patience.
As communicated in MC816207 Microsoft Forms now supports live data sync to Microsoft Excel with more functionality (July 2024), Microsoft Forms is introducing a new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. Before this rollout. Forms supported an older version of live data sync to Excel. The older version of live data sync will be replaced by the newer solution on January 13, 2025. This message describes the support that we will provide for migrating from the older solution to the newer solution.
This message is associated with Microsoft 365Roadmap ID 410988.
[When this will happen:]
General Availability (Worldwide): Support for migrating the older data sync to the new solution will begin rolling out in late October 2024 (previously early October), and we expect to complete by late November 2024 (previously early October).
2024-11-08MC How AffectUsers who rely on the older version to sync data from Forms to Excel will need to manually update the data sync to the new solution before January 13, 2025 (previously October 20, 2024). After this date, existing Excel files with the older data sync will be retained but will no longer receive automatic data updates from Forms.

The older version of the data sync exists in two types of Forms:
Forms created from Microsoft OneDrive and Excel for the web
Group forms created with SharePoint Online, Microsoft Teams, and Microsoft 365 Groups.
For these two types of Forms, we will provide this support to migrate to the new solution:
Users who own Forms with the older version of the data sync will get notifications through email, Forms, and Excel for the web.
In Forms, users will be able to recreate the data sync with the new solution. A new worksheet will be created in the same workbook as the older data sync. The new worksheet will be connected to the latest data from Forms.
After the older solution is retired, the user can still recreate a new data sync to the Excel workbook.
For workflows that connect to Excel data from Forms responses (such as Power Automate workflows), users will need to update the workflow to the Forms connector for new response updates. Learn more: Create an automated workflow for Microsoft Forms - Microsoft Support

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

The new data sync solution will be on by default and available to all Forms and Excel for the web customers.
Notification in Forms to update workbook to continue syncing with Forms:


Notification in Excel for the web to update the data sync to new solution:


Excel workbook is successfully updated to new solution
Users who rely on the older version to sync data from Forms to Excel will need to manually update the data sync to the new solution before January 13, 2025 (previously October 20, 2024). After this date, existing Excel files with the older data sync will be retained but will no longer receive automatic data updates from Forms.

The older version of the data sync exists in two types of Forms:
Forms created from Microsoft OneDrive and Excel for the web
Group forms created with SharePoint Online, Microsoft Teams, and Microsoft 365 Groups.
For these two types of Forms, we will provide this support to migrate to the new solution:
Users who own Forms with the older version of the data sync will get notifications through email, Forms, and Excel for the web.
In Forms, users will be able to recreate the data sync with the new solution. The data sync will be created to the same table in the existing workbook as the older data sync. The new worksheet will be connected to the latest data from Forms.
After the older solution is retired, the user can still recreate a new data sync to the Excel workbook.
For workflows that connect to Excel data from Forms responses (such as Power Automate workflows), users will need to update the workflow to the Forms connector for new response updates. Learn more: Create an automated workflow for Microsoft Forms - Microsoft Support

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

The new data sync solution will be on by default and available to all Forms and Excel for the web customers.
Notification in Forms to update workbook to continue syncing with Forms:


Notification in Excel for the web to update the data sync to new solution:


Excel workbook is successfully updated to new solution
2024-11-08MC Last Updated10/10/2024 01:05:102024-11-08T01:04:09Z
2024-11-08MC SummaryMicrosoft Forms has updated its data sync to Excel with a new, more reliable solution. Users must manually migrate to the new solution before January 13, 2025. Notifications and support for migration are provided. Rollout begins late October 2024, with completion expected by late November 2024.Microsoft Forms introduces a new data sync to Excel for the web, replacing the older version by January 13, 2025. Users must manually update to the new solution before this date. Notifications and support for migration are provided, with automatic rollout starting in late October 2024.
2024-10-10MC Last Updated09/19/2024 00:37:002024-10-10T01:05:10Z
2024-10-10MC MessagesUpdated September 18, 2024: We have updated the images and rollout timeline below. Thank you for your patience.
As communicated in MC816207 Microsoft Forms now supports live data sync to Microsoft Excel with more functionality (July 2024), Microsoft Forms is introducing a new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. Before this rollout. Forms supported an older version of live data sync to Excel. The older version of live data sync will be replaced by the newer solution on January 13, 2025. This message describes the support that we will provide for migrating from the older solution to the newer solution.
This message is associated with Microsoft 365 Roadmap ID 410988.
[When this will happen:]
General Availability (Worldwide): Support for migrating the older data sync to the new solution will begin rolling out late September 2024 (previously late August), and we expect to complete by early October 2024 (previously early September).
Updated October 9, 2024: We have updated the images and rollout timeline below. Thank you for your patience.
As communicated in MC816207 Microsoft Forms now supports live data sync to Microsoft Excel with more functionality (July 2024), Microsoft Forms is introducing a new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. Before this rollout. Forms supported an older version of live data sync to Excel. The older version of live data sync will be replaced by the newer solution on January 13, 2025. This message describes the support that we will provide for migrating from the older solution to the newer solution.
This message is associated with Microsoft 365Roadmap ID 410988.
[When this will happen:]
General Availability (Worldwide): Support for migrating the older data sync to the new solution will begin rolling out in late October 2024 (previously early October), and we expect to complete by late November 2024 (previously early October).
2024-10-10MC SummaryMicrosoft Forms will replace the older data sync to Excel with a new, more reliable solution on January 13, 2025. Users must manually migrate to the new solution, which will be available worldwide starting late September 2024. Notifications and support for migration will be provided. Rollout completion is expected by mid-January 2025.Microsoft Forms has updated its data sync to Excel with a new, more reliable solution. Users must manually migrate to the new solution before January 13, 2025. Notifications and support for migration are provided. Rollout begins late October 2024, with completion expected by late November 2024.
2024-10-10MC End Time11/29/2024 09:00:002025-01-06T09:00:00Z
2024-10-10MC prepareSend a notification to impacted users and groups to migrate their data syncs to new solution.
Share the migration solution if users report they cannot get Forms data updated in Excel.
Learn more: Introducing Forms data sync to Excel - Microsoft Community Hub
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.
Before rollout, we will update this post with revised documentation.
https://support.microsoft.com/office/create-an-automated-workflow-for-microsoft-forms-dee28c00-503a-48b3-89df-91a5084e6e43
https://techcommunity.microsoft.com/t5/microsoft-forms-blog/introducing-forms-data-sync-to-excel/ba-p/4036051
https://www.microsoft.com/microsoft-365/roadmap?filters=&searchterms=410988
Send a notification to impacted users and groups to migrate their data syncs to new solution.
Share the migration solution if users report they cannot get Forms data updated in Excel.
Learn more: Introducing Forms data sync to Excel - Microsoft Community Hub
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.
Before rollout, we will update this post with revised documentation.
https://support.microsoft.com/office/create-an-automated-workflow-for-microsoft-forms-dee28c00-503a-48b3-89df-91a5084e6e43
https://techcommunity.microsoft.com/t5/microsoft-forms-blog/introducing-forms-data-sync-to-excel/ba-p/4036051
2024-09-19MC MessagesUpdated September 13, 2024: We have updated the rollout timeline below. Thank you for your patience.
As communicated in MC816207 Microsoft Forms now supports live data sync to Microsoft Excel with more functionality (July 2024), Microsoft Forms is introducing a new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. Before this rollout. Forms supported an older version of live data sync to Excel. The older version of live data sync will be replaced by the newer solution on January 13, 2025. This message describes the support that we will provide for migrating from the older solution to the newer solution.
This message is associated with Microsoft 365 Roadmap ID 410988.
[When this will happen:]
General Availability (Worldwide): Support for migrating the older data sync to the new solution will begin rolling out late September 2024 (previously late August), and we expect to complete by early October 2024 (previously early September).
Updated September 18, 2024: We have updated the images and rollout timeline below. Thank you for your patience.
As communicated in MC816207 Microsoft Forms now supports live data sync to Microsoft Excel with more functionality (July 2024), Microsoft Forms is introducing a new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. Before this rollout. Forms supported an older version of live data sync to Excel. The older version of live data sync will be replaced by the newer solution on January 13, 2025. This message describes the support that we will provide for migrating from the older solution to the newer solution.
This message is associated with Microsoft 365 Roadmap ID 410988.
[When this will happen:]
General Availability (Worldwide): Support for migrating the older data sync to the new solution will begin rolling out late September 2024 (previously late August), and we expect to complete by early October 2024 (previously early September).
2024-09-19MC How AffectUsers who rely on the older version to sync data from Forms to Excel will need to manually update the data sync to the new solution after October 20, 2024. After this date, existing Excel files with the older data sync will be retained but will no longer receive automatic data updates from Forms.

The older version of the data sync exists in two types of Forms:
Forms created from Microsoft OneDrive and Excel for the web
Group forms created with SharePoint Online, Microsoft Teams, and Microsoft 365 Groups.
For these two types of Forms, we will provide this support to migrate to the new solution:
Users who own Forms with the older version of the data sync will get notifications through email, Forms, and Excel for the web.
In Forms, users will be able to recreate the data sync with the new solution. A new worksheet will be created in the same workbook as the older data sync. The new worksheet will be connected to the latest data from Forms.
After the older solution is retired, the user can still recreate a new data sync to the Excel workbook.
For workflows that connect to Excel data from Forms responses (such as Power Automate workflows), users will need to update the workflow to the Forms connector for new response updates. Learn more: Create an automated workflow for Microsoft Forms - Microsoft Support

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

The new data sync solution will be on by default and available to all Forms and Excel for the web customers.
Notification in Forms to update workbook to continue syncing with Forms:

Notification in Excel for the web to update the data sync to new solution:

Excel workbook is successfully updated to new solution
Users who rely on the older version to sync data from Forms to Excel will need to manually update the data sync to the new solution before January 13, 2025 (previously October 20, 2024). After this date, existing Excel files with the older data sync will be retained but will no longer receive automatic data updates from Forms.

The older version of the data sync exists in two types of Forms:
Forms created from Microsoft OneDrive and Excel for the web
Group forms created with SharePoint Online, Microsoft Teams, and Microsoft 365 Groups.
For these two types of Forms, we will provide this support to migrate to the new solution:
Users who own Forms with the older version of the data sync will get notifications through email, Forms, and Excel for the web.
In Forms, users will be able to recreate the data sync with the new solution. A new worksheet will be created in the same workbook as the older data sync. The new worksheet will be connected to the latest data from Forms.
After the older solution is retired, the user can still recreate a new data sync to the Excel workbook.
For workflows that connect to Excel data from Forms responses (such as Power Automate workflows), users will need to update the workflow to the Forms connector for new response updates. Learn more: Create an automated workflow for Microsoft Forms - Microsoft Support

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

The new data sync solution will be on by default and available to all Forms and Excel for the web customers.
Notification in Forms to update workbook to continue syncing with Forms:


Notification in Excel for the web to update the data sync to new solution:


Excel workbook is successfully updated to new solution
2024-09-19MC Last Updated09/14/2024 00:41:582024-09-19T00:37:00Z
2024-09-19MC SummaryMicrosoft Forms introduces a new, more reliable data sync to Excel for the web, replacing the older version on January 13, 2025. Migration support begins late September 2024. Users must manually update to the new solution after October 20, 2024, to continue syncing data from Forms to Excel. Notifications and support for migration will be provided. The message is associated with Microsoft 365 Roadmap ID 410988.Microsoft Forms will replace the older data sync to Excel with a new, more reliable solution on January 13, 2025. Users must manually migrate to the new solution, which will be available worldwide starting late September 2024. Notifications and support for migration will be provided. Rollout completion is expected by mid-January 2025.
2024-09-14MC Last Updated08/09/2024 00:57:092024-09-14T00:41:58Z
2024-09-14MC MessagesAs communicated in MC816207 Microsoft Forms now supports live data sync to Microsoft Excel with more functionality (July 2024), Microsoft Forms is introducing a new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. Before this rollout. Forms supported an older version of live data sync to Excel. The older version of live data sync will be replaced by the newer solution on October 20, 2024. This message describes the support that we will provide for migrating from the older solution to the newer solution.
This message is associated with Microsoft 365 Roadmap ID 410988.
[When this will happen:]
General Availability (Worldwide): Support for migrating the older data sync to the new solution will begin rolling out late August 2024, and we expect to complete by early September 2024.
Updated September 13, 2024: We have updated the rollout timeline below. Thank you for your patience.
As communicated in MC816207 Microsoft Forms now supports live data sync to Microsoft Excel with more functionality (July 2024), Microsoft Forms is introducing a new data sync solution with higher reliability to sync Forms response data to Microsoft Excel for the web. Before this rollout. Forms supported an older version of live data sync to Excel. The older version of live data sync will be replaced by the newer solution on January 13, 2025. This message describes the support that we will provide for migrating from the older solution to the newer solution.
This message is associated with Microsoft 365 Roadmap ID 410988.
[When this will happen:]
General Availability (Worldwide): Support for migrating the older data sync to the new solution will begin rolling out late September 2024 (previously late August), and we expect to complete by early October 2024 (previously early September).
2024-09-14MC MessageTagNamesFeature update, User impact, RetirementUpdated message, Feature update, User impact, Retirement
2024-09-14MC SummaryMicrosoft Forms introduces a new data sync to Excel for the web, replacing the older version by October 20, 2024. Migration support starts late August 2024. Users must manually update to the new solution to continue receiving data updates after the retirement of the older version.Microsoft Forms introduces a new, more reliable data sync to Excel for the web, replacing the older version on January 13, 2025. Migration support begins late September 2024. Users must manually update to the new solution after October 20, 2024, to continue syncing data from Forms to Excel. Notifications and support for migration will be provided. The message is associated with Microsoft 365 Roadmap ID 410988.

Last updated 1 week ago

Share to MS Teams

Login to your account

Welcome Back, We Missed You!