Runs locally in your browser
Delete repeated lines from a list while keeping the first or last occurrence, with optional case-sensitive matching.
About this tool
Duplicate rows appear after copying columns, combining exports, or collecting form responses. This tool removes repeated values without sorting the original order away.
Choose whether matching should respect letter case and whether the first or last occurrence should survive.
FAQ
Yes. It keeps the order of the surviving first or last occurrences.
Only when case-sensitive matching is turned off.
Related tools
Guides
Learn how to compare two lists in Excel with XLOOKUP, COUNTIF, and conditional formatting. Limitations explained plus when a browser-based tool works better.
Read guide →Learn decision-focused methods to remove duplicate lines while keeping first or last occurrence. Compare command-line, spreadsheet, and browser-local tools.
Read guide →Learn a workflow to reconcile customer, SKU, inventory, or account exports by ID. Covers normalization, duplicates, missing records, changes, and audit evidence.
Read guide →