Code · Made a little simpler

CSV Data Cleaner

Trim cells, remove duplicate rows and columns, normalize dates, fill empty cells or filter selected values. Review the cleaning log and export the result locally.

Free to useNo account neededProcessed on your device
Your workspaceProcessed on your device

Add this tool to your website

Paste this code into your page to add the tool and a visible ToolMellow credit link.

HTML embed code
Preview embed

CSV Data Cleaner: how to use it

  1. Paste the table or open a local text file. Choose the separator and whether the first record is the header, then read the CSV.
  2. Apply each cleaning action and check the log. Compare the original and cleaned views or find values in the preview.
  3. Undo a step if needed and download cleaned.csv when the resulting rows are ready.

Limits and notes

Up to one million UTF-16 code units, 150 columns, 250,000 padded cells and 20 cleaning actions. CSV export uses comma delimiters and CRLF record endings. Extra fields in uneven records remain in the output.

How your privacy works →

CSV Data Cleaner: common questions

How do I remove duplicate rows?

Choose Remove duplicate rows. It keeps the first match across the current columns, with optional case-insensitive comparison. Trim first if spaces should be ignored.

How are slash dates interpreted?

Choose the month/day or day/month order explicitly. Years 00–49 use 2000–2049 and 50–99 use 1950–1999. Invalid calendar dates stay as entered.

Will preview search remove records from the export?

Preview search changes the rows shown. Use the Filter rows action when you want a value to change the output.

Guides