CSV Cleaner
Remove empty rows, trim spaces, and normalize headings, with a preview of the changes.
Comma, semicolon or tab separated, or upload a CSV or XLSX file. The first row holds the column names.
Your result
Paste a table or upload a file to see it cleaned.
How to use it
- Paste the table or upload the file, or try the sample.
- Choose the cleaning options.
- Check the preview, then download or copy the CSV.
Examples
- Spaces around values Ada , London Ada,London
- Empty rowA line of empty cells such as ,, The row is removed
- HeaderFull Name full_name
Tool details and privacy
Paste a table or upload a CSV or XLSX file: spaces around each cell are trimmed, empty rows are dropped and the header is tidied. Then download the clean copy.
A stray space makes "London" and " London" two different values when you sort or match.
Options
- Tidy the header: lowercase with underscores instead of spaces (can be turned off).
- Squeeze repeated spaces inside cells, and remove exactly repeated rows when you ask.
Limits
- Numbers are not changed and a comma is not guessed as a thousands mark.
- Up to 5,000 rows in the browser.
Privacy
What you type or open stays in your browser. Nothing is uploaded or saved on the server.
Questions
Does it read Excel files?
Yes: .xlsx, CSV and TSV, read in your browser.
Does it remove repeated rows?
Only when you tick "Remove repeated rows".
Why does Arabic show correctly in Excel?
The download carries the UTF-8 mark Excel needs.
Is the table uploaded?
No.