PROMPT BRO
Admin desk

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.

By hand1–3 hrs
With AI15 min
Per week · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Prepare a copy of the sheet

Use non-sensitive codes, dates and item fields. Keep original unchanged.

First time? Try it on fake data first:

Privacy Remove personal phone numbers, addresses, IDs, bank details and private records. Use employee or document codes and approved business facts only.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
excel-cleanup.xlsx

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.

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.

What you'll get back (example, from the practice files)
2ready rows
3held rows
1duplicate code
  • P1Two occurrences. Both held after trim/uppercase.
  • P3Date missing. Do not fill.
  • P2Ready. Cleaned code and date.
Before you trust it

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.

If it goes wrong
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?