Spreadsheet Duplicate Detection

Google SheetsApps ScriptDuplicate detection

Detect duplicate candidates by key columns and list them on a review sheet without changing source data.

Generator version: 1.0.0Published: Aug 1, 2026Updated: Aug 6, 2026

Source spreadsheet URL or ID

Source sheet name

Header rows

Duplicate key columns

Case sensitivity

Blank key handling

Review sheet name

Terms of UseI agree to use the generated script at my own responsibility after reviewing risks such as execution results, data loss, sync inconsistencies, and business interruption, and after creating a backup.

Generated Result

Not generated

Enter the required fields and generate the script.