Data Processing of CSV File

I have a csv file containing 18,261 products. I need somebody experienced with Excel that can create rules to look for certain keywords in the data, and then change the value of a category_id cell. I think this can be done using IF statements, but you may know of other methods.

At the moment, all the products in the file have the same category_id. The aim is to find all products for women and give them a new category_id, and then do the same for products for men.

Skills: Data Processing, Excel

See more: processing of data, excel data processing, csv file, create excel csv file, processing csv, excel change csv, data processing need, utopiagrange, processing csv data, data processing rules, text file xml processing vba, mobile data transfer methods, ksh csv processing, data entry bank statements, data validation methods market research, csv file excel, create csv file excel, can create file, excel chart provide csv data, create vba project iports data csv, dhtml csv processing, find excel data using

About the Employer:
( 257 reviews ) NORTHAMPTON, United Kingdom

Project ID: #7237276

52 freelancers are bidding on average $27 for this job


Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$50 USD in 0 days
(326 Reviews)

Hi hru remember me? Is there any need of if formula? We also can use advance option of filter key Send me file along with detail, I can complete it on urgent basis Let's talk now and I show you demo work More

$35 USD in 1 day
(288 Reviews)

Hello! I'm an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 USD in 1 day
(225 Reviews)

Hello Sir, Im excel VBA expert, please give me your job and im able to start doing your job right now Thank You Sincerely Prameswara

$30 USD in 0 days
(310 Reviews)

Hello. I am good at excel and able to complete this task. Let's talk about rule how to define product for men/women. Thank you and Best regards, Hoang

$50 USD in 1 day
(112 Reviews)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 225 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive More

$30 USD in 2 days
(124 Reviews)

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou More

$29 USD in 0 days
(142 Reviews)

Hey, I can assure you of quality work like I have been doing for past 6+ years as you would see my work history. I have been highly rated and recommended for solutions I provide. Please let me know if you would l More

$35 USD in 1 day
(93 Reviews)

Dear Sir I can accomplish the job for you within the time specified. Kindly contact me for further details. Thanks Tonmoy Roy

$25 USD in 1 day
(231 Reviews)

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contain More

$25 USD in 2 days
(62 Reviews)

Hello, I am excel expert. Please check my reviews. Looking forward for the reply. Regards, Aditya

$10 USD in 1 day
(119 Reviews)

Hi, I am ready to do this for you as per according to your requirements. I have lots of experience in doing such kind of projects. You can check my profile for my work experience. Please send me file for review. Tha More

$30 USD in 1 day
(55 Reviews)

I am an expert in macro and custom scripts willing to discuss further about the project specifications.

$30 USD in 1 day
(24 Reviews)

Hello, I can write a Perl script to handle this. I will get back in less than 3 days. Thanks, Shweta

$30 USD in 1 day
(20 Reviews)

Hello. I can do this job. Please, contact me to discuss datails. P.S. I'm beginner ir [login to view URL], not in Excel and VBA :-)

$15 USD in 1 day
(18 Reviews)

Hello, I have seen your project and offering my services for this work. I can start this task with immediately and can complete it within defined timelines. Completing the job with 100% accuracy and with punctua More

$20 USD in 1 day
(24 Reviews)

I have to do something similar periodically for a regular client of mine who sells 40,000 plus pneumatic components etc online. I can do it in VBA in Excel. The file will be processed in Excel as a spreadsheet and the More

$30 USD in 1 day
(20 Reviews)

A proposal has not yet been provided

$15 USD in 1 day
(17 Reviews)

Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv More

$30 USD in 2 days
(46 Reviews)

let expert do this....................................................................................................

$30 USD in 0 days
(3 Reviews)