Made a tool that fixes messy CSVs with AI - dates, duplicates, formatting

Working with client data exports is painful. Different date formats, duplicate rows, inconsistent text cases, missing values...

Built CleanCSV to handle this automatically.

What it does

• 🔍 Detects column types and suggests appropriate fixes
• 📅 Standardizes dates - handles MM/DD/YYYY, DD-MM-YYYY, ISO, and more
• 🔢 Cleans numbers - removes currency symbols, fixes decimal separators
• 🚮 Removes duplicates - with smart matching
• 🤖 AI suggestions - recommends transformations based on your data

How it works

1. Upload your messy CSV
2. Preview the detected issues
3. Apply fixes (or let AI suggest them)
4. Download clean file

Why I built this

Every time I got a data export from a client or API, I'd spend 30+ minutes cleaning it in Excel or writing a Python script. Figured there had to be a better way.

Free tier available - handles most use cases.

Link: https://cleancsvai.com

What's the worst data mess you've had to clean up?