Clean up a CSV file
Paste a CSV or add a file — the parser handles quoted commas, embedded newlines and UTF-8/GBK encodings. Clean up with a few toggles, preview every step, and undo anything.
Drag & drop images here — or click to choose files
JPG · PNG · WebP — files stay on your device
Preview shows the first 50 rows; export covers everything.
How to use it
- Paste data or add a CSV/TSV/TXT file; pick the delimiter or let it auto-detect.
- Toggle trimming, empty-row/column removal or deduplication; preview the result.
- Export the cleaned CSV (with the safe-export guard on by default) — undo is one click.
Limits & formats
Up to 5 MB of text and 100,000 rows; the preview shows the first 50 rows but export covers everything. Quoted fields with commas, quotes and line breaks are handled per RFC 4180. Safe export prefixes cells starting with = + - @ with an apostrophe so spreadsheet apps do not execute them as formulas — turn it off only if you understand why the option exists. GBK/GB18030 files are decoded locally.
Privacy
Everything is computed locally in this browser tab; nothing is sent or stored.
Related tools
Feedback on this tool
Did it work well? Any improvement ideas? Leave a note — it helps YYSI improve the toolbox.
Notes are anonymous and reviewed manually: only you see yours right away (in this browser); others see them after approval. Do not include personal data or contact details.