Data Import & Export

How to Automatically Send Microsoft Forms Responses to Multiple Excel Sheets

Elise Williams Sep 30, 2026 869 views

Question details

The user wants to automatically copy and update Microsoft Form responses across multiple Excel worksheets upon receiving new form submissions.

How to Automatically Send Microsoft Forms Responses to Multiple Excel Sheets

Product: Microsoft Excel
Device & OS: not provided
Scenario: Managing incoming form data and distributing it across different worksheets for centralized analysis or tracking.
Observed behavior: New form submissions need to be instantly populated into designated tables across multiple Excel sheets without manual copying.

Before you start

Ensure your destination Excel workbook is saved in a cloud location like OneDrive or SharePoint, and verify that the destination ranges in your worksheets are formatted as official Excel tables.

Solution 1Recommended

Use Power Automate to Sync Responses to Multiple Excel Tables

Set up a Microsoft Power Automate flow to trigger on new form submissions and automatically add rows to multiple designated Excel worksheets.

By leveraging Power Automate, you can create a workflow that listens for new submissions in Microsoft Forms and duplicates the data across as many Excel tables as you need.

Create a new automated flow

Log into Microsoft Power Automate and click on 'Create', then select 'Automated cloud flow'. Name your flow and choose the trigger 'When a new response is submitted' under Microsoft Forms.

Get response details

Click 'New step' and add the 'Get response details' action. Select your specific form from the dropdown menu and map the 'Response ID' from the dynamic content.

Add a row into the first Excel table

Add another step and choose 'Add a row into a table' from the Excel Online (Business) connector. Select your cloud location (OneDrive or SharePoint), choose the workbook, and select the first destination table.

Map data fields to columns

Once the table is selected, its columns will appear. Click inside each column field and insert the corresponding dynamic content from the 'Get response details' step.

Repeat for additional sheets

To send the data to multiple sheets, add another 'Add a row into a table' action for each additional worksheet. Select the same workbook but choose the different tables, and map the fields again. Save and test your flow.

Use Power Automate to Sync Responses to Multiple Excel Tables

Table Formatting Required: Power Automate cannot insert data into a blank worksheet. You must highlight your destination range in Excel, press Ctrl+T to convert it into a Table, and optionally name it under the Table Design tab.

Free Microsoft Office alternative

Manage and Analyze Your Spreadsheet Data with WPS Office

While Microsoft Power Automate handles the syncing between Microsoft Forms and Excel, you can seamlessly open, analyze, and edit the resulting .xlsx files using WPS Office. It provides a lightweight, highly compatible, and free alternative for all your spreadsheet data management.

1. Install WPS Office: Download and install the free WPS Office suite on your computer or mobile device.
2. Open the Synced File: Launch WPS Spreadsheets, click 'Open', and select your OneDrive-synced Excel file.
3. Analyze Data: Use pivot tables, advanced formulas, and charts in WPS to instantly analyze your newly populated form responses.

Fully compatible with Microsoft Excel (.xlsx and .xls) file formats.Lightweight suite allowing quick access to large datasets without lagging.Free built-in tools for Spreadsheets, Writer, and Presentation.Familiar user interface ensuring seamless migration and zero learning curve.Includes WPS Forms as an alternative solution for data collection and syncing.

microsoft office alternative - wps office

Frequently Asked Questions

Why isn't Power Automate finding my Excel worksheet?

Power Automate requires the destination range in your Excel file to be formatted as an official Table. Select your data range in Excel, press Ctrl+T, and name the table. Make sure the file is saved to the cloud before checking Power Automate again.

Can I send Form responses to an Excel file stored on my local hard drive?

No, Power Automate's Excel Online connector requires the workbook to be hosted in a cloud environment like OneDrive for Business or SharePoint to maintain an active connection and sync data automatically.

Do I need a premium Power Automate license to sync Forms to Excel?

Basic integration using Microsoft Forms and the standard Excel Online connector is typically included in standard Microsoft 365 business or education licenses. Premium connectors are not required for standard row additions.

What happens if a user submits a form while the Excel file is open?

Because the file is stored in OneDrive or SharePoint with AutoSave enabled, Power Automate will successfully add the new row in the background, and you will see the new data appear in the open spreadsheet in near real-time.

Excel & Data Problems