Free open source tool for finding, deleting and exporting duplicates in an Excel worksheet with lots of extra features – Excel 2010-2019 (Windows optimized)

Source code
The source code is published on GitHub and can also be opened in the VBA editor as there is no password protection.

Installation
The tool is shipped as an add-in for Microsoft Excel (.xlam). After installation and activation the tool´s icon is added on the “Data” tab next to the “Data tools” group.

Download Version 2.0 – it´s free!

Automatic installation (recommended for Windows)
xl DuplikatManager (1974 downloads )

Manual installation
xl DuplikatManager (2480 downloads )

Number of downloads of previous versions: 302

Features
– Selection of multiple ranges on the worksheet while holding down the Ctrl key
– Two search modes: consider each selected area separately or merge non-contiguous columns
– Ignore upper/lower-case letters and/or blanks for the search if needed
– Coloured highlighting of duplicates, unique values or all different values
– Output duplicates, unique values or all different values ​​on a new worksheet (optionally the entire rows)
– Different deletion modes: only duplicates, complete lines, with and without compression (also in combination)
– Restoration of deleted duplicates possible
– Jump to individual duplicates with delete and restore function
– Non-destructive processing (the original content can be restored until a new area is selected or the tool is shut down)
– Permanent display of the number of duplicates, unique values, different values ​​and deleted duplicates
– Integrated quick guide with pictures, tips and examples
– The tool language can be switched between German and English

Screenshots

Donation
This tool is being developed and maintained with private effort and provided for free download. I would be very happy about a small donation to this foundation for sick children in the region of Heilbronn/Germany. Read more on the website of the foundation.

Donate now!