ListCleaner Pro

ListCleaner Pro


Platforms: Windows XP-SP2 / 2003 / Vista / Windows 7 & 8
Version: 6.2
Size: 54 MB
Record Limit: 150,000 records per import
Compatible File Formats: Excel (Including 2012), Access (Including 2012), Dbase (Versions 3,4 & 5), Text (.txt, .csv), Outlook (Including 2012).

WinPure ListCleaner Pro is our entry level data cleansing and matching software. With 8 easy-to-use modules, ListCleaner Pro helps you maintain virtually any type of list - easily, quickly and cost effectively. If you require more powerful data matching and enhanced data cleansing then our award-winning WinPure Clean & Match might be more suited.


Improve the Performance of Your Marketing Efforts. By maintaining clean customer lists, WinPure ListCleaner Pro will help you:

  • Increase the accuracy of your customer data.
  • Reduce marketing postage costs by eliminating duplicates from your database
  • Improve virtually any type of list (contact lists, e-mail lists, prospects, etc.) from a variety of list sources such as Excel, Access and text files generated from
    Outlook or CRM systems.
  • Improve your company image by using standardized styles for names and addresses with error-free data.

WinPure ListCleaner Pro is equipped with 8 Powerful and Easy-to-use modules:

  • DataTable
  • Statistics module
  • Case Converter module
  • Text Cleaner module
  • Column Cleaner module
  • Email Cleaner module
  • Dupe Remover module
  • Table Matcher module

1. Manage your Datatables/Lists with the Datatable module

1. Import

  • Import your data from Excel, Access or Delimited Text Files (for Outlook or other CRM applications). You can import one or two lists.
  • You can use this module to view/edit/sort/remove records, just like you would do on a database or spreadsheet.
  • Once you have corrected and deduplicated your lists, then you can come back to this module and export the cleansed list, either to the same filename or to a new filename or filetype. Export your results or filtered selections to Excel, Access, or Text files.

2. Identify and Correct Missing Data Problems with the Statistics module


  • The Statistics Module will quickly help identify missing data in your lists, simply and effectively.
  • This can be great for finding out how much of your data is fully populated (eg. How many missing names or postcodes exist on your list, how many contacts have missing email addresses?,etc).
  • Featuring a score table and score graph, you will be able to quickly view how many records in your list/s have been populated and not been filled in.

3. Use Upper and Lower Case Consistently with the Case Converter module


  • The Case Converter Module ensures that your data is professionally presented. It allows you to make any field UPPER CASE, lower case or Proper Case. Proper case (or Title Case) will take data such as “john mcneal” and convert it to “John McNeal” or convert addresses from “123 maple lane” to “123 Maple Lane”. Includes Prefixes and Exceptions functions to fully customize how names and addresses are corrected.
  • Using this Case Converter module, you can quickly convert this:
    John smith, 132 park hill road, london, sw12-5ty
    John Smith, 132 Park Hill Road, London,SW-5TY (Notice the capital letters, ensuring a much more professional look)

4. Clean Data Fields of Unwanted Characters with the Text Cleaner module


  • This advanced Text Cleaner Module will automatically remove non-printable characters, leading or trailing spaces, and repeated non-alpha characters. It also has advanced options for cleaning data into alphabetic only or numeric only values.
  • Before doing a match/deduplication on your list/s, this is a great module to use because by removing all unwanted characters, a list deduplication will then be much more effective.

5. Clean Column Data with the Column Cleaner module


  • The Column Cleaner Module groups together and counts common values in a column to help identify duplicates or discrepancies. The data can then be corrected for any incorrect group and set to any value that you choose.
  • By simply choosing the incorrect values from your list, then deciding on the new value, WinPure ListCleaner will quickly and effectively correct all the values in the required column

6. Manage your E-mail Address Lists with the Email Cleaner module


  • This Email Cleaner module will quickly identify inaccurate email addresses from your list
  • This is a great module if you are intending to send your customers emails, as it will not only identify any incorrect emails, but it will also provide suggestions to them (e.g. “” becomes “”)
  • Manipulate your data using sort, count, filter and duplicate removal functions.
  • Maintain custom lists of valid country and top level domains (e.g. “.UK” for United Kingdom, “.gov” for government.

7. Dupe Remover module. A quick and powerful Dedupe Module for finding duplicated records


  • The Dupe Remover module will quickly identify any duplicated records in your lists, whether its names, addresses, emails, etc.
  • Simply select the columns you wish to use for the matching, then click 'SEARCH'. WinPure ListCleaner will then quickly search for any duplications and then list them in groups, in order for you to select, exclude, delete or edit them.
  • You can even export just the duplications or the records that do not have any duplications, all at the click of the mouse button.
  • Please note: ListCleaner Pro/Lite does not contain fuzzy or phonetic matching, if this is what you require please take a look at our Clean & Match 2013.

8. Find matches within two seperate lists, using the Table Matcher module


  • The Table Matcher module is used to match two seperate lists.
  • By simply selecting the columns you wish to use for the matching, then clicking 'SEARCH', WinPure ListCleaner will then quickly search for any duplications from both lists and then list them in groups, in order for you to select, exclude, delete or edit them
  • You can even export just the duplications or the records that do not have any duplications, all at the click of the mouse button.

Differences between ListCleaner Pro and ListCleaner Lite

  • Import and handle larger data files
  • Import Two Seperate Lists
  • Statistics Module
  • Table Matcher module
  • Email suggestions on incorrect email addresses
  • Advanced data filtering techniques
  • Various additional customized features

WinPure ListCleaner Pro Complete Features List:

  • Datatable module
    Import Delimited Text, Excel, Access files.
    Export Delimited Text, Excel, HTML, Access files.
  • Case Converter module
    UPPER CASE converter.
    lower case converter.
    Proper Case converter.
    Prefixes & Exceptions customiser - Filter on selected values..
  • Dedupe Remover module
    Duplicate Search on Selected Columns.
    Automatic or Manual Removal of Duplicated Records.
    Filter on selected duplications.
  • Table Matcher module
    Duplicate Search on Two Seperate Lists.
    Automatic or Manual Removal of Duplicated Records.
    Filter on selected duplications.
  • Text Cleaner module
    Remove Leading and Trailing Spaces.
    Remove Repetition of Non-Digit, Non-Alpha Characters.
    Remove Non-Printable Characters- Remove Leading and Trailing Spaces.
    Alpha Only Column Cleaner Features.
    Numeric Only Column Cleaner Features.
  • Column Cleaner module
    Unique List of Values.
    Count of Unique List of Values.
    Sort List of values by either Count or Alphabetical/Numeric order.
    Multiple changes for list cleaning.
    Filter on selected values for list cleaning.
  • Email Cleaner module
    Email Analysis Engine (EAE) which gives suggestions for incorrect email addresses.
    Sort/Filter/Count on every aspect of the email address (name, sub-domain, domain, country)
    Two fully customised domains lists
  • Statistics module
    Identify 'complete' or 'incomplete' data within columns.
    Column/File scoring technique.
    Choose from 4 different graphs.
    Filter on selected value.