Duplicate detection answers: “Which rows share the same business key?” That is different from identical rows — two rows can differ in description but still collide on order id.
Define what “duplicate” means
Select columns that should be unique: customer email, national id, product SKU in a catalog, etc. Columnics groups by that key so you can review every duplicate cluster.
Workflow
- Upload your workbook or CSV.
- Choose the key columns on the configure step.
- Press Find duplicates, then filter or export duplicate-only / unique-only lists.
Because processing is local, you can run this on sensitive lists without sending them to a cloud compare service.