CSV Repair Kit

Runs in your browser

CSV Cleaner

Remove duplicate rows, drop empty rows, and trim whitespace.

Your files never leave your device.

Drop a CSV to clean

CSV, TSV, or text. Processed locally — the file is never uploaded.

Try a sample:

What this cleaner is for

Merged CRM exports accumulate blank separator rows and repeated emails. Downstream imports then create duplicate contacts. Cleaning is mechanical: it does not fuzzy-match names.

What each option does

  • Trim removes leading and trailing whitespace in every field.
  • Empty-row removal drops records where every cell is blank.
  • Duplicate removal hashes the entire row. Two rows with the same email but different plans are kept.

Example

email,plan
a@x.com,free

a@x.com,free
b@x.com,pro

After cleaning:

email,plan
a@x.com,free
b@x.com,pro

Limitations

Near-duplicates (same person, different spacing in a name) are not merged unless trim makes the rows identical. Use the compare tool if you need a key-based diff instead of whole-row equality.

FAQ

Are duplicates case-sensitive?

Yes. A@x.com and a@x.com are different rows. Trim does not change letter case.

Is a row of commas empty?

If every field is blank or whitespace, the row is empty and can be removed.

Does cleaning reorder rows?

No, aside from dropping copies. First or last occurrence is kept in place relative to other unique rows.

Related tools