CSV Cleaner & Deduplicator
Normalize headers, trim whitespace, drop the empty rows and columns, remove duplicates — and check that your key columns are actually unique before you load the file anywhere.
Clean up
Output is always comma separated.
What changed
Ready to automate?
Simple Data Foundry applies the same tidy-up on every scheduled run — pick your columns, filter the rows, map the names once, and every future load arrives clean.
Frequently Asked Questions
Why normalize headers?
Headers with spaces, punctuation or mixed casing break in most destinations — SQL columns need quoting, formulas need escaping, and two columns that differ only in casing collide. Normalizing to snake_case once, at load time, avoids all of it.
What does the key uniqueness check tell me?
It reports whether the columns you picked identify each row exactly once. That matters when a sync runs in upsert mode: a key with duplicates means rows overwrite each other and your destination silently ends up with fewer rows than your source.
Which duplicate does it keep?
The first occurrence, in file order. Later rows sharing the same key are dropped, so if your export is sorted oldest-first you keep the oldest record — sort the file the other way first if you want the newest.
Does it handle semicolon or tab separated files?
Yes. The delimiter is detected from the header row, and you can override it. Quoted fields containing delimiters, quotes or line breaks are parsed correctly and re-quoted on the way out.
Is my data safe?
Yes. The file is read and processed in your browser. Nothing is uploaded — which also means large files are limited only by your own machine.