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.
Verify a Cleaned Inventory CSV
CSV Data Cleaner: how to use it
- Paste the table or open a local text file. Choose the separator and whether the first record is the header, then read the CSV.
- Apply each cleaning action and check the log. Compare the original and cleaned views or find values in the preview.
- 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.