Clean a CSV
Removes empty rows, surrounding spaces, empty columns and non-breaking spaces; normalises headers.
- Local processing
- Accepted formats .csv .txt .tsv .xlsx .xlsm .ods
- Produces csv
- up to 50 files
Drop your files here or Browse
Drag and drop, or click to pick. Files stay on your computer.
.csv .txt .tsv .xlsx .xlsm .ods
Options
Add at least 1 file(s).
People use it to
- « remove empty lines »
- « trim spaces in every cell »
- « drop empty columns »
- « normalise column names »
Related tools
Change CSV separator
CSV & Excel csv txt tsv xlsx … Local processing
Fix accents and encoding
CSV & Excel csv txt tsv json … Local processing
CSV to Excel (XLSX)
CSV & Excel csv txt tsv Local processing
Excel to CSV
CSV & Excel xlsx xlsm xls ods Local processing
Merge several CSV files
CSV & Excel csv txt tsv xlsx … Local processing
Split a CSV
CSV & Excel csv txt tsv xlsx … Local processing