Customer and Lead list formatting Program

Looking for a program to help clean up and format various files to be outputted to a single xls or csv file in the fastest most effluence way. We receive multiple Customer/Lead lists in xls, csv. Data is not standardized we need to consolidate and cleanup and create a standardized output file in xls or csv. Feature List Mac & PC compatible. Standalone or Web based. Importing Excel and CSV file. Cut and Paste to columns Ability to add/remove & reorder columns Each column should allow for custom formatting, i.e. converting to UpperCase,LowerCase, Zip Code formatting, Phone Formatting, Valid email, Default Values. Salesperson match based on State field Salesperson match based on fuzzy match. i.e.. jsmith, smithj, j smith = John Smith Split column data Merge columns Required Fields Duplicate checking within columns Rename columns. View and Export can have different name. Ability for Tooltip per column Insert/Delete row data Stripping Leading and Trailing spaces in data Save projects as templates for later reuse.