← Back to Prompt Library
Data Analysis

Data Cleaning Instructions

Get step-by-step instructions to clean messy data.

Try in Optimizer →
I have a messy dataset with these problems: [DESCRIBE ISSUES — e.g., inconsistent date formats, duplicate rows, missing values, mixed text/numbers in one column, trailing spaces]. Give me step-by-step instructions to clean this data in [Excel/Python/Google Sheets]. For each step, show the exact formula, function, or code to use. Order from most critical to least critical.
cleandata qualitypreprocessing

Want to use this with one click inside ChatGPT?

Get TresPrompt →

More templates

Using AI? Optimize your prompts first.

Better prompts = better output = fewer revisions.

Try the Prompt Optimizer — Free →

You might also like

AI Prompt Optimizer

AI Prompt Optimizer gives you ready-to-use prompts you can copy and customize. Free, no signup, and organized for real workflows—open it now in seconds—try it n

Custom Instructions Generator

Custom Instructions Generator is a free, no signup tool built for knowledge workers. Get the result instantly in your browser and move on—try it now

AI Prompt Grader

AI Prompt Grader gives you ready-to-use prompts you can copy and customize. Free, no signup, and organized for real workflows—open it now in seconds—try it now

AI Model Picker Quiz

AI Model Picker Quiz gives you a fast recommendation based on your answers. Free, no signup, and built to help you pick the right option—take it now

100% client-side where applicable — your files and inputs stay in your browser. Nothing is uploaded to HundredTabs servers for these tools.