DedupeWizard 8 | |
| |
More deduplication software:
|
DedupeWizard is a program for the deduplication of Excel files. The telephone number, email address or postal address can be used to search for duplicates / dupes. Spelling variations are no problem. And with the matching between two files, advertising blacklists can also be taken into account, preventing problems with recipients who do not want to receive advertising.
Match data, eliminate duplicates
- Fast, largely automated and therefore user-friendly deduplication of address lists managed with Excel.
- Beside the deduplication within one file, DedupeWizard also includes a function for deduplication between two files. In this way, customers who do not wish to receive advertising (opt-out lists / Robinson lists / MPS lists) can be considered. Or your own customers can be removed from a table with addresses that should be used for the acquisition of new customers.
- The postal address (error-tolerant matching / fuzzy matching), telephone number and email address can be used as matching criteria to find and remove duplicates / dupes.
- Not only are exact matches found, where every single character matches, but also fuzzy duplicates and duplicate addresses. In particular, typos, spelling variations, omissions and additions, misplaced words, abbreviations and pet names / nicknames.
Other functions for quality improvement
- Furthermore, the DedupeWizard also contains a function, which can be used to find incomplete or obviously faulty addresses that are unusable for marketing purposes.
- A function for merging two tables.
- And a function to determine the letter salutation,with which the salutation line for letters and emails can be created in any form you like.
Ways to use the result
- The matching result can be processed by deleting the records identified as duplicates directly in the source table or by exporting either the cleansed data or the duplicates found to a new file.
- And deletion and result logs can be created, to print the deduplication results or save them as a PDF file.
- further information ...
Fast, flexible and safe
- Local processing of data, no need to transfer data to an external service provider. This simplifies compliance with the General Data Protection Regulation (GDPR).
- You can process Excel- (xls / xlsx / xlsm / xlsb) and OpenOffice / LibreOffice Calc-files (ods).
Note: Unlike DedupeWizard, DataQualityTools not only supports Excel as a data source, but also Access (accdb), Excel (xls / xlsx / xlsm / xlsb), dBase (dbf), CSV and text files. DataQualityTools even support database servers such as the MS SQL-Server, MySQL, PostgreSQL and Oracle. - Support for high-resolution displays (4k).
- Language of the user interface: English, German, French, Italian, Spanish, Turkish
- Tested and run compatible using Windows 10 / Windows 11.
Try now for 7 days free of charge
In order to be able to test our software without any restrictions, you can request a trial activation for one week. A corresponding option is presented when you open the program for the first time. The activation key will be sent to you per email. Free mail addresses such as Yahoo.com or gmail.com are not admissible for this purpose. Thank you for your understanding.
DedupeWizard | |
---|---|
Maximum number of records per table | unlimited |
Data sources: | |
Excel (xls / xlsx / xlsm) | ![]() |
OpenOffice / LibreOffice (ods) | ![]() |
Matching functions: | |
Deduplication in One File | ![]() |
Deduplication between Two Files | ![]() |
Other functions: | |
Verify Addresses | ![]() |
Verify phone number | ![]() |
Verify email address | ![]() |
Determining the Salutation for Letters | ![]() |
Creating a Standard Address File | ![]() |
Merging Tables | ![]() |
CSV-to-Excel-Converter | ![]() |
Ways to use the result: | |
Manual Post-Editing | ![]() |
Deletion Log | ![]() |
Deleting in the Source Table | ![]() |
Results File | ![]() |
Archive File | ![]() |
Note:
Unlike DedupeWizard, DataQualityTools not only supports Excel as a data source, but also Access (accdb), Excel (xls / xlsx / xlsm), OpenOffice / LibreOffice (ods), dBase (dbf), CSV and text files. DataQualityTools even support database servers such as the MS SQL-Server, MySQL, PostgreSQL and Oracle.