Compatible
File Formats: Excel (Including 2012), Access
(Including 2012), Dbase (Versions 3,4 & 5), Text (.txt,
.csv), Outlook (Including 2012).
WinPure
ListCleaner Lite is
an all-in-one single list cleaning, data cleansing and dedupe
software solution to ensure that your mailing list, contact
list, sales and marketing or other databases contain clean,
accurate data with no duplicates. With 6 easy-to-use modules
(8 in the Pro version), WinPure ListCleaner
Lite helps you maintain virtually any type of list from a variety
of data sources.
Benefits:
Improve the Performance
of Your Marketing Efforts. By maintaining
clean customer lists, WinPure ListCleaner Lite 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 Lite is equipped with 6 Powerful and Easy-to-use
modules:
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.
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
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”.
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
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.
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.
Differences between ListCleaner Pro and ListCleaner Lite
-
Duplicate Search including All Columns.
- Duplicate Search on Selected Columns.
- Automatic Removal of Duplicated Records.
- Filter on selected duplications.
-
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.
-
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.
