When are two rows really duplicates?

By Abriam Downing · October 4, 2026

Duplicate cleanup feels simple until two different customers share a name, or one person has two legitimate records. Start by deciding what a duplicate means for this specific file.

Use the smallest safe rule first.

Rowstead compares every value in a data row. If the complete row matches another row, the exact-duplicate option keeps the first one. Two rows with the same email and different company details remain separate. Two matching names are not enough to merge people.

Spaces can change the result.

Robin Lee and Robin Lee are different text. If you select trimming, Rowstead trims cell edges before comparing duplicates. That can make previously different rows match. Compare the original and cleaned previews and keep a source backup.

A repeatable five-minute review.

1. Make a copy of the original export.
2. Load the CSV and check whether the first row is a header.
3. Review exact-duplicate and whitespace counts.
4. Apply only the cleanup choices you understand.
5. Export the cleaned file and audit, then test a small import.

Keep a useful change log.

Record the original filename, source, date, chosen cleanup options, row counts, and the result of the destination’s test import in your own private records. The Rowstead audit contains aggregate counts and no cell contents. It helps you document a cleanup; it does not certify an import.