In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
Find and Handle Duplicates Safely
Prompt
Table description and what one row should represent: {{ROW_MEANING}}
Headers and sample rows including suspected duplicates: {{SAMPLE_ROWS}}
Tool: {{TOOL}}
Which record to keep when duplicates differ (newest, most complete, highest value): {{KEEP_RULE}}
Do this:
1. Define "duplicate" for this table: which columns together identify the same real-world thing. Offer two definitions (strict and loose) and say what each would catch or miss in my sample.
2. Classify the suspected duplicates in my sample as exact, near (spelling, spacing, case), or different things that merely look alike.
3. Give step-by-step instructions in my tool to flag duplicates first, review them, and only then remove or merge. Include a formula or query to count duplicates before and after.
4. Explain what happens to values in the rows that get dropped, and what I lose.
Do not delete anything in your advice before a flag column exists. List what I must check by hand, and ask me before assuming a keep rule I haven't stated.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Find and Handle Duplicates Safely” is a free prompt for ChatGPT in the Productivity category, 177 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{ROW_MEANING}}, {{SAMPLE_ROWS}}, {{TOOL}}, {{KEEP_RULE}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 5 times.
Browse all Productivity prompts, the AI prompt database or use the AI prompt finder to search every prompt.