Why you need to filter responses before you analyze them

Google Forms collects whatever people submit. If your form is public or shared widely, you will get responses that are incomplete, nonsensical, or deliberately wrong — people testing the form, clicking through without reading, or submitting the same answer to every question. These responses skew your data and waste your time sorting through them later.

You have three ways to handle this: prevent bad responses from being submitted in the first place, remove them after they arrive, or mark them so you can exclude them when you analyze the results. The method you choose depends on how much control you want over who responds and how much time you have to clean up afterward.

Key Takeaways

  • Require sign-in and limit responses to one per person to block most spam and duplicate submissions.
  • Use question validation rules — like minimum word counts or number ranges — to catch obviously wrong answers before submission.
  • Delete individual responses directly in the Responses tab, or read your data and filter it in a spreadsheet if you have hundreds of submissions.
  • Create a helper column in Google Sheets to flag suspicious patterns, like identical answers across all questions or responses submitted in seconds.
  • Use the "Unlink form" option to stop accepting new responses while you clean up old ones.

Preventing bad responses before they arrive

The easiest junk to handle is the junk you never receive. In your form's settings, go to the three-dot menu and select Settings. Check the box for Limit to 1 response if you want each person to submit only once. Check Require sign-in if you want respondents to use a Google account — this blocks most automated spam and makes it harder for one person to submit multiple times.

If your form is for a specific group — a class, a team, a mailing list — restrict it to people with accounts in your organization. In Settings, under Collect email addresses, choose Verified to require a work or school email. This cuts out random internet submissions entirely.

These settings do not catch people who read carelessly or change their minds halfway through. For that, you need validation rules on individual questions.

Using validation to catch wrong answers at submission time

Validation rules let you reject an answer if it does not meet your criteria. Click on a question, then click the three dots and select Answer validation. The options depend on the question type.

For a text question, you can require a minimum or maximum number of characters. If you ask "Describe your experience in one sentence," set a minimum of 10 characters to block single-word answers. For a multiple-choice or dropdown question, you can require that a specific option be chosen — useful if you have an "Other" option and want to force people to pick something real. For a number question, set a minimum and maximum range so someone cannot enter 999 when you ask for an age.

When someone tries to submit an answer that fails validation, they see an error message and cannot proceed until they fix it. Write the error message clearly — "Please write at least one full sentence" is more helpful than "Invalid entry." Validation does not catch someone who reads the question and deliberately lies, but it does stop typos, accidental blanks, and people rushing through without thinking.

Deleting responses one at a time

Open your form and go to the Responses tab. You see a summary of all submissions. Click on the individual response icon (it looks like a single sheet of paper) to open one response in full. At the top right, click the trash icon to delete it. The response is gone when ready and does not count toward your total.

This works fine if you have 10 or 20 responses. If you have 200, deleting one at a time is not practical. In that case, move to a spreadsheet.

Filtering responses in Google Sheets

Google Forms automatically creates a linked Google Sheet when you turn on response collection. Open that sheet — you see one row per response, one column per question. Each new submission adds a row at the bottom.

To remove responses, you can delete rows directly in the sheet. Click the row number on the left to select the entire row, right-click, and choose Delete rows. The response is gone from both the sheet and the form's response count.

Before you delete, add a helper column to flag suspicious responses. In a blank column, write a formula that checks for patterns. For example, to find responses where the same answer appears in multiple questions, or where the submission time was less than 10 seconds, or where a required field is blank. You can use COUNTIF to count how many times a value appears, or IF to test a condition. Once you have flagged the rows, sort by your helper column to group the suspicious ones together, review them, and delete the ones that are clearly junk.

If your form is linked to a sheet, deleting a row in the sheet does not delete the response from the form itself — you have to delete it from the form's Responses tab. If you want to work only in the sheet, unlink the form first. Go to the form, click the three-dot menu, select Unlink form, and confirm. Now the sheet is a static copy. You can delete rows freely, but new form submissions will not appear in the sheet anymore.

Stopping new responses while you clean up

If you realize mid-collection that you are getting a lot of junk, you can pause the form without losing the responses you already have. In the form's Responses tab, click the three-dot menu and select Unlink form. This stops the form from accepting new submissions and stops the sheet from updating. You can now clean up the responses you have without new ones coming in. When you are done, you can delete the form or reopen it with tighter settings.

Alternatively, go to the form itself, click the three-dot menu, and select Settings. Scroll down and toggle off Accepting responses. The form stays live but shows "This form is no longer accepting responses." You can turn it back on anytime.

Spotting patterns that signal junk

Some responses are obviously bad — a blank field, a single letter, or "test test test" repeated. Others are subtler. Look for responses where someone gave the same answer to every question, or where the time between submission and the previous submission is identical (a sign of automated filling), or where the timestamp shows a response at 3 a.m. when your survey was meant for business hours.

If you are collecting open-ended text, watch for responses that are too short (one or two words when you asked for a paragraph), too long (copy-pasted from somewhere else), or off-topic (answering a question about their job with "I like pizza"). These are judgment calls — you decide what counts as usable data for your purpose.

If you see a pattern — for example, 50 responses all submitted within one minute with identical answers — you may have been targeted by a bot or a prank. In that case, it is faster to delete all of them at once by selecting multiple rows in the sheet than to review each one individually.

Frequently Asked Questions

Can I see who submitted a response if I did not ask for their email?

Not unless you turned on email collection in the form settings. If you did, the email address appears in the Responses tab and in the linked sheet. If you did not, you see only the answers, not who gave them. You can turn on email collection anytime, but it only applies to new responses.

If I delete a response from the sheet, does it disappear from the form too?

Only if the form is still linked to the sheet. If the form is linked, deleting a row in the sheet does not affect the form — you have to delete the response from the form's Responses tab. If you unlink the form first, the sheet becomes a copy and you can delete rows freely, but new submissions will not appear in the sheet.

What is the fastest way to remove 100 junk responses?

Open the linked sheet, add a helper column to flag the junk (using a formula or manual marking), sort by that column to group them together, select all the junk rows at once, and delete them. This is much faster than deleting one response at a time in the form's Responses tab.

Can I undo a deleted response?

No. Once you delete a response from the form or the sheet, it is gone. If you are unsure, move the response to a separate "Review" sheet instead of deleting it, so you can look at it again later.

Should I require sign-in if I want lots of responses?

Requiring sign-in cuts down on spam and duplicates, but it also cuts down on total responses because some people will not bother signing in. If you need volume and do not mind filtering junk later, leave it open. If you need quality and do not mind fewer responses, require sign-in.