Data Import & Export

How to Remove Unwanted Microsoft Forms Data from Excel

Bushra Parveen Oct 7, 2026 868 views

Question details

The user wants to export Microsoft Forms responses to Excel without including unnecessary or unwanted data columns.

How to Remove Unwanted Microsoft Forms Data from Excel

Product: Microsoft Forms and Excel
Device & OS: not provided
Scenario: Exporting form responses to a spreadsheet for streamlined data analysis without clutter.
Observed behavior: Microsoft Forms exports all response columns by default, offering no built-in feature to exclude specific fields before downloading the Excel file.

Before you start

Ensure you have an active Microsoft 365 account with access to Power Automate and Excel Online for Business if you plan to set up an automated data filter.

Solution 1Recommended

Use Power Automate to Create a Custom Excel Export

Since Microsoft Forms doesn't natively allow column exclusion, you can build a Power Automate flow to send only specific responses to a customized Excel file.

This method requires setting up a flow that intercepts form submissions and writes only the desired data fields into a pre-formatted Excel table stored on OneDrive or SharePoint.

Create a Target Excel Table

Create a new Excel workbook in OneDrive or SharePoint. Add a table (Insert > Table) containing only the column headers you want to keep from your form responses.

Create a New Flow

Log in to Microsoft Power Automate. Click 'Create' and select 'Automated cloud flow'. Choose 'When a new response is submitted' in Microsoft Forms as your trigger.

Get Response Details

Add a new action and search for 'Get response details'. Select your specific Form ID and populate the Response ID field from the dynamic content menu.

Map Data to Excel

Add another action called 'Add a row into a table' for Excel Online (Business). Select your target Excel file and table, then map only the specific form fields you want to your table's columns.

Use Power Automate to Create a Custom Excel Export

Feedback to Microsoft: Since this is a common frustration, consider submitting a feature request through the Microsoft Forms Feedback option to advocate for native export filters.

Solution 2

Manually Delete Unwanted Columns in Excel

If you do not have access to Power Automate, the most straightforward approach is to download the full dataset and manually remove the unnecessary columns.

Free Microsoft Office alternative

Easily Edit and Clean Your Spreadsheet Data with WPS Office

While Microsoft Forms restricts export customization, editing the downloaded Excel file is incredibly easy with WPS Office. As a free, lightweight alternative to Microsoft Office, WPS Spreadsheet allows you to open, edit, and clean your raw form data seamlessly.

1. Download WPS Office: Visit the official WPS website and install the free WPS Office suite on your device.
2. Open the Forms Export: Launch WPS Spreadsheet and open your downloaded Microsoft Forms Excel (.xlsx) file.
3. Clean the Data: Highlight the unwanted columns, right-click the headers, and select Delete to instantly clean your dataset.

Fully compatible with Microsoft Excel (.xlsx and .xls) formats.Easily delete, hide, or filter unwanted columns from raw form exports.Free, lightweight, and features a familiar user interface.Built-in data processing tools for quick spreadsheet cleanup without complex workflows.

Frequently Asked Questions

Can I stop Microsoft Forms from collecting default metadata?

No, Microsoft Forms automatically records default metadata such as Start Time, Completion Time, and Email (for authenticated internal forms). You cannot disable these fields from being collected, but you can delete them after exporting the data to a spreadsheet.

Will Microsoft add a feature to select columns before exporting?

Currently, there is no direct feature to select or filter columns before exporting data to Excel. Users are encouraged to submit this feature request through the Microsoft Forms Feedback portal to increase its priority for future updates.

How do I hide columns instead of deleting them in my Excel response file?

Select the column header letter (like 'A' or 'B') at the top of your spreadsheet, right-click it, and select 'Hide'. This keeps the original data intact within the file while removing it from your active workspace view.

Excel & Data Problems