Excel/CSV - Convert words to numbers

We currently have a web site that needs updating. The way it is updated is via a csv file (attached). There are close to 100 manufacturers that have thousands of products. Each manufacturer is split up into its own spreadsheet. In the spreadsheet example provided, you will see what you will start with and how we need the file to be returned to us. References for the numbers' values will be provided (This will tell you the numeric value of a name,; after viewing the attached file, it'll make sense).

Another part of this project is that there are product names which need to be replicated, but the model number and option (color, size, etc) needs to be removed.

Example: Product Name modelnumber-1a Black product

Product Name modelnumber-1b White product

Result: Product Name modelnumber product

(A better example is in the attached file)

You must have experience with this. It is simply a matter of filtering columns and replacing a word with a number. Turn around time for each file should be, at most, 3 days. Over the length of time, there will be many files, so if you do a good job and are fast and accurate at this, then you will be awarded all data entry projects for the future.

Skills: Data Entry, Data Processing, Excel

See more: what is numeric data entry, we excel, n numbers, names and numbers, manufacturers products, job values, how to manufacturer a product, have a product need a manufacturer, convert number to words in excel, convert job, convert file to, black names, convert words numbers spreadsheet, convert words numbers, convert words numbers excel, what is word processing, excel split columns, csv spreadsheet, another word for data entry, manufacturer needs of a product

About the Employer:
( 41 reviews ) Staten Island, United States

Project ID: #599569

Awarded to:


Dear sir, I have extensive expertise on processing data on spread sheet. For details please check PM. Thanks.

$30 USD in 1 day
(108 Reviews)

6 freelancers are bidding on average $38 for this job


Hello Sir/Madam, *************** SPECIAL BID WAITING FOR START****************I have 45 workers in my own office with three Internet connections and 24x7 UPS and Gen-Set backup. My all workers have good experience in F More

$30 USD in 0 days
(148 Reviews)

Hi, Let's Start right away!

$30 USD in 0 days
(47 Reviews)

Ready to work with you. Thanks, Al

$80 USD in 1 day
(19 Reviews)

Please check the PMB.

$30 USD in 1 day
(0 Reviews)

I have wide expertize on it Excel as well as database desigening.I made Accounting Software. I hope i would support you properly,if you rely on me.

$30 USD in 0 days
(0 Reviews)