CSV Cleaner and Deduplicator
Load a CSV, tick the clean-ups you want and see exactly how many rows and cells each one changes before downloading the cleaned file. Your original file is never modified.
Or paste CSV text
How to use this tool
- Load a file or paste CSV.
- Choose the clean-ups and the columns to keep.
- Check the summary and preview, then download the cleaned CSV.
How it works
Operations run in this order: trim spaces, collapse repeated spaces, remove empty rows, remove duplicate rows (exact, or ignoring case, on the columns you choose), keep selected columns, then write the file with your delimiter and line endings. Formula protection prefixes cells starting with = + - @ with an apostrophe.
Limitations
- Up to 60 MB. Duplicates are matched exactly (or ignoring upper/lower case); near-duplicates such as typos are not merged.
Privacy and data
Files are read and processed in your browser. They are never uploaded to our server or anyone else, and nothing is kept after you close the page.