Focused purpose
What this tool does
Clean CSV or TSV files locally, preview ordered repairs and download a checked CSV without an account. Duplicates, blanks, headers and dates stay under your control.
- ✓ Ordered transformation pipeline
- ✓ Before-and-after preview
- ✓ Undo and redo
- ✓ Export validation
Workflow
How to use it
- 01
Open a CSV or TSV and confirm delimiter, encoding and headers.
- 02
Add transformations in the order they should run.
- 03
Preview impact, undo if needed, then validate and export.
Available controls
Available options
- Trim and normalize only selected columns.
- Repair headers before row-level operations.
- No type conversion or deletion happens automatically.
- Save reusable settings locally as a recipe.
Messy customer CSV
Example before and after
The file contains duplicate rows, whitespace, ambiguous dates, an empty row and a spreadsheet-formula risk.
Before
customer_id,name,email,signup_date,country,total 000123, Ada Lovelace ,ADA@example.com,10/08/2026,FR,"1 299,50 €" 000123,Ada Lovelace,ada@example.com,10/08/2026,FR,"1 299,50 €" 000124,Linus Torvalds,,08/10/2026,FI,0 000125,"=2+3",test@example.com,2026-08-10,US,42 ,,,,,
After
customer_id,name,email,signup_date,country,total 000123,Ada Lovelace,ADA@example.com,2026-08-10,FR,"1 299,50 €" 000124,Linus Torvalds,,2026-10-08,FI,0 000125,"'=2+3",test@example.com,2026-08-10,US,42
Expected result: A reviewed pipeline produces a clean file and records every applied transformation.
Practical scenarios
Common use cases
Prepare contacts for a CRM import.
Standardize supplier exports.
Clean a spreadsheet export without changing identifiers.
HONEST LIMITS
Important limitations
- iAmbiguous dates and encodings always require confirmation.
- iThe browser sets the practical memory limit; streaming mode disables global operations.
FAQ
Questions about this tool
In what order are cleaning steps applied?
Exactly in the order shown in the history. Reordering changes the result and requires a new preview.
Can I undo a cleaning step?
Yes. Undo and redo recompute the working copy from the untouched original.
What will the cleaner never change automatically?
It never guesses ambiguous dates, deletes rows, converts identifiers or repairs uncertain encoding without an explicit choice.