← ← All Tools
中文

🧹 CSV Cleaner

Clean header-based standard comma-separated CSV locally with explicit rules and an auditable result summary.

V1 is a local text-only cleaner. Input must be standard comma-separated CSV with a header row. Parsing, rule application, preview, and copy all stay inside the browser with no uploads and no automatic repair for broken CSV.

Only standard comma-separated CSV is accepted. Quoted fields, embedded commas, embedded line breaks, and BOM are supported. Blank headers, duplicate headers, and column mismatches are blocking.

Only the latest successful result can be copied. Any input or rule change, failure, or clear action invalidates the old result immediately.

Rule Panel

The rule panel is enabled only after the current CSV draft parses successfully and exposes a header row.

Waiting for Header
Keep Selected Columns

All columns are kept by default. If you uncheck and re-check a column, it is appended to the end of the current output column order.

Row Cleanup Rules

Only removes rows where every cell is the empty string in the current kept-column view. Whitespace is not trimmed automatically.

Applies exact whole-row dedupe to the current kept-column view. The first matching row is kept and later identical rows are removed.

Required Columns

If any selected column is the empty string, the entire row is removed. Options always stay constrained to the current kept columns.

Sort Rows

Sorting compares only the raw string values of one column and stably moves entire rows. Equal keys keep their original relative order.

Status Initial
Input Rows 0
Output Rows 0
Kept Columns -
Warnings 0
Errors 0 
Waiting for input.

Boundary note: this version does not support TSV, semicolon CSV, auto delimiter detection, file uploads, column merges, trimming, case normalization, regex replacement, key-based dedupe, multi-column sorting, or any kind of smart repair.

Formula risk: if the cleaned CSV is opened in Excel, Numbers, or Calc, cells starting with `=`, `+`, `-`, or `@` may still be treated as formulas. This tool only warns about the risk and does not silently rewrite your data.

Privacy note: input often comes from customer lists, order exports, or back-office data. Parsing, cleaning, and copy actions stay inside the browser with no uploads and no remote fetches.

More tools you might find useful.

🔄
CSV ↔ JSON Converter
Convert between CSV and top-level flat JSON arrays with header validation, error hints, and local copy.
🧩
JSON Diff
Compare two standard JSON values locally in your browser, ignoring object key order while keeping array order significant.
📋
JSON Formatter
Format, minify, and validate JSON, with TypeScript, Go, Java, Python, and C# code generation.
🔑
JSON Key Case Converter
Convert JSON keys between 9 naming styles: camelCase, snake_case, PascalCase, kebab-case & more with depth control
✅
JSON Schema Validator
Validate JSON data against JSON Schema with field paths, error reasons, and validity status.

Clean header-based, standard comma-separated CSV locally in your browser with explicit rules for column keeping, empty-row removal, dedupe, and single-column stable sorting. It is useful before table imports, small dataset cleanup, or sample delivery. Data is not uploaded, and malformed CSV is not automatically repaired, so keep an original copy before cleaning.