How do I dedupe on just an ID column?

Name that column in the compare field. Rows sharing an ID are then treated as duplicates even where other columns differ — which is also how you find inconsistent records.

CSV Duplicate Remover

Deduplicate rows on the whole row or a chosen key.

Loading tool…

About this tool

Removes duplicate rows, comparing either the whole row or only the columns you nominate as a key. Reports how many were removed.

Questions

How do I dedupe on just an ID column?: Name that column in the compare field. Rows sharing an ID are then treated as duplicates even where other columns differ — which is also how you find inconsistent records.

Privacy

This page does its work in your browser. What you paste is processed by JavaScript running on your own device and is never sent to a DevToolery server — there is no server that could receive it. The page itself is a static file delivered by a CDN. See exactly what is stored.