CSV Cleaner
Clean CSV rows, remove duplicates and normalize date columns
Enable JavaScript to use the interactive tool.
How to use this tool · examples & limitations
Clean CSV rows, remove duplicates and normalize date columns.
Getting a reliable result
Begin with a few representative records, including an empty field and a non-ASCII character. Check field names and types after conversion.
Worked example
The included example contains a duplicate Alice row and a missing Bob amount. With trimming and deduplication enabled, keep one Alice row. Selecting DD/MM/YYYY converts 31/12/2025 to 2025-12-31 without guessing date order.
Limitations to check
Formats differ in their treatment of nulls, dates, comments and numbers. Converting between them can lose information.
For network services, accounts and optional usage records, see our privacy policy.