DATA TOOLS
CSV Cleaner & Deduplicator
Clean up messy CSV files in your browser: trim cells, remove blank rows or columns, deduplicate selected fields, and export a safer copy.
LOCAL CSV PROCESSING
Clean a CSV file
Files are read locally and are limited to 5 MiB. You can also paste data below.
Quoted commas, escaped quotes and multiline cells are supported. Automatic delimiter detection checks comma, tab, semicolon and pipe.
Rows matching on all selected columns keep the first occurrence. Leave all unchecked to keep repeated rows.
Cleaning summary
data rows remain · duplicates removed · blank rows removed · empty columns removed.
Preview shows up to 20 cleaned rows. Download or copy the complete output.
CSV data stays in this browser. Nothing is uploaded; formula-like text is escaped in the exported file by default.
CSV cleaner guide
This cleaner parses quoted CSV fields instead of splitting rows on commas, so commas, escaped quotes and line breaks inside quoted cells remain part of their original values.
Clean and deduplicate safely
Choose whether the first row is a header, select any columns that define a duplicate, and decide whether matching should be case-sensitive. The first row with a matching key is preserved. Empty columns are removed only when every cell in that column is blank.
CSV formulas can be dangerous when a spreadsheet opens untrusted data. Formula protection is on by default and prefixes risky text cells with an apostrophe; inspect the result if another system expects the original values.
Frequently asked questions
Which CSV delimiters can it detect?
Automatic detection checks comma, tab, semicolon and pipe delimiters. You can choose one explicitly if the sample is ambiguous.
Does deduplication remove rows that only share selected values?
Yes. Select one or more columns to define a duplicate key. The first matching row is kept; later matches are removed. With no selected columns, duplicate removal is off.
Why are formula-like values prefixed with an apostrophe?
Spreadsheet programs can execute cells beginning with formula characters. The export prefixes risky text cells with an apostrophe to reduce CSV formula-injection risk; review the result before importing it into another system.
Is the selected file uploaded?
No. The file is read and processed in your browser. This page limits inputs to 5 MiB to keep local processing responsive.
Sources
Privacy note: CSV parsing, cleaning, deduplication and export happen locally in your browser. The file is never uploaded.