How to Handle Email and Phone Validation in Microsoft Forms
Question details
The user wants to know if it is possible to enforce strict input masks or advanced validation rules for email addresses and telephone numbers submitted through a form.

- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Creating a contact or registration form where respondent data must follow standard email or phone number formats to ensure accuracy.
- Observed behavior
- Microsoft Forms does not currently provide built-in input masks or advanced validation settings for text fields, and there are no supported JSON parameters to add them.
Determine whether you strictly need real-time validation during data entry, or if validating the exported responses post-submission is sufficient for your workflow.
Validate Exported Responses Using Excel
Since Microsoft Forms lacks real-time advanced validation, you can export your form data to Excel and apply data validation rules to identify incorrect entries.
This method is best when you do not need to instantly block users from submitting invalid formats, but simply need to clean and verify the contact list afterward.
Open your form in Microsoft Forms, navigate to the 'Responses' tab at the top, and click the 'Open in Excel' button to download your dataset.
Open the downloaded spreadsheet and highlight the specific columns containing the respondent email addresses or phone numbers.
Navigate to the 'Data' tab on the ribbon, select 'Data Validation', and choose 'Custom'. Enter a formula to check for standard characters like the '@' symbol to easily flag invalid data.

Automate Validation Checks with Power Automate
Set up a background workflow that automatically checks new form submissions and flags those with incorrect phone or email formats.
Build a Custom Form Using Power Apps
If strict real-time input masks are mandatory for your project, use Power Apps instead of Microsoft Forms.
Manage and Validate Form Data with WPS Office
While Microsoft Forms lacks built-in input masks, you can easily export, clean, and validate your collected form data using WPS Spreadsheet. WPS Office is a free, lightweight, and powerful alternative to Microsoft Office that gives you complete control over your datasets.
- 1. Open Your Exported Data: Launch WPS Spreadsheet and open the Excel or CSV file generated from your form submissions.
- 2. Locate the Target Data: Highlight the columns that contain the email addresses and phone numbers you need to verify.
- 3. Set Up Validation Alerts: Go to the 'Data' tab, click 'Validation', and configure custom rules to instantly highlight entries that do not meet standard formatting criteria.

Frequently Asked Questions
Can I use Regular Expressions (Regex) in Microsoft Forms?
No, Microsoft Forms does not support the use of Regular Expressions or custom JSON settings to enforce advanced text field validation.
What types of restrictions are available for text questions in MS Forms?
You can apply basic restrictions to text questions, such as requiring the answer to be a number, setting specific numerical ranges (greater than/less than), or enforcing character limits, but you cannot enforce structural formats like emails.
Where can I request an email validation feature for Microsoft Forms?
You can suggest or upvote features regarding input masks by visiting the official Microsoft Forms Feedback Community and submitting your idea directly to the development team.
Are there other Microsoft tools better suited for input validation?
Yes, Microsoft Power Apps is highly recommended if your business requires strict, real-time input masks and custom data validation rules before form submission.




