Cancelled

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:
( 256 reviews ) NORTHAMPTON, United Kingdom

Project ID: #7237276

53 freelancers are bidding on average $27 for this job

Teloquence

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
(263 Reviews)
7.2
sy3d

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
(176 Reviews)
6.6
avinav606lx

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
(97 Reviews)
6.0
dpune

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
(54 Reviews)
5.7
nagybatonyi

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
(55 Reviews)
5.6
srinichal

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

$30 USD in 1 day
(17 Reviews)
5.3
shikhamehta

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
(52 Reviews)
5.2
cybersolutionvw

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
(41 Reviews)
5.2
P0L

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
(42 Reviews)
5.1
hdlong66

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
(53 Reviews)
5.1
quickprogexpert

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)
4.9
adityasl

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

$10 USD in 1 day
(65 Reviews)
4.7
Barns

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)
4.5
prameswara

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
(16 Reviews)
4.1
mjxone

A proposal has not yet been provided

$15 USD in 1 day
(11 Reviews)
3.6
pivn

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

$30 USD in 0 days
(3 Reviews)
3.5
prabakarm23

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
(19 Reviews)
3.5
jacobJordan

Hello. I'll create a program to parse this data. File + detailed guide please. After analyzing, I'll tell u my price.

$10 USD in 2 days
(11 Reviews)
3.3
TonmoyRoy111

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
(11 Reviews)
2.9
kajteksolutions

Hi, I can create a small app to manipulate your file. The app will go on each row, look for your specified keywords, and change the category_id accordingly. The category_id (if you don't have specifics yet) can be More

$30 USD in 2 days
(2 Reviews)
2.4