Convert large xlsx file to csv and clean data

Closed Posted Mar 4, 2016 Paid on delivery
Closed Paid on delivery

I need this file converting from xlsx to csv (comma separated value):

[login to view URL]

In addition, I need a copy of the csv with the following processing:

1. Delete all rows where "PW_UNIT_OF_PAY" is not equal to "Yearly (YR)"

2. Delete all rows where "WAGE_UNIT_OF_PAY" is not equal to "Year".

3. Delete all columns apart from EMPLOYER_NAME, JOB_TITLE, and WAGE_RATE_OF_PAY_FROM

Deliverables (2 files):

1. Direct conversion of xlsx to csv file

2. Cleaned up version of csv according to above instructions.

Data Entry Excel

Project ID: #9838852

About the project

50 proposals Remote project Active Apr 10, 2016

50 freelancers are bidding on average $24 for this job

mehedi276

"Rate and duration will be fixed on discussion" Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed se More

$30 USD in 1 day
(447 Reviews)
7.4
bytessolution

Greetings. I specialize in provide solutions for Business Administration, Data Base management, Key Performance Indicators design, Supply Chain Planning and Project Management for commercial and industrial companies. More

$25 USD in 0 days
(195 Reviews)
7.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More

$40 USD in 2 days
(234 Reviews)
6.9
cugamelover

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. I could send you samples of my work if you wish. Please More

$25 USD in 1 day
(173 Reviews)
7.1
royalcalif

Hi Mr. Employer I can do this project in effective manner with 100% accuracy report to fulfill your requirements. I will deliver the spreadsheet in time. I can start immediately. Pm me for more information and sample More

$25 USD in 1 day
(77 Reviews)
5.8
Rajni0802

I can do this task of converting xlsx file to csv and cleaning data as per your requirement. Let's discuss further. I have skills in Web-research tasks and collecting information through Google searches and other va More

$30 USD in 1 day
(102 Reviews)
6.1
archanaoswal

I have excellent command on MS Excel. I have completed complex projects in Excel before as seen in my portfolio. (like - built a reservation system in Excel that involved formulas and Macros to consolidate data from va More

$25 USD in 1 day
(80 Reviews)
5.8
sumon355

Hello, I am very much interested to do this work. I can do it very fast using my self developed application. Looking forward to have a positive response from you. Note: May i know the size of the excel plz? alread More

$22 USD in 1 day
(30 Reviews)
5.1
ItsAwais

i c an do this.................................................................................................................................

$30 USD in 1 day
(16 Reviews)
3.8
vroux

Greetings. I am an engineer and I can take care of your job right now. I am an expert with excel, and can complete the task in the next 30 minutes.

$30 USD in 0 days
(6 Reviews)
3.4
isacbogdan

Hello, I am Bogdan and I have extensive knowledge of Excel and data processing as I worked as a statistician for a multinational company for 4 years. I can help you solve the issue quickly. A little bit more abo More

$10 USD in 1 day
(4 Reviews)
3.2
chetanghadiya007

Hi, I am Chetan Ghadiya from Rajkot,Gujarat,India. we are team of developers and designers. Completely passionate and self dependent. I believe in delivery with a quality. We are a team of developers and designers More

$25 USD in 1 day
(3 Reviews)
1.6
safdarahmad2010

Hi Sir, I have good skills of Excel and Conversion software. I will complete your required task as you demanded. I have 2 years experience of Data Entry in a advertise company. My Education , Experience and skills me More

$10 USD in 2 days
(2 Reviews)
1.8
kienngd

Dear sir, please contact me. We will discuss about your requirements. When I understand, I'll do it for you.

$35 USD in 1 day
(1 Review)
1.6
ochebro

Hello there i read your project carefully and i understand what you relay want. i can do it today and give you clear data(2 files) on time . please do contact me ASAP.

$14 USD in 1 day
(0 Reviews)
0.0
abchotice

Hi, I'm a former IT professional with more than 5 years of experience. I am hard working, loyal , enthusiastic and produce high quality work. I am proficient in MS Word, Excel, Data Entry and research. My professiona More

$20 USD in 1 day
(0 Reviews)
0.0
khadarvallisik

I will make a csv from the excel sheet which you have given in the description without any mistake. Please Give me a chance to prove myself.

$25 USD in 2 days
(0 Reviews)
0.0
agarwalsuhani89

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
Deeep43

i have knowledge in data entry and how to manage the database in excel and also know about sql loder , cvs file loder in oracle. i have one team and this team only work on the data entry. i work on oracle SQL/PLSQL q More

$30 USD in 1 day
(0 Reviews)
0.0
ladooscurodelsol

Hi, please find my experience below: He has six years of experience working in Business Intelligence, Data Warehouse, and recently Big Data technologies. Business Intelligence Specialist. Data modeler. Business Int More

$25 USD in 1 day
(0 Reviews)
0.0