# Clean a CSV or Excel file in one pass

> Drop a CSV or Excel file and tick the fixes you want. The counts and the cleaned table update as you tick.

Trim spaces, remove blank and duplicate rows, fix headers and standardize dates in a CSV or Excel file. Every fix is counted. Runs in your browser.

- Tool: [CSV cleaner](https://fixmint.cc/csv-cleaner)
- Category: [Spreadsheets & data](https://fixmint.cc/spreadsheets)
- Fixes: Messy CSV with blanks and copies
- Runs in the browser: files and text stay on the device, no sign-up, free.

## How to clean a CSV or Excel file

1. Drop a CSV or Excel file, or paste rows from a spreadsheet.
2. Tick the fixes you want and see how many cells and rows each one changes.
3. Download the cleaned table as CSV or Excel.

## Questions

### Which fixes delete data?

Removing empty rows, empty columns and duplicate rows deletes data. Spacing, invisible characters and line breaks only change how text is written. The counts show what each fix did.

### Why is a date left as it was?

A date such as 03/04/2025 can mean 3 April or 4 March. A date is written as YYYY-MM-DD only when its day and month cannot be confused. Ambiguous dates and two-digit years are counted and left as they are.

### What counts as a duplicate row?

Two rows are duplicates when every remaining cell matches after the other fixes. The first copy is kept and the later copies are removed.

### Does my file leave my device?

No. The file is read and cleaned in your browser, and nothing is uploaded.

## Related tools

- [CSV column profiler](https://fixmint.cc/csv-column-profiler): Need stats for every column
- [Data type checker](https://fixmint.cc/data-type-checker): Column has mixed formats
- [Excel to CSV](https://fixmint.cc/excel-to-csv): Need CSV, have an Excel file
- [Anonymize spreadsheet](https://fixmint.cc/anonymize-spreadsheet): Names and emails in a table