Guide · Google Forms

Review duplicate registrations without deleting the original.

Keep the response sheet unchanged. Normalize phone numbers and dates in a working copy, then separate clear results from rows that need a person to decide.

Safe sequence

Normalize first. Decide second.

A shared phone number can belong to a family or group. A different phone format can still represent the same person. The workflow should preserve both possibilities.

  1. Keep the response sheet read-only

    Work from an exported CSV or a separate operating sheet.

  2. Normalize comparison fields

    Make phone and date formats comparable without changing the source.

  3. Separate confident and uncertain matches

    Use name, date, and phone together instead of deleting on one field.

  4. Download a review list

    Give ambiguous rows and missing information to the person responsible.

The browser demo does not upload the CSV, use an account, or require an API key.