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

Browser-only · 5 MiB max

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

  1. RFC 4180 — Common Format and MIME Type for CSV Files
  2. OWASP — CSV Injection

Privacy note: CSV parsing, cleaning, deduplication and export happen locally in your browser. The file is never uploaded.