Data Import & Export

How to Move Microsoft Forms Response Columns to Another Excel Sheet

Maira Mehtab Sep 20, 2026 871 views

Question details

The user needs a method to extract or move specific columns from a Microsoft Forms response dataset into a different Excel worksheet.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Organizing and extracting specific data columns from a raw Microsoft Forms response spreadsheet.
Observed behavior: The user wants specific columns of the form responses to dynamically populate another worksheet instead of manually copying and pasting them.

Before you start

Ensure your Microsoft Forms responses are synced or exported to your Excel workbook and identify the exact column letters (for example, columns K through P) that you want to extract.

Solution 1Recommended

Use a Dynamic FILTER Formula

Utilize the FILTER function to dynamically pull selected columns into a new worksheet without altering the original responses.

The FILTER function allows you to extract specific ranges of data based on a defined condition. This is highly effective for form responses because it updates automatically when new entries are submitted.

Open the Destination Worksheet

Navigate to the existing worksheet or create a new Excel worksheet where you want the selected Microsoft Forms response columns to appear.

Enter the FILTER Formula

Click on the starting cell (e.g., A1) in your new sheet and type a formula similar to =FILTER(Sheet1!K:P, Sheet1!K:K<>""). Replace 'Sheet1' with the actual name of your form responses sheet.

Adjust the Source Range

Modify the range 'K:P' to match the specific columns you want to move. Modify 'K:K<>""' to reference a column that will always contain data, ensuring the formula skips blank rows.

Apply and Verify

Press Enter to apply the formula. The selected columns from your form responses will dynamically spill into the new worksheet.

Dynamic Data Sync: Because this method uses a dynamic array formula, any new responses submitted through Microsoft Forms will automatically populate in this new sheet.

Easily Manage Form Responses with WPS Spreadsheet

WPS Spreadsheet fully supports dynamic array functions like FILTER, allowing you to seamlessly extract, analyze, and organize your form response data across multiple sheets.

1. Open Your Response Data: Launch WPS Spreadsheet and open the downloaded .xlsx workbook containing your Microsoft Forms responses.
2. Create a New Worksheet: Click the '+' icon at the bottom of the window to add a new worksheet for your filtered data.
3. Apply the FILTER Function: Type the formula =FILTER(Sheet1!K:P, Sheet1!K:K<>"") in the target cell, adjusting the range to target the specific columns you need.
4. Save Your Workbook: Save your workbook in standard .xlsx format to ensure all dynamic formulas remain fully functional and compatible.

Fully compatible with Microsoft Excel (.xlsx) file formats.Supports advanced dynamic array formulas including FILTER, SORT, and UNIQUE.Lightweight software with smooth performance for handling large response datasets.Free built-in data analysis tools and customizable workbook templates.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my FILTER formula returning a #CALC! error?

The #CALC! error typically occurs when the FILTER function finds no results matching your condition (e.g., all cells in the criteria column are empty). Ensure your criteria range contains data and does not evaluate to purely empty sets.

Can I select non-adjacent columns from the form responses?

Yes. To filter non-adjacent columns, you can combine the FILTER function with the CHOOSECOLS function, or nest multiple FILTER functions to specify exact column indexes rather than a continuous range like K:P.

Will the new sheet update automatically when new form responses arrive?

Yes. As long as the source form data is actively synced to your Excel workbook via Microsoft Forms, the dynamic array formula will automatically pull in any new responses that match the criteria.

Does WPS Spreadsheet support the FILTER function?

Yes, the latest versions of WPS Spreadsheet fully support dynamic array functions like FILTER, making it highly capable of handling complex data extraction tasks natively.

Excel & Data Problems