Customer and Lead list formatting Program
该项目收到15 来自天才威客的竞标，平均竞标价格为$186 USD。为像这样的项目获取免费报价
项目预算$30 - $250 USD
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.
- The New York Times
- Wall Street Journal
- Times Online