Others

How to Collect Email Addresses Separately from Anonymous Microsoft Forms Responses

WPS Content Manager Sep 30, 2026 870 views

Question details

The user wants to collect respondents' email addresses for follow-up interviews without linking those addresses directly to their anonymous survey answers.

How to Collect Email Addresses Separately from Anonymous Microsoft Forms Responses

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating a survey where responses must remain completely anonymous, but follow-up contact information is still required from willing participants.
Observed behavior: Microsoft Forms does not have a built-in feature to collect email addresses entirely separate from the main anonymous response data in a single form.

Before you start

Ensure you have access to your Microsoft Forms account and are prepared to either create a secondary form or manage your exported response data in an Excel spreadsheet.

Solution 1Recommended

Use a Secondary Form for Contact Information

The most reliable way to keep survey responses truly anonymous while collecting emails is to use two separate Microsoft Forms linked together.

By utilizing two separate forms, the anonymous answers are recorded in one database, while the contact information is stored in another. This guarantees to respondents that their feedback cannot be traced back to their email addresses.

Create the main survey

Create your anonymous survey form in Microsoft Forms. Go to Settings (the three dots in the top right) and ensure the 'Record name' option is unchecked.

Create the contact form

Create a second, separate form specifically asking for the respondent's name and email address for follow-up interviews.

Copy the sharing link

Click 'Collect responses' on your newly created contact form and copy the sharing URL.

Add link to the main survey

Return to your main survey's settings. Under 'Customize thank you message', paste the link to the second form, asking respondents to click it and fill out their contact details if they are open to a follow-up interview.

Use a Secondary Form for Contact Information

Guaranteed Anonymity: Using a secondary form ensures absolute data separation, providing peace of mind for respondents submitting sensitive feedback.

Solution 2

Export Responses to Excel and Anonymize Manually

Collect emails within the same form as the survey questions, but manually separate the identifying information after exporting the data.

Free Microsoft Office alternative

Manage Your Survey Data Easily with WPS Office

While Microsoft Forms requires workarounds to separate emails, analyzing and anonymizing your exported survey data is seamless with WPS Spreadsheet. As a free, lightweight alternative to Microsoft Office, WPS Office offers full compatibility with Excel files and a familiar interface.

1. Download and Install: Download WPS Office for free and install it on your device.
2. Open Exported Data: Locate the Excel file exported from Microsoft Forms and open it using WPS Spreadsheet.
3. Separate and Save: Easily extract the email column into a new workbook and save your anonymized data in standard .xlsx format.

Fully compatible with Microsoft Excel (.xlsx) formats.Free and lightweight alternative to Microsoft Office.Advanced data filtering and column separation tools to easily anonymize survey data.Familiar user interface requires no learning curve for easy migration.

microsoft office alternative - wps office

Frequently Asked Questions

Can I make only one question anonymous in Microsoft Forms?

No, anonymity settings in Microsoft Forms apply to the entire form. You cannot configure a single question to be anonymous while tracking identifying information for the rest of the responses.

How do I ensure my Microsoft Form is truly anonymous?

To make a form completely anonymous, click the three-dot menu in the top right corner of the form, select 'Settings', and under the 'Who can fill out this form' section, ensure that the 'Record name' checkbox is disabled.

Can I use Power Automate to separate emails from responses automatically?

Yes. You can create a Power Automate flow that triggers when a Microsoft Forms response is submitted. The flow can extract the email address and send it to a separate SharePoint list or Excel sheet, ensuring the main response database remains anonymous.

Office Quick Solutions