How to Use Google Forms Response Validation to Enforce Data Formats

The Problem with Free-Text Responses

Google Forms is an incredibly efficient tool for collecting data, but its greatest strength—simplicity—can also be its greatest weakness. If you add a “Short Answer” question asking for a respondent’s email address, age, or a specific serial number, there is nothing stopping them from typing a typo, a random word, or completely formatted gibberish.

When you eventually export the responses to Google Sheets, you are left with dirty data. Instead of analyzing the results, you spend hours manually correcting misspelled email addresses, removing letters from number fields, and deciphering incorrect date formats.

You can prevent this entirely at the source by using Response Validation. This hidden feature forces the user to format their answer correctly before they are allowed to click the Submit button.

Step 1: Enabling Response Validation

Response Validation is not turned on by default; you must activate it for each specific question where you want to enforce rules.

1. Open your Google Form and create a new question.
2. Set the question type to either Short answer or Paragraph. (Validation only works on text-entry fields, not multiple choice).
3. Click the three-dot menu icon located in the bottom-right corner of the question box.
4. Select Response validation from the popup menu.

A new row of drop-down menus will appear immediately below your question text, allowing you to define the rules.

Step 2: Enforcing Number Rules

If you ask a user for their age, a quantity, or a budget, you must ensure they actually type a number and not the word “Twenty”.

In the Validation row:

1. Set the first drop-down to Number.
2. Set the second drop-down to your specific criteria. Options include Greater than, Less than, Between, or simply Is number.
3. If you select Between (e.g., for an age restriction), type the minimum and maximum values in the subsequent boxes.

Crucial Step: The Custom Error Text
On the far right of the validation row is a box labeled “Custom error text”. If a user violates your rule, Google Forms will show a generic error. You should always overwrite this with a clear instruction, such as: “Please enter a valid age between 18 and 65 using digits only.”

Step 3: Validating Email Addresses and URLs

The most common use of validation is ensuring contact information is typed correctly.

1. Create a Short Answer question for “Email Address”.
2. Enable Response validation.
3. Change the first drop-down to Text.
4. Change the second drop-down to Email address.
5. Add a custom error: “Please ensure your email contains an @ symbol.”

Google Forms will now mathematically check the entry. If a user types “john.gmail.com” (forgetting the @) or “john@gmail” (forgetting the .com), the form will instantly reject the answer and prevent submission until it is corrected.

You can repeat this process using the URL option to ensure respondents submit a properly formatted website link (starting with http:// or https://).

Step 4: Advanced Validation using Regular Expressions

For highly specific data, standard rules aren’t enough. Imagine you are collecting Employee ID numbers, and your company policy dictates that every ID must be exactly two uppercase letters followed by four numbers (e.g., AB1234).

You can enforce this strict pattern using Regular Expressions (RegEx).

1. Enable Response validation on the question.
2. Set the first drop-down to Regular expression.
3. Set the second drop-down to Matches.
4. In the Pattern box, type your RegEx code. For the example above, you would type: ^[A-Z]{2}[0-9]{4}$
5. Set the custom error text: “Employee ID must be 2 letters followed by 4 numbers (e.g., XX9999).”

With RegEx, you can guarantee 100% data conformity, completely eliminating the need for manual data cleanup later.