Data Import & Export

How to Sync Microsoft Forms Responses to Another Excel Workbook

Maira MehtabMaira Mehtab Nov 13, 2026 869 views

Question details

The user needs to move new Microsoft Forms responses from one workbook into a field-notes workbook and route each response to a separate area sheet, while evaluating Power Query, VLOOKUP, and Power Automate.

How to Sync Microsoft Forms Responses to Another Excel Workbook
Product
Microsoft Forms and Microsoft Excel workbooks
Device & OS
not provided
Scenario
A user collects Microsoft Forms responses in one workbook and needs to consolidate or route them into another workbook with separate area-based sheets for field notes.
Observed behavior
New responses should appear in the target workbook and be routed to the correct area sheet without overwriting manual edits.
Before you start

Make sure the Microsoft Forms response workbook is saved in a location supported by Power Query or Power Automate, and decide whether you need automatic per-response routing or a periodic full refresh before choosing the method.

Solution 1Recommended

Automate each new Forms response with Power Automate

Use this when every new response must be added automatically to another workbook and routed by area without manual copying.

Power Automate triggers on each new response and appends rows to the target workbook, which is ideal when you must route records to separate area sheets. It does not require manual refresh, but the target workbook must be stored in a location supported by the connector, such as OneDrive or SharePoint.

1
Create a Microsoft Forms trigger flow

In Power Automate, select Create > Automated cloud flow, choose the Microsoft Forms trigger 'When a new response is submitted', and sign in to your Forms account.

2
Add an Excel Online action

Add an action, search for Excel Online (Business), and choose 'Add a row into a table' to target the field-notes workbook and its structured table.

3
Map fields and route by area

Map each Forms question to the corresponding table column, then use a Condition or Switch action to route the row to the correct area sheet based on the response content.

Automate each new Forms response with Power Automate
Keep responses in one structured table: Keep the source responses in one structured table and avoid editing Power Query output sheets directly because a refresh can overwrite manual changes.
Free Microsoft Office alternative

Organize Microsoft Forms Response Workbooks with WPS Office Free

WPS Office is a free, lightweight Microsoft Office alternative that opens and edits .xlsx response workbooks, preserves Excel formatting and formulas, and gives you familiar spreadsheet tools to filter and organize Microsoft Forms data without paying for a subscription.

Opens and edits Excel workbooks, including exported Microsoft Forms response files in .xlsx format.Provides familiar spreadsheet tools for filtering, sorting, and organizing responses into area sheets.Free, lightweight installation that works alongside existing Excel files without requiring a subscription.Preserves formulas, formatting, and workbook structure when you move between Microsoft Excel and WPS Office.
QA img-9

Frequently Asked Questions

Can I use Power Query to update a field-notes workbook without overwriting manual notes?

Power Query refresh can overwrite edits in the output range. Keep manual notes in separate columns outside the query table, or use Power Automate to add new rows to a separate table instead.

Does Microsoft Forms work with Power Automate to route responses by area?

Yes. Use the 'When a new response is submitted' trigger in Power Automate, then add a Condition or Switch action that writes the row to the correct area sheet in the target workbook.

Is VLOOKUP enough to synchronize new Forms responses?

VLOOKUP can look up existing values, but it cannot automatically insert new responses or route them by area. Use Power Query for full imports or Power Automate for automatic per-response routing.

Can WPS Office run Power Automate or import Microsoft Forms responses directly?

WPS Office can open and edit the resulting Excel workbooks, but it does not include Microsoft Power Automate or Microsoft Forms connectors. Build the sync in Microsoft Power Automate or Power Query, then open the workbook in WPS Office.