中文 →

CSV Cleaner

Drop a file and remove duplicate rows, empty rows and columns, and stray spaces. 100% local processing — your file is never uploaded. Delimiters and encodings auto-detected.

Drop your CSV here
or click to browse (processed locally, instant under 5MB)
Pro version (coming soon)

Batch multi-file processing, dedupe by column, regex replace, direct Excel export. Everything on this page stays free forever.

Why a local cleaner instead of a spreadsheet

Three things spreadsheets handle badly: ① deduplicating hundreds of thousands of rows grinds them to a halt — this tool does it instantly; ② CSVs saved in non-UTF-8 encodings open as mojibake — this tool auto-detects; ③ online tools want your data uploaded — this one never uploads anything and works offline.

FAQ

Is my file uploaded?
No. The file is read with the browser's built-in FileReader and processed entirely in your device's memory. It works offline.
The preview looks like mojibake — what now?
The file is probably GBK-encoded but was read as UTF-8. Set Encoding to "Auto" (or GBK) and hit Re-parse.
What is a delimiter?
CSVs use commas, but some tools export semicolons or tabs. "Auto-detect" picks whichever symbol appears most in the first line — you can usually ignore this setting.
How large a file can it handle?
Pure in-memory frontend processing: smooth up to ~100k rows. Larger files are best split first.