• 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.

• 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.

• 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
  to:
  John Smith, 132 Park Hill Road, London,SW-5TY (Notice the capital letters, ensuring a much more professional look)

• 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

• 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. “alan#bakers.com” becomes “alan@bakers.com”)
• 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.

• 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.

• 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.

1. Manage your Datatables

• Import your data from Excel, Access or Delimited Text Files (for Outlook or other CRM applications).
• Manipulate your data with a variety of functions: view, edit, correct, cut/copy/paste, find/replace, sort, filter.
• Export your results or filtered selections to Excel, Access, Text or HTML.

2. Manage your E-mail Address Lists

• Ensure your e-mail campaigns are effective by quickly identifying inaccurate or duplicate e-mail addresses or address syntax errors.
• 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.

3. Use Upper and Lower Case Consistently

4. A quick and powerful Dedupe Module for finding duplicated records

• Select any or all columns to dedupe: names, addresses, e-mails and more.
• WinPure ListCleaner Lite will quickly find any matches and present them for you to choose which should be deleted.
• Duplicates can also be exported to a separate file.

5. Clean Data Fields of Unwanted Characters

6. Clean Column Data