Why Microsoft Forms Adds Extra Columns to Excel Responses
Question details
Users want to know why extra data fields appear in their exported Microsoft Forms results and how to handle them without breaking the data sync.
- Product
- Microsoft Forms / Microsoft Excel
- Device & OS
- not provided
- Scenario
- Exporting or synchronizing survey and quiz responses from Microsoft Forms into an Excel workbook.
- Observed behavior
- The resulting Excel response file automatically contains additional metadata columns (such as ID, Start time, Completion time, Name, and Email) that were not added to the original form by the creator.
Before attempting to delete or modify any columns, ensure you are working on a downloaded or offline copy of the response workbook. Modifying columns directly in a live-synced Excel file can break the data synchronization with Microsoft Forms.
Hide or Delete Columns in a Disconnected Copy
The safest way to remove unwanted metadata columns without breaking the form's live synchronization.
Microsoft Forms requires metadata columns to track submissions effectively. Because these fields generally cannot be disabled in the linked response workbook, the best workaround is to manage them in a separate, unlinked copy of the data.
Open your Microsoft Forms response workbook in Excel for the Web, click on 'File', select 'Save As', and choose 'Download a Copy' to save an offline version to your local device.
Open the downloaded Excel file and highlight the column headers you do not need, such as ID, Start time, Completion time, Name, or Email.
Right-click on the selected column headers and choose 'Hide' to temporarily remove them from view, or 'Delete' to permanently remove them from your offline copy.
Use Power Automate to Export Specific Fields
Create an automated workflow to write only the required form fields to a clean, separate Excel table.
Edit and Analyze Form Responses Easily with WPS Office
While Microsoft Forms controls the automatic metadata generation, you don't need expensive software to clean up and analyze your exported results. WPS Office is a powerful, lightweight alternative that lets you open, edit, and filter your Excel response files effortlessly, all for free.
- 1. Download WPS Office: Install the free WPS Office suite on your device.
- 2. Open your response file: Launch WPS Spreadsheet and open the .xlsx copy downloaded from Microsoft Forms.
- 3. Clean your data: Select the extra metadata columns, right-click, and easily delete or hide them to prepare your report.
Frequently Asked Questions
Can I permanently stop Microsoft Forms from generating the ID and timestamp columns?
No. These are built-in metadata fields required by the Microsoft Forms system to track, order, and manage submissions natively. They cannot be disabled from being exported.
Will deleting the extra columns in my Excel file break my Microsoft form?
If you delete these columns in the live-synced Excel workbook stored on SharePoint or OneDrive, it will likely corrupt the data synchronization. You should only delete columns in a downloaded, offline copy of the spreadsheet.
Why do the Name and Email columns show as 'anonymous' in my Excel responses?
This happens when your Microsoft Form sharing settings are configured to 'Anyone can respond'. Because the form does not require respondents to log into a Microsoft account, it cannot automatically capture their name or email address.
