You can filter out low-quality responses by checking for patterns before you analyze your data

Google Forms does not have a built-in "quality score" button, but you can spot and remove responses that are clearly not serious — people who clicked randomly, filled in gibberish, or spent three seconds on a ten-minute survey. The fastest method is to sort your responses by completion time and look for anyone who finished in an unreasonably short window. You can also scan for duplicate answers, identical timestamps, or responses that contradict earlier questions you asked.

Once you identify the bad responses, you delete them one at a time from your response sheet, or you can filter your data before you download it for analysis. Neither method is automatic, but both take only a few minutes if you know what to look for.

Key Takeaways

  • Sort responses by time spent to find people who rushed through your form in seconds — they are unlikely to have read the questions.
  • Look for identical or near-identical answers from different people, which often signals spam or test submissions.
  • Check for answers that contradict each other within the same response, like saying "I have never used this product" and then rating its features.
  • Delete individual responses directly in Google Forms, or filter your data in Google Sheets before you analyze it.
  • Set up form validation rules before you launch next time to block obviously wrong answers, like ages over 150 or negative numbers.

Sort responses by time to find people who rushed through

The fastest way to spot low-effort responses is to look at how long each person spent on your form. Open your form in Google Forms, click the Responses tab, then click the three-dot menu and select Download responses (.csv). Open that file in Google Sheets or Excel and look at the Timestamp column — this shows when each response was submitted, but not how long it took.

To see completion time, you need to add a helper column. In Google Sheets, click an empty column header and type a formula like =ARRAYFORMULA(IF(ROW(A:A)=1,"Time (seconds)",IF(A:A="","",ROUND((TIMEVALUE(A:A)-TIMEVALUE(B:B))*86400,0)))) — replace A and B with the actual column letters of your timestamp column and the previous timestamp. This calculates the gap between submissions. Anyone who completed your form in under 30 seconds almost certainly did not read the questions.

If you have a form with 20 questions, someone who finished in 45 seconds spent about 2 seconds per question. That is a red flag. The exact threshold depends on your form length, but anything under 10 seconds per question is worth checking.

Look for identical or nearly identical answers

Spam bots and test submissions often produce identical responses. Scan your answer columns for exact duplicates — the same phrase repeated word-for-word across multiple responses. In Google Sheets, you can use conditional formatting to highlight duplicates: select a column, click Format > Conditional formatting, choose Custom formula is, and enter =COUNTIF($A$2:$A,A2)>1 (replace A with your column letter). Any cell that appears more than once will highlight.

Also watch for near-duplicates: responses that are 95 percent the same but with one or two words changed. These are harder to spot by eye, but they often come from the same source. If you see three responses that say "Great product, would recommend" with only minor variations, check the timestamps — if they came in within seconds of each other, they are probably not real.

Check for contradictions within a single response

A response can be internally inconsistent in ways that reveal it was not serious. If your form asks "Have you used our product before?" and the answer is "No," but then the person rates the product's features on a 1-to-5 scale, that is a contradiction. Someone who has never used the product cannot rate its features.

Look for other logical breaks: someone who says they are 12 years old but also says they have been working in their field for 15 years, or someone who selects "I strongly disagree" with a statement and then selects "I strongly agree" with the opposite statement two questions later. These are not always spam — sometimes people misread or change their minds — but they are worth reviewing.

Delete individual responses or filter before you analyze

To remove a response directly in Google Forms, open the Responses tab, find the response you want to delete, click the three-dot menu next to it, and select Delete. This removes it from your response count and from any charts Google Forms generates automatically. You cannot undo a deletion, so make sure you have identified the right response.

If you prefer to keep the original data intact, download your responses to Google Sheets and filter there instead. Click the header row, then click Data > Create a filter. You can now click the filter icon on any column and uncheck the responses you want to exclude from your analysis. This hides them without deleting them, so you can change your mind later.

Set up validation rules before you launch your next form

You cannot retroactively block bad responses, but you can prevent some of them on future forms. When you build a new form, click on a question, then click the three-dot menu and select Response validation. You can set rules like "Number is greater than 0" or "Text length is at least 10 characters" or "Email address is valid."

For example, if you ask for age, set validation to "Number is between 1 and 120" — this stops someone from entering 999 or -5. If you ask for a reason in an open-ended field, require a minimum of 20 characters to block one-word joke answers. If you ask for an email, turn on email validation so Google Forms checks that the format is real.

Validation does not catch everything — someone can still lie or rush through — but it stops the most obvious nonsense before it reaches your response sheet.

Frequently Asked Questions

Can I see how long each person spent on my form without downloading it?

Not directly in Google Forms. You have to download your responses to Google Sheets or Excel to calculate time spent. Google Forms shows you the timestamp of each submission, but not the duration. The download takes 30 seconds and gives you much more control over filtering anyway.

What if I have hundreds of responses and only a few look bad?

Use the filter method in Google Sheets instead of deleting from Google Forms. Create a filter, uncheck the bad responses, and then copy only the filtered data to a new sheet for analysis. This way you keep the originals intact and do not have to delete one response at a time.

Does Google Forms have a spam detection feature?

No. Google Forms does not automatically flag or remove spam responses. You have to review them yourself. However, if you require sign-in with a Google account, you reduce spam significantly because bots have a harder time creating accounts. You can turn this on in form settings under Responses > Collect email addresses.

Can I prevent someone from submitting the form twice?

Yes. In your form settings, click Settings (the gear icon), then turn on Limit to 1 response. This prevents the same Google account from submitting more than once. If you do not require sign-in, you cannot enforce this — anyone can clear their cookies and submit again.

What is the best way to handle responses that are just blank or mostly blank?

Decide based on your analysis goal. If you are looking for feedback, blank responses add no value and should be removed. If you are counting participation or tracking who opened the form, you might keep them. Most of the time, blank responses are accidental submissions and can be deleted without affecting your results.