Customer and Lead list formatting Program
This project received 15 bids from talented freelancers with an average bid price of $186 USD.Get free quotes for a project like this
Project Budget$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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online