Free Online CSV Cleaner, Tidy Rows, Spaces and Blanks
Tidy up a messy CSV export in your browser. Ragged rows are squared up so columns stop shifting, stray spaces and invisible characters are removed, empty rows and columns go, and headings can be tidied into a consistent form. Values are never retyped, so a product code of 007 stays exactly as it is.
| Nothing to show yet. |
| Nothing to show yet. |
Enjoying WizTools123? Help keep our server infrastructure 100% free and open for everyone.
How to Use Bulk CSV Cleaner
Step by step, start to finish.
One or many. The originals are never modified; you get cleaned copies back.
Padding short rows is the safe default. Removing them is right when a short row means a broken record rather than a missing value.
Trimming and removing invisible characters are on by default because they are almost always wanted. The heading styles are there for feeding a database or an API.
The list under the options says exactly what was changed and how many times. Download one file, or all of them as a zip.
Key Features
What this tool does, and what it does not do.
Short rows padded, long ones trimmed or kept, so columns stop shifting on import.
Trimming, collapsing and removing the characters that make identical values fail to match.
Nothing is parsed and rewritten, so leading zeros, currency symbols and date spellings survive.
Trim, snake case, camel case or title case, with unnamed columns named and repeats numbered.
Clean a whole batch with one set of settings and take them away as a single zip.
A list of every fix applied with a count, so nothing is changed without you seeing it.
About Bulk CSV Cleaner
Exports arrive messy in predictable ways. The system that wrote the file put a trailing comma on the header, so there is a nameless extra column. Somebody typed a space before a city name. A row is missing its last field because a value was empty at the end. None of it looks serious, and all of it makes the next step fail.
The failures are quiet, which is what makes them expensive. A trailing space means a lookup finds nothing and a report shows a gap. A short row means every value after the gap loads into the wrong column, and the data is wrong rather than missing, so nothing complains. A zero width space pasted in from a web page means two identical looking customer names are two different customers forever.
What this page deliberately does not do is tidy your values. It is tempting for a cleaner to parse every field, decide 007 is the number seven and 1,240.50 is 1240.5, and write them back in a canonical form. That turns a product code into a different product code and a formatted figure into a bare one. Alignment, whitespace and headings can all be fixed safely; the contents of a field cannot, so they are passed through untouched.
Frequently Asked Questions
Common questions about this tool.