Made a tool that fixes messy CSVs with AI - dates, duplicates, formatting
Source: Dev.to
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
- Upload your messy CSV
- Preview the detected issues
- Apply fixes (or let AI suggest them)
- Download the clean file
Why I built this
Every time I received a data export from a client or API, I spent 30+ minutes cleaning it in Excel or writing a Python script. I figured there had to be a better way.
Free tier available โ handles most use cases.
Link:
Whatโs the worst data mess youโve had to clean up?