Guide
Spreadsheet Duplicate Detection Guide
A guide for detecting duplicate candidates by key columns and outputting them to a review sheet without changing source data.
The generated script lists candidates and does not delete or merge rows automatically.
Use one key column or a combination of columns for duplicate checks.
Review candidate groups with source row numbers before taking action.
What this generator is for
This generator creates an Apps Script that detects rows sharing the same key value and writes the result to a review sheet.
It is useful for checking customer lists, contact lists, application data, and other operational sheets.
The source sheet is not modified, so deletion or merging should be done manually after review.
Form input fields
Source spreadsheet URL or ID
Enter the Google Sheets file to use as the source. You can paste the full URL or only the file ID.
Source sheet name
The sheet that contains the data to process.
Header rows
The number of header rows at the top of the source sheet. Usually this is 1.
Duplicate key columns
Columns used to judge duplicates.
Case sensitivity
Usually disabled. Enable only when uppercase and lowercase should be treated differently.
Blank key handling
Choose whether blank key rows are included in duplicate detection.
Review sheet name
Sheet name where review results will be written.
Setup steps
Open Apps Script
Open Apps Script from the target spreadsheet.
Paste the script
Paste the generated Code.gs. Back up existing code before replacing it.
Run initial setup
Run the setup function from the function dropdown to create the review sheet and menu.
Reload the spreadsheet
After setup finishes, reload the spreadsheet so the KOKOCAL menu appears.
Run from the menu
Run the generated tool from the menu and review the output sheet.
Save the implementation guide
After generation, use Download setup guide at the top right of the generated result column to save the information needed for setup. Generated results disappear when you leave the page, so saving the guide before setup is recommended.
What the guide includes
The setup method, post-setup review points, generated script, settings JSON, and config hash are collected in one document. The setup method starts with a note that the generated script appears later in the guide.
Available formats
Choose Markdown (.md), Word (.docx), or the PDF save view.
Post-setup review points
Candidate output
Confirm that expected candidates are output to the review sheet.
No source modification
Confirm that source sheet values, row count, and column count are not changed.
Review required
Confirm that uncertain values are not forced and are marked for manual review.
Notes
Important note
Review this point before using the generated script in production.
Important note
Review this point before using the generated script in production.
Review before use
Review this point before using the generated script in production.
Ready to generate the script
Detect duplicate candidates by key columns and list them on a review sheet without changing source data.