CSV Cleaner
CSV input
Cleaned CSV
Summary
Options
Parsing
Cleaning
Output
About CSV Cleaner
CSV Cleaner standardizes messy CSV files: it trims stray spaces, removes blank and commented lines, normalizes headers, aligns column counts, and exports with your preferred delimiter, newline, and quoting rules.
What it fixes
- Inconsistent spacing around delimiters.
- Duplicate or poorly cased header labels.
- Rows with fewer or more columns than expected.
- Mixed newline styles across platforms.
Tips
- Enable “Align columns” and choose “Pad short rows” to safely keep data while fixing structure.
- Use a comment prefix to skip metadata lines (e.g.,
#or;). - Export with Quote all fields when you plan to import into strict parsers.