A clean Excel list with duplicate checks
Excel says there are no duplicates. One code has a space at the end.
Not yet tested No recorded AI run has verified this prompt yet. Try it on the practice files first, then use the checks in step 3 before you rely on it.
Prepare a copy of the sheet
Use non-sensitive codes, dates and item fields. Keep original unchanged.
Privacy Remove personal phone numbers, addresses, IDs, bank details and private records. Use employee or document codes and approved business facts only.
Whenever I send the next details, use this format. Clean-up rule: [Clean-up rule] Output columns: [Output columns] I'm attaching excel-cleanup.xlsx. A. Show cleaned columns; preserve original source values and row IDs, do not delete rows. Trim whitespace and uppercase codes only where the supplied rule permits; hold blank codes, invalid dates, ambiguous dates (such as 03/04/2026 without a confirmed day/month convention), and all duplicate code occurrences after normalisation. Dates already unambiguous or verified may be displayed YYYY-MM-DD; never guess a date or remove meaningful leading zeros. B. Count ready and held, list reasons. C. Give Excel formulas or steps to reproduce locally, no overwrite. Use only supplied facts and company policy. Mark missing dates, owners, amounts or approvals [confirm]. No bookings, payments, account changes or submissions by AI. A person checks before sending or deciding.
Set it up once. Save the output format and approved rules, without private records. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
After that, each time: send the new masked details and confirm the current rules.
First time? Try it in a normal chat: paste and send.
Which model? Use your tool's strongest model with thinking turned on.
In your AI tool: attach the files with the + button, paste, send.
Keep actual data in Excel.
Excel A:C = code, item, date. Rule [Clean-up rule]; columns [Output columns]. Write formulas for trimmed uppercase code, date display and duplicate/blank-date flag. Explain where to paste without overwriting original. Preserve codes as text, including leading zeros; flag blank codes and ambiguous/invalid dates for review, do not guess a locale. Keep original values alongside cleaned fields.
Fill down, filter held rows and confirm duplicates before deleting or merging.
- P1Two occurrences. Both held after trim/uppercase.
- P3Date missing. Do not fill.
- P2Ready. Cleaned code and date.
Then send this: Recheck source row count, normalised codes, preserved leading zeros and date parsing. Hold both occurrences of every duplicate and all blank or ambiguous values. Verify original columns unchanged.
Deletes duplicates
Reply: "Hold both; preserve rows."
Guesses date
Reply: "Leave blank."
Changes code meaning
Reply: "Only trim and uppercase."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
If your whole team does this, we'll set it up for all of them in one session.