CSVToolbox is a collection of tools that can be used ‘clean’ CSV files, Excel spreadsheets and database tables that can be imported/exported to/from CSV files. Cleaning includes:

    • identifying missing information and blank fields;
    • reformatting dates, phone numbers, and other types of numerical fields;
    • identifying and potentially fixing misspelled personal names;
    • fixing and verifying US based addresses; and
    • removing duplicate records.

Any number of files can be input and processed.  You can define any number of output file formats and generate them one at a time as needed or all at once.

These tools have been used to clean personal contact and mail lists from multiple sources on a semi-regular basis for a non-profit organization quarterly mail and phone campaigns.