How to use CSV cleaner
- 1
Choose your CSV file.
- 2
Tick the clean-ups you need, choose how column names should look, and optionally a column to sort by.
- 3
Press Clean CSV and download the clean file. The summary shows what was fixed.
What this tool does
The CSV cleaner tidies a CSV file so it's ready to import, analyse or share. It handles the routine fixes that would otherwise mean a dozen steps in a spreadsheet, and tells you exactly what it changed.
Features
- Trim values and remove empty rows.
- Remove empty columns that have a header but no data.
- Remove duplicate rows that are exact copies.
- Tidy column names: trimmed, snake_case, lower case or Title Case.
- Sort by a column, with natural number order, and change the separator.
Limits
- Duplicates are exact matches only; rows that differ by a typo aren't merged.
- Cell contents aren't otherwise changed: dates, number formats and spelling stay as they are.
Where your file is processed
This tool works in your browser: your file is cleaned on your own device, so it isn't sent to our server for this tool. Some other tools on UtiloNest do use our server, and their pages say so.
Frequently asked questions
What kind of mess does it fix?
Spaces before and after values, blank rows, columns with nothing in them, repeated rows, and inconsistent column names. These are the most common reasons imports into databases, CRMs and email tools fail.
How are column names tidied?
You can keep them as they are (only trimmed), or turn them into snake_case such as first_name, lower case, or Title Case. snake_case is what most databases and programming languages prefer.
How does sorting work?
Rows are sorted by the column you choose, with numbers in number order (2 before 10) and empty cells last. Tick the option for Z to A or largest first.
Can it change the separator?
Yes. Read a semicolon-separated file from European Excel and save it with commas, or the other way round, using the output separator option.
Is my file uploaded?
No. Cleaning happens in your browser, on your own device.