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

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 is replacing the old data sync solution with a new, more reliable one. Users must manually migrate to the new solution before January 13, 2025, for commercial users and February 13, 2025, for GCC. After deprecation, existing workbooks will not receive new responses unless migrated. Migration support and notifications will be provided.

Details:
Updated January 21, 2025: The deprecation for old data sync solution will start from Jan 20th, 2025. For GCC, the deprecation will start from Feb 13th, 2025.
After the old data sync solution has been deprecated, existing Excel workbooks using the old data sync solution will no longer receive new responses. Users can still migrate these existing Excel workbooks to the new data sync solution to receive new responses when needed.
For each form using the old syncing solution, users can migrate the form according to the instructions provided in Forms and Excel for the web. More details can be found here: Update to the new solution for syncing forms responses to Excel - Microsoft Community Hub.
If users are using the old data sync solution in a workflow that relies on the Excel workbook being updated automatically without any user action, they will be impacted by the change as the Excel file will only get updated when it's opened in a supported Excel client. These users will have to manually update their workflow. Our suggested solution is to use Power Automate: Setting Up an Automated Workflow Between Microsoft Forms and Excel Through Power Automate - Microsoft Support
If a form using the old syncing solution is still receiving new responses, the form owner (a user or a group) will get an email notification about migrating their form. Some form owners might have already received these emails. Form owners will receive at most one email for each form they own.
The old data sync solution deprecation only impacts commercial users.
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 and for GCC on February 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 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 mid-January 2025 (previously early January). We expect to complete by late January 2025 (previously 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:
2025-01-23

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**

XXXXXXX ... free basic plan only

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
2025-01-23MC MessagesUpdated January 16, 2025: The deprecation for old data sync solution will start from Jan 20th, 2025. For GCC, the deprecation will start from Feb 13th, 2025.
After the old data sync solution has been deprecated, existing Excel workbooks using the old data sync solution will no longer receive new responses. Users can still migrate these existing Excel workbooks to the new data sync solution to receive new responses when needed.
For each form using the old syncing solution, users can migrate the form according to the instructions provided in Forms and Excel for the web. More details can be found here: Update to the new solution for syncing forms responses to Excel - Microsoft Community Hub.
If users are using the old data sync solution in a workflow that relies on the Excel workbook being updated automatically without any user action, they will be impacted by the change as the Excel file will only get updated when it's opened in a supported Excel client. These users will have to manually update their workflow. Our suggested solution is to use Power Automate: Setting Up an Automated Workflow Between Microsoft Forms and Excel Through Power Automate - Microsoft Support
If a form using the old syncing solution is still receiving new responses, the form owner (a user or a group) will get an email notification about migrating their form. Some form owners might have already received these emails. Form owners will receive at most one email for each form they own.
The old data sync solution deprecation only impacts commercial users.
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 and for GCC on February 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 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 early January 2025 (previously late November). We expect to complete by late January 2025 (previously mid-December 2024).
Updated January 21, 2025: The deprecation for old data sync solution will start from Jan 20th, 2025. For GCC, the deprecation will start from Feb 13th, 2025.
After the old data sync solution has been deprecated, existing Excel workbooks using the old data sync solution will no longer receive new responses. Users can still migrate these existing Excel workbooks to the new data sync solution to receive new responses when needed.
For each form using the old syncing solution, users can migrate the form according to the instructions provided in Forms and Excel for the web. More details can be found here: Update to the new solution for syncing forms responses to Excel - Microsoft Community Hub.
If users are using the old data sync solution in a workflow that relies on the Excel workbook being updated automatically without any user action, they will be impacted by the change as the Excel file will only get updated when it's opened in a supported Excel client. These users will have to manually update their workflow. Our suggested solution is to use Power Automate: Setting Up an Automated Workflow Between Microsoft Forms and Excel Through Power Automate - Microsoft Support
If a form using the old syncing solution is still receiving new responses, the form owner (a user or a group) will get an email notification about migrating their form. Some form owners might have already received these emails. Form owners will receive at most one email for each form they own.
The old data sync solution deprecation only impacts commercial users.
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 and for GCC on February 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 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 mid-January 2025 (previously early January). We expect to complete by late January 2025 (previously mid-December 2024).
2025-01-23MC Last Updated01/16/2025 23:30:522025-01-22T17:24:30Z
2025-01-23MC SummaryThe message details Microsoft Forms' transition from an old data sync solution to a new one, with deprecation starting January 20, 2025, and February 13, 2025, for GCC. Users must migrate to the new solution to continue receiving form responses in Excel. Instructions and support are provided for migration, with notifications for form owners and impacts outlined for automated workflows. The change affects commercial users only.Microsoft Forms is replacing the old data sync solution with a new, more reliable one. Users must manually migrate to the new solution before January 13, 2025, for commercial users and February 13, 2025, for GCC. After deprecation, existing workbooks will not receive new responses unless migrated. Migration support and notifications will be provided.
2025-01-17MC MessagesUpdated January 7, 2025: 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 and for GCC on February 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 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 early January 2025 (previously late November). We expect to complete by late January 2025 (previously mid-December 2024).
Updated January 16, 2025: The deprecation for old data sync solution will start from Jan 20th, 2025. For GCC, the deprecation will start from Feb 13th, 2025.
After the old data sync solution has been deprecated, existing Excel workbooks using the old data sync solution will no longer receive new responses. Users can still migrate these existing Excel workbooks to the new data sync solution to receive new responses when needed.
For each form using the old syncing solution, users can migrate the form according to the instructions provided in Forms and Excel for the web. More details can be found here: Update to the new solution for syncing forms responses to Excel - Microsoft Community Hub.
If users are using the old data sync solution in a workflow that relies on the Excel workbook being updated automatically without any user action, they will be impacted by the change as the Excel file will only get updated when it's opened in a supported Excel client. These users will have to manually update their workflow. Our suggested solution is to use Power Automate: Setting Up an Automated Workflow Between Microsoft Forms and Excel Through Power Automate - Microsoft Support
If a form using the old syncing solution is still receiving new responses, the form owner (a user or a group) will get an email notification about migrating their form. Some form owners might have already received these emails. Form owners will receive at most one email for each form they own.
The old data sync solution deprecation only impacts commercial users.
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 and for GCC on February 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 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 early January 2025 (previously late November). We expect to complete by late January 2025 (previously mid-December 2024).
2025-01-17MC Last Updated01/07/2025 23:37:142025-01-16T23:30:52Z
2025-01-17MC 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
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://support.microsoft.com/office/setting-up-an-automated-workflow-between-microsoft-forms-and-excel-through-power-automate-b59076a5-abe6-4659-8bb3-28076b3a9a7e
https://techcommunity.microsoft.com/blog/microsoftformsblog/update-to-the-new-solution-for-syncing-forms-responses-to-excel/4229844#M2155
https://techcommunity.microsoft.com/t5/microsoft-forms-blog/introducing-forms-data-sync-to-excel/ba-p/4036051
2025-01-17MC SummaryMicrosoft Forms introduces a new data sync solution for Excel, replacing the older version by January 13, 2025. Users must manually update to the new solution before this date. Notifications and support for migration will be provided, with automatic rollout and no admin action required. Rollout begins late October 2024 for worldwide users and early January 2025 for GCC users.The message details Microsoft Forms' transition from an old data sync solution to a new one, with deprecation starting January 20, 2025, and February 13, 2025, for GCC. Users must migrate to the new solution to continue receiving form responses in Excel. Instructions and support are provided for migration, with notifications for form owners and impacts outlined for automated workflows. The change affects commercial users only.
2025-01-08MC Last Updated11/20/2024 23:56:392025-01-07T23:37:14Z
2025-01-08MC MessagesUpdated 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.
Updated January 7, 2025: 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 and for GCC on February 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 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 early January 2025 (previously late November). We expect to complete by late January 2025 (previously mid-December 2024).
2025-01-08MC End Time01/27/2025 09:00:002025-03-03T09:00:00Z
2025-01-08MC SummaryMicrosoft 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.Microsoft Forms introduces a new data sync solution for Excel, replacing the older version by January 13, 2025. Users must manually update to the new solution before this date. Notifications and support for migration will be provided, with automatic rollout and no admin action required. Rollout begins late October 2024 for worldwide users and early January 2025 for GCC users.
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 3 weeks ago

Share to MS Teams

Login to your account

Welcome Back, We Missed You!