Data Cleaning Agent Prompt With Audit Trail
Clean a table while recording every change.
Added October 15, 2026. Written with AI assistance and checked for clarity and placeholders; not reviewed by a lawyer, accountant, clinician or other professional. How these prompts are made
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Clean this dataset: [DATASET_DESCRIPTION]. Known problems: [KNOWN_PROBLEMS]. Columns and their expected types: [COLUMN_SPEC]. Tool: [TOOL]. Do not change anything silently. For each fix, record the row identifier, column, old value, new value and rule applied in a change log. Fix only unambiguous issues such as trailing spaces, inconsistent capitalisation, and date formats; list ambiguous cases such as possible duplicates or impossible values for my decision rather than fixing them. Return the cleaning steps in order, the change log format, a count of changes by rule, a list of ambiguous cases with a suggested action, and a check that row totals before and after reconcile with the removed rows listed. Also state that the original file is never overwritten, that the cleaned file is saved under a new name, and that a person approves the list of ambiguous cases before a second pass applies any of those decisions. Finish with a final reconciliation step: totals per key column before and after cleaning, the count of rows removed with reasons, and a sign-off line for the person who approves the result.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.