2,500 real records with mangled states, phones, and duplicates, fixed on camera.
How to Clean Up Messy Data in Minutes with Claude AI (Excel)
p2automation May 2026
Watch on YouTube youtube.com →Yes, and it is one of AI's highest-win, lowest-risk uses. Describe what clean looks like and it will dedupe, standardize dates and phone numbers, fix casing, and flag outliers while keeping your original file intact. On thousands of rows, make it write and run code (ChatGPT's data analysis, Claude in Excel) rather than editing values from memory, then diff before and after so nothing silently changed.
18 resources.
2,500 real records with mangled states, phones, and duplicates, fixed on camera.
p2automation May 2026
Watch on YouTube youtube.com →A finance educator's three concrete methods, directly usable on your books.
Christian Martinez (AI for Finance) Mar 2026
Watch on YouTube youtube.com →Running LLMs inside the sheet at scale instead of copy-pasting rows into chat.
The GRAPH Courses Apr 2026
Watch on YouTube youtube.com →Shows a tool that genuinely tolerates messy input: mixed types, odd dates, whitespace.
NeuralNine Oct 2025
Watch on YouTube youtube.com →A senior analyst pairs SQL with AI so you see the professional-grade version.
Jess Ramos 2025
Watch on YouTube youtube.com →Builds a reusable cleaner so the same mess never costs you twice.
Excel For Freelancers Feb 2026
Watch on YouTube youtube.com →The speed benchmark: what a dedicated cleaning tool does in one minute.
DataClean May 2026
Watch on YouTube youtube.com →OpenAI's own recipe, including keeping the original file untouched while writing a cleaned copy.
OpenAI 2025
Open learn.chatgpt.com →A structured course if data cleanup is a recurring part of your week.
DataCamp 2025
Open datacamp.com →Covers formats, missing values, and outliers across ChatGPT, Claude, and Gemini.
Analytics Vidhya May 2025
Open analyticsvidhya.com →A data journalist's controlled experiment showing exactly where AI cleaning fails.
Roberto Rocha 2023
Open robertorocha.info →The foundational prompt patterns for inconsistencies, capitalization, and spacing.
Packt 2023
Open packtpub.com →Compact reference of cleansing prompts you can keep beside your keyboard.
Kanaries 2024
Open docs.kanaries.net →A practitioner's honest notes on batch sizes and when chat cleaning breaks down.
Tirabassi 2024
Open tirabassi.com →A tool survey for when one-off prompting stops scaling.
Numerous.ai 2025
Open numerous.ai →Goes beyond cleaning into enrichment: filling gaps with AI-sourced context.
Peak Digital 2025
Open peakdigitalstudio.com →Excel-specific walkthrough with copy-ready prompts for common messes.
Bricks 2025
Open thebricks.com →A short operator-focused workflow you can hand to anyone on your team.
AI Academy 2025
Open ai-academy.com →The same ground, over in Grow & market, our Starting Up track.