How do I prevent survey responses from using inconsistent spellings for the same choice?

Decide on one approved label for each response that should mean the same thing, then present those labels as selectable choices wherever possible. For example, you might choose “In person” and use it consistently in the question, instructions, and any response list. Keep the choices short and distinguishable; if two options could be interpreted differently, explain the difference rather than relying on capitalization or punctuation.

If respondents need to enter answers in a spreadsheet, Google Sheets dropdowns can draw choices from a manually entered list or a cell range. A validation rule can reject an entry that isn’t on the list, or show a warning while still allowing it. [S1] Pick the behavior that suits the question: a fixed list works when answers must use approved categories; allowing unlisted answers may be useful when you expect meaningful suggestions. State what respondents should do if none of the listed choices fits.

Separate the standard choices from the exception path. For instance, if the choices are “In person,” “Online,” and “Phone,” add a clear instruction such as: “If none fits, choose ‘Other’ and describe your answer in the follow-up field.” Treat “Other” as a route for recording a response, not as a reason to discard the description.

In a Google Sheets workflow, you can set the dropdown rule to reject entries outside the list or to show a warning and allow them. [S1] If you choose rejection, make sure the survey still has a suitable way to submit an answer that doesn’t fit. If you choose a warning, plan to review unlisted entries later. The source describes the dropdown options; it doesn’t establish which setting is best for every survey or whether a particular survey tool supports the same behavior.

First compare the responses with your approved list, then separate obvious presentation differences from answers that might have a different meaning. For example, if the survey question makes clear that “in-person” and “In Person” refer to the same mode, you can map those entries to the approved label “In person.” Keep a record of the original value or a mapping note if you may need to explain the cleanup later.

Don’t automatically fold an unfamiliar answer into the nearest-looking choice. Google’s guidance for existing entries is to apply a dropdown rule and review values that don’t fit; then decide whether each should be corrected, added as a valid choice, or retained separately rather than silently changing its meaning. [S1] If the intent isn’t clear from the response and question, leave it unclassified for review instead of guessing.

Use this sequence:

1. Define the choices: Write one approved label for each category and note what belongs in each one.
2. Choose how to handle exceptions: Add an “Other” route or decide how an unlisted answer will be reviewed.
3. Collect consistently: Offer selectable choices when practical; in Google Sheets, a dropdown can be sourced from a list or range, with a rule that rejects or warns about unlisted entries. [S1]
4. Review old responses: Compare entries with the approved labels. Correct clear spelling or formatting variants, consider genuinely different answers as possible new choices, and retain unclear answers for review.
5. Keep a simple mapping: Record the original value, the standardized value, and the reason for any change. Use the same approved list if the question is reused, revising it deliberately when needed.

Illustrative mapping: “In Person” → “In person” (capitalization); “in-person” → “In person” (punctuation, if the question confirms they mean the same); “Hybrid” → review whether it is a new valid choice. These are examples, not classifications for your actual responses.