← All guides

CSV whitespace and duplicate rows, explained

A duplicate depends on what you compare. Two rows can share a name and still represent different records. Check the cleanup rules before deleting anything.

Trim first, then compare

The first name below has a space on each side. With trimming enabled, both rows have the same name and code, so exact row deduplication keeps the first.

name,code
 Alice ,001
Alice,001

With trimming disabled, these are different strings. Trimming only removes leading and trailing whitespace; it does not remove spaces inside names or perform fuzzy matching.

Same name, different row

name,code
Alice,001
Alice,002

Both rows remain because the codes differ. The tool compares the full row. It does not select a single key column, identify people or merge their records.

Headers and blank lines

  1. Enable the header option if the first row contains column names.
  2. Blank-row removal skips rows whose cells are all empty. Whitespace-only cells can become empty when trimming is enabled.
  3. Review the row counts and removed-row totals. The preview shows up to 20 rows; the download includes the full result.

Keep the original file. Spaces or repeated rows may have meaning in your data, so turn off any cleanup step you do not need.

Commas, quotes and line breaks inside cells

CSV uses quotes around cells that contain commas or line breaks. For example, "London, UK" is one cell. A quote inside a quoted cell is doubled. If a quoted field is not closed, check the source CSV before continuing.

name,location
Alice,"London, UK"
Bob,"He said ""hello"""

What this cleanup does not do

It does not fix spelling, validate addresses, normalize phone numbers or decide which conflicting record is correct. Use the preview to check that the simple rules suit your file.