Others

Can You See Email Addresses from Anonymous Microsoft Forms Responses?

Huda Qurayshi Oct 12, 2026 869 views

Question details

The user wants to know if it is possible to identify or view the email addresses of respondents who submitted answers to a Microsoft Form configured for public access.

Can You See Email Addresses from Anonymous Microsoft Forms Responses?

Product: Microsoft Forms
Device & OS: not provided
Scenario: Reviewing survey or quiz responses submitted through a form shared with an 'Anyone with the link can respond' setting.
Observed behavior: Respondent email addresses are not visible in the web results summary, individual response details, or the exported Excel spreadsheet.

Before you start

Before attempting to recover respondent identities, verify your form's current share settings by clicking 'Collect responses' to confirm whether it was set to require sign-ins.

Solution 1

Understand Anonymous Form Response Limitations

Clarify how Microsoft Forms handles data when shared publicly without requiring a sign-in.

Unfortunately, it is completely impossible to see email addresses or identify respondents if the form was set to 'Anyone with the link can respond'.

Microsoft Forms treats these submissions as strictly anonymous to protect user privacy. Because the users were not required to log into a Microsoft account, their personal identifying information was never captured by the system. Consequently, the email addresses will not appear in the online results view or the exported Excel workbook.

Review your exported data

Open the exported Excel file from your Microsoft Forms results. You will notice that the 'Name' and 'Email' columns list the respondents as 'anonymous'.

No Retroactive Identification: Past anonymous responses cannot be deanonymized retroactively under any circumstances, even by Microsoft Support.

Solution 2Recommended

How to Collect Email Addresses in Future Forms

Change your form's permission settings or add specific required fields to ensure you capture respondent identities moving forward.

Free Microsoft Office alternative

Easily Analyze Form Data with WPS Office

While past anonymous responses in Microsoft Forms cannot be recovered, you can analyze your exported survey data effortlessly using WPS Spreadsheet. WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office for all your data management needs.

1. Export Form Data: In Microsoft Forms, navigate to your Responses tab and click 'Open in Excel' to download your raw data.
2. Analyze in WPS Spreadsheet: Launch WPS Office and open the downloaded .xlsx file to effortlessly format, filter, and create charts from your survey results.

100% compatible with Microsoft Excel (.xlsx) form exportsLightweight design for fast data processing, filtering, and chartingFree alternative to Microsoft Office with a familiar, easy-to-use interfaceSeamless migration with built-in PDF editing and document conversion tools

microsoft office alternative - wps office

Frequently Asked Questions

Can Microsoft Support retrieve the email addresses for my anonymous form?

No. Even Microsoft Support cannot retrieve the email addresses or IP addresses of respondents for forms set to 'Anyone can respond' because that data is simply never collected or stored on their servers.

Why does my Excel export say 'anonymous' instead of the respondent's name?

This happens because the form's sharing permission was set to allow anyone with the link to respond without logging into a Microsoft account, thus preventing the system from capturing their identity.

Can I trace an anonymous Microsoft Form response via IP address?

No, Microsoft Forms does not expose respondent IP addresses to the form creator. Tracking users via IP address is not a supported feature in the standard Microsoft Forms interface for privacy reasons.

How do I make sure names are recorded automatically in Microsoft Forms?

Go to your form settings (the three dots in the top right), select 'Only people in my organization can respond' or 'Specific people in my organization can respond', and verify that the 'Record name' box is checked.

Office Quick Solutions