Best AI prompts for cleaning messy data

1. 1 · Data · attach file Clean a messy spreadsheet
   Fix duplicates, formats and errors in a CSV or Excel file.
2. 2 · Data · attach file Clean and analyze a spreadsheet
   Fix messy data and find the story.
3. 3 · Data · attach file Write a data dictionary for my dataset
   Get a clear table that explains every column: meaning, type, allowed values and gaps.
4. 4 · Data · attach file Find outliers in my data and explain them
   Spot unusual values, check if they are errors or real, and decide what to do with each.
5. 5 · Data · attach file Merge two spreadsheets by a shared column
   Combine two files on an ID or email and see exactly which rows did not match.
6. 6 · Data Write a regex to clean a column
   Get a tested pattern that finds or fixes messy values like phone numbers, codes or dates.
7. 7 · Data Turn messy notes into a structured table
   Paste scattered notes and get a clean table with consistent columns you can paste into a sheet.
8. 8 · Data Check my analysis for mistakes
   Get a second pair of eyes on your method, math and conclusions before you share them.

Related guides