CSV Cleaner

Your file

Drop a CSV here or click to choose one

The sample is made-up sales data with every kind of problem the cleaner fixes.

Or paste CSV text

What to fix Trim extra spaces Blank out "N/A", "null", "-" and similar Remove empty rows Remove empty columns Write numbers, dates and yes/no consistently Remove exact duplicate rows

Make the download open cleanly in Excel

Adds a marker so Excel reads accented letters correctly.

Results

Choose a file, or try the sample, to see what the cleaner finds.

CSV cleaner

Your file

Results

What was changed

Columns

Needs a look

Preview of the clean file