Others

How to Fix Blank Name and Anonymous Email in Microsoft Forms Export

Kushani Nimanthika Oct 22, 2026 868 views

Question details

Users need a way to manage or remove the automatically generated 'Name' and 'Email' columns containing blank and 'Anonymous' values when exporting Microsoft Forms data to a spreadsheet.

How to Fix Blank Name and Anonymous Email in Microsoft Forms Export

Product: Microsoft Forms / Microsoft Excel
Device & OS: not provided
Scenario: Exporting survey or quiz responses from Microsoft Forms to an Excel spreadsheet for data analysis.
Observed behavior: The exported Excel file automatically includes default 'Name' and 'Email' columns that cannot be disabled in Forms settings. The 'Name' column appears blank, and the 'Email' column incorrectly displays 'Anonymous'.

Before you start

Ensure you have downloaded the latest response data from your Microsoft Form as an Excel (.xlsx) file and opened it in your preferred spreadsheet software.

Solution 1Recommended

Use Excel Formulas to Clean Up Anonymous Emails

Since the default columns are auto-generated by Microsoft Forms and cannot be disabled, you can use an IF formula in your spreadsheet to automatically hide the 'Anonymous' values.

Microsoft Forms automatically adds system 'Name' and 'Email' columns to exports to track users. If the form is set up to accept anonymous responses or is shared via a public link, these fields will default to blank and 'Anonymous'. Using a simple logical formula can clean this up without deleting the column entirely.

Add a new processing column

Open your exported spreadsheet and insert a new blank column directly next to the default Email column.

Enter the IF formula

In the first data cell of your new column (for example, D2, assuming C2 is the Email column), type `=IF(C2="Anonymous","",C2)` and press Enter.

Apply to all rows

Click the cell containing the formula, then click and drag the fill handle (the small square at the bottom-right corner) down to apply this formula to all response rows. This will leave the cell completely blank if the original value says 'Anonymous'.

Use Excel Formulas to Clean Up Anonymous Emails

Data Processing Tip: You can use this same logic to extract or format names from other custom columns, ensuring your final data presentation is clean and professional.

Solution 2

Delete Default Columns and Rely on Custom Form Questions

Bypass the system defaults entirely by asking for respondent details directly in your form and deleting the useless system columns in your downloaded spreadsheet.

Clean Up Form Exports Easily with WPS Spreadsheet

Open, edit, and clean your exported Microsoft Forms data seamlessly with WPS Spreadsheet. It fully supports standard Excel formulas, allowing you to quickly process blank names and anonymous emails.

1. Open the exported file: Launch WPS Office and open the exported Microsoft Forms Excel (.xlsx) file.
2. Insert a cleanup formula: Select an empty column next to your data and type `=IF(C2="Anonymous","",C2)` to filter out the anonymous entries.
3. Drag to apply: Click and drag the fill handle at the bottom-right corner of the cell to apply the formula to all your form responses instantly.
4. Save your organized data: Press Ctrl+S to save your newly cleaned spreadsheet without losing any of the original layout or formatting.

100% compatible with Microsoft Excel (.xlsx) file formatsSupports advanced IF formulas and conditional formatting for quick data cleanupLightweight application with a familiar, easy-to-use interfaceFree alternative for managing all your survey and data exports

microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Forms add an anonymous email column?

Microsoft Forms automatically includes standard Name and Email columns to track respondents when used within an organization. If the form is set up to record responses anonymously or is shared externally without requiring a login, the system falls back to filling these default columns with blank spaces and the word 'Anonymous'.

Can I disable the automatic Name and Email columns in Microsoft Forms settings?

No, Microsoft Forms does not currently provide an option to prevent these default system columns from generating in the exported Excel file. They must be hidden, deleted, or processed using formulas after downloading the data.

How do I collect real names if the default export column is blank?

To ensure you capture respondent details accurately, manually add 'Name' and 'Email' as required text questions within the Microsoft Form builder itself. These custom questions will generate separate, accurate columns in your final Excel export.

Office Quick Solutions