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

Published: (March 9, 2026 at 01:44 PM EDT)
1 min read
Source: Dev.to

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

  1. Upload your messy CSV
  2. Preview the detected issues
  3. Apply fixes (or let AI suggest them)
  4. 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?

0 views
Back to Blog

Related posts

Read more ยป