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.

  • Free, no account needed
  • Checked by 9 test cases
  • Runs in your browser: nothing you enter is sent to us
  • Updated November 19, 2026
Drop a CSV file here or choose one CSV, TSV or TXT, up to 60 MB. Read in your browser; never uploaded.
Or paste CSV text

How to use this tool

  1. Load a file or paste CSV.
  2. Choose the clean-ups and the columns to keep.
  3. 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.