Live demo

Try it: screen a survey export for careless and repeated responses

This is the working version of the survey response screen tutorial. It reads a CSV export you open or paste and flags responses with the same answer all the way down a grid, a finish time under your limit, a missed instructed item, an inconsistent reversed pair, a repeated email, repeated answers and comments, or a one-word comment. It deletes nothing and does not judge whether any person was careless.

How this lab works

• Everything on the page runs in your browser. The kit's script runs the same checks from a command line and can read several files in one run, which the page cannot.
• It flags and does not delete. The download lists each flag with empty decision and reason columns for a person to fill in. It holds row numbers, the values from the id column you name, check names and short messages, and no comment text. Choose an id that is not an email address.
• The numbers are examples. Edit every limit. The two seconds per item is one study's own educated guess, and the repeated email, repeated answers and one-word comment checks are house checks with no cited source.
• It cannot judge people. A fast or uniform response can come from a careful member, and a careless one can pass every check.
• Row numbers count responses. Row 24 is the 24th response under the header.
• The sample is synthetic. It is 40 invented responses with seven problems planted by us, so a clean match shows only that the code does what it says.
• Local only. The script is served from this site and the page makes no other request for your file.

Starter kit

The starter kit holds this page to run on your own computer, the same checks as a script, the sample file, a settings worksheet, a review checklist, an instructed-item guide and a log for decisions. Free with your email through the form below; the download link appears after you subscribe.