In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
Data Cleaning Plan From a Messy Sample
Prompt
Source of the data and what it represents: {{DATA_DESCRIPTION}}
Headers and about ten sample rows (keep the mess in): {{SAMPLE_ROWS}}
What the cleaned data will be used for: {{DOWNSTREAM_USE}}
Tool I will use: {{CLEANING_TOOL}}
Produce:
1. A defect log: every problem you can see in the sample (inconsistent spelling, stray spaces, mixed formats, placeholder values like N/A or 9999, merged cells, duplicate-looking rows, impossible values), each with the row number as evidence.
2. For each defect, the proposed fix, whether it is safe to automate or needs a human decision, and the risk if I get it wrong.
3. A fix order that avoids rework.
4. Checks to run after cleaning (row counts, totals, distinct values) so I can prove nothing was lost.
Only report defects visible in the sample; mark anything that is a guess as "suspected". Tell me to keep an untouched raw copy and never overwrite the original.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Data Cleaning Plan From a Messy Sample” 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:
{{DATA_DESCRIPTION}}, {{SAMPLE_ROWS}}, {{DOWNSTREAM_USE}}, {{CLEANING_TOOL}}.
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 4 times.
Browse all Productivity prompts, the AI prompt database or use the AI prompt finder to search every prompt.