Data Import & Export

How to Fix Microsoft Forms Responses Syncing to a New Excel Workbook

Emma Brown Sep 30, 2026 869 views

Question details

User wants to keep Microsoft Forms responses synchronized to an existing Excel workbook rather than repeatedly being forced to create or select a new one.

How to Fix Microsoft Forms Responses Syncing to a New Excel Workbook

Product: Microsoft Forms and Microsoft Excel
Device & OS: not provided
Scenario: Syncing collected form responses to a single Excel workbook for ongoing data collection and analysis.
Observed behavior: The synchronization between Microsoft Forms and the original Excel workbook breaks, causing the system to continuously prompt for or create a brand new workbook for new responses.

Before you start

Ensure you have an active Microsoft 365 account with permissions to access Microsoft Forms, Power Automate, and the SharePoint/OneDrive folder where your workbook is stored.

Solution 1Recommended

Use Power Automate to Sync Responses to an Existing Workbook

Since the native sync feature can intermittently fail, creating a Power Automate flow provides a reliable workaround to push new form responses directly into your specified Excel file.

Power Automate allows you to create a customized workflow that bypasses the native Forms-to-Excel sync. By setting up this automation, every new response will be automatically added as a new row in your existing workbook.

Create a new automated flow

Log into Microsoft Power Automate, click 'Create' on the left sidebar, and select 'Automated cloud flow'.

Set the trigger to Microsoft Forms

Name your flow, search for the trigger 'When a new response is submitted' under Microsoft Forms, and click Create. Select your form from the Form Id dropdown.

Get response details

Click 'New step', search for 'Get response details' (Microsoft Forms), select your form again, and choose 'Response Id' from the dynamic content list.

Add a row to your Excel table

Click 'New step', search for 'Add a row into a table' under Excel Online (Business). Select the location, document library, your target Excel file, and the specific table inside that file.

Map the fields and save

Click inside each Excel column field and select the corresponding Form question from the dynamic content menu. Once mapped, click 'Save' and test your flow.

Use Power Automate to Sync Responses to an Existing Workbook

Preparation required: Ensure your destination Excel workbook already contains a formatted Table (Insert > Table) with column headers matching your form questions before setting up the flow.

Solution 2

Verify Sync Status and Escalate to IT Admin

Check the connection status in Microsoft Forms and open an official Microsoft 365 service request if the native sync feature is corrupted across multiple forms.

Free Microsoft Office alternative

Manage and Analyze Your Exported Data with WPS Office

While resolving Microsoft 365 cloud sync issues may require administrative support, you can rely on WPS Office as a fast, free, and highly compatible alternative for analyzing your exported form data.

1. Download and Install: Visit the official WPS website to download and install WPS Office for free on your device.
2. Open Your Exported Data: Launch WPS Spreadsheet and open the .xlsx file generated from your Microsoft Forms responses.
3. Analyze Effortlessly: Utilize robust sorting, filtering, and pivot table features to process your collected data without needing a premium subscription.

Completely free Microsoft Office alternative with a familiar, user-friendly interface.100% format compatibility with Microsoft Excel (.xlsx, .xls, .csv).Lightweight software that runs smoothly on Windows, Mac, and Linux.Powerful built-in tools for data analysis, pivot tables, and charting.

Frequently Asked Questions

Why does Microsoft Forms force me to create a new Excel workbook?

This typically occurs when the synchronization link between the Form and the original Excel file is broken. Common causes include moving the Excel file to a different folder, renaming the file, modifying table structures, or experiencing temporary server-side glitches in Microsoft 365.

How do I check if my Form is still actively syncing to Excel?

Open your form in the web browser, go to the 'Responses' tab, and inspect the 'Open in Excel' button. A cloud icon superimposed on the Excel logo indicates it is actively syncing to an online workbook. A plain icon usually means the link is severed and it will just download a static copy.

Can I manually relink an existing Excel workbook to my Form?

Microsoft Forms does not currently offer a native 're-link' button for broken workbooks. If the sync is permanently broken, the most reliable workaround is to use Microsoft Power Automate to automatically push new form submissions into your preferred existing Excel file.

Excel & Data Problems