How to Sync Microsoft Forms Responses to Another Excel Workbook
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.

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

Import and refresh the full Forms response table with Power Query
Use this when you need to pull the complete response table into Excel, then create filtered area sheets or PivotTables for reporting.
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.

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.




