03 / LOCAL DATA CLEANUP

Clean one CSV.
Review every change.

Run a small contact-list cleanup entirely in this browser. Choose exact keys and a duplicate policy, inspect quarantined rows, then download all three deliverables.

Use my CSV

Nothing is uploaded or saved by this tool. The sample is synthetic and is not a customer result.

01 Load or paste
02 Parse CSV
03 Choose keys
04 Review cleanup
05 Confirm changes
06 Download three files

INPUT / 01

Bring one UTF-8 CSV.

PENDING

Choose .csv file No file selected

CSV text paste or edit locally

Supports UTF-8 BOM, LF or CRLF, quoted commas, escaped quotes, and quoted multiline cells. Limits: 1 MiB input, 10,000 data rows, 100 columns, 100 KiB per cell. Empty or duplicate headers, uneven rows, malformed quotes, and invalid UTF-8 files are rejected.

Not parsed.

POLICY / 02

Choose exact matching rules.

Key columns Select one or more. A row missing any selected key is quarantined.

Parse CSV to list headers.

Trim cell edgesRemove leading and trailing whitespace only. Internal whitespace and case stay unchanged.

Exact duplicate policy Collapse, keep first representative Keep all rows

Ready. Load the synthetic sample or enter CSV, then choose Parse CSV.

REVIEW / 03

Results stay pending until run.

PENDING

No cleanup has run. Downloads are unavailable.

INPUT—rows

CLEANED—rows

REVIEW—rows

COLLAPSED—rows

Exact duplicates

Conflicts

Missing keys

Trim changes

CLEANED PREVIEW

Rows ready for cleaned.csv

HUMAN REVIEW

Conflict and missing-key rows

Processed changes

Export-only protection

Before CSV quoting, cells beginning with a tab or newline, or with spaces then =, +, -, or @, receive a leading apostrophe. This includes negative numbers. The processed value is unchanged, and this is not a guarantee for every spreadsheet.

DELIVER / 04

Three local files.

cleaned.csv

Accepted rows, UTF-8 BOM, CRLF, and conservative spreadsheet-cell protection.

Download cleaned.csv

review-needed.csv

Quarantined rows with original row number and conflict or missing-key reason.

Download review-needed.csv

cleanup-report.json

Policies, counts, row classifications, original and processed values, changes, protections, and limits.

Download JSON report

I reviewed the cleanup counts, quarantined rows, changes, and export-only protections.

The JSON report includes original input values and may contain sensitive data. Store and share it with the same care as the source CSV. This tool does not upload it.

SMALL CSV REQUEST

Need the same careful pass?

One file, agreed key and cleanup rules, then a cleaned CSV, review CSV, and change report. AI-assisted personal project experience. Scope and fee are agreed after reviewing a sample.

Discuss a sanitized sample on X

한국어 의뢰 설명

CSV 한 파일을 합의한 키와 정리 규칙으로 처리하고, 정리본 CSV, 검토 필요 CSV, 변경 보고서를 제공합니다. AI 보조 개인 프로젝트 경험이 있으며, 범위와 보수는 샘플 검토 후 합의합니다. 공개 게시물에는 고객 데이터 대신 비식별 샘플과 범위만 공유해 주세요.

English request brief

I can process one CSV using agreed key and cleanup rules, then provide a cleaned CSV, a review-needed CSV, and a change report. I have AI-assisted personal project experience. We can agree scope and fee after reviewing a sanitized sample. Please do not post customer data publicly.

Clean one CSV.Review every change.