Do some Excel Work for product feed file

$30-250 USD

Completed

Posted

over 9 years ago

$30-250 USD

Paid on delivery

Need to format an excel spreadsheet (CSV) and remove extra data from Image URL column. Example: Right now the column is like this: Product Image File: [login to view URL], Product Image URL: [login to view URL] Need to make it like this: [login to view URL] File also has blank rows that need to be deleted. Also need to make CSV file formable in txt format. See below: File Format  We support only delimited text files. Excel files are not supported.  Acceptable delimiters: Tab, Pipe, Tilde, or Comma. Field values can be enclosed in quotes  Files can be zipped  Character encoding accepted: ASCII, Latin-1 (ISO-8859-1), Latin-9 (ISO-8859-15), UTF-8, UTF-16BE, UTF-16LE, Windows-1252. If no character encoding specified, we will assume Latin-9.  File must have a header row and use the exact field names as listed below. Capitalization, space/underscore/dash differences will be normalized  We do not have the ability to custom map column names at this time.  Each line must contain the same number of delimiters.  We will accept Google product feeds Please example of file that i need to format in attached section. Need this done as soon as possible. Thanks

Data Entry

Data Processing

Excel

Project ID: 6245876

About the project

13 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@ranawaqarlx

I can do all spreadsheet as in job descriptions.. I can show you some sample work too from attached file. Thank you

$35 USD in 1 day

4.9

(7 reviews)

4.0

13 freelancers are bidding on average $62 USD for this job

@sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this regard. with thanks and regards

$98 USD in 5 days

4.6

(84 reviews)

6.1

@bouslimi1979

Dear, I ll code a VBA macro to add the www. to the URL column, delete empty rows,.. And check all the other criteria so you will get a clean txt file, delimited which you can upload. Let me start now and finish in 1-2 hours. Thanks

$35 USD in 3 days

4.8

(62 reviews)

5.8

@Usmanwaheed

My profile has many excel projects with excellent reviews. i can do this project for you at most affordable rates and in minimum time as I have advanced level in excel. Please discuss.

$40 USD in 3 days

5.0

(4 reviews)

4.1

@prstben

I've replaced all the product URLs. I'm not sure what you mean by the other part though, so my bid is only for the product URLs.

$30 USD in 3 days

5.0

(15 reviews)

3.6

@karanamsrikanth

Dear Employer, I am a experienced freelancer in excel. As per the specification, I have modified the product image URL, removed blank rows and made it into a text file. Kindly message me to discuss further. Thank you.

$30 USD in 1 day

5.0

(9 reviews)

2.7

@nikolajob

I type very fast, have a lot of experience in MS OFFICE package programs, expecialy WORD and EXEL I finish high ICT school, type very precisely and accurate without mistakes. Hire me and you will see, You will not regret. You can see some of my works in portfolio. My typing skills is on high level, i type 50wpm. Hope you answer. Best regards. Nikolajob

$66 USD in 2 days

0.0

(0 reviews)

0.0

@vladicbiliuc

Hello I would like to help you out with this project I have a lot of experience when it comes to using excel and can do easily the job you described apart from the facts about making it txt. I am pretty sure I can do it but I need details. Contact for any questions Thank you

$100 USD in 2 days

0.0

(0 reviews)

0.0

@parama4u

I have a macro to make the csv file autoformat and do your requirements automatically. Get the result within 10 hours frp, acceptance of project

$100 USD in 1 day

0.0

(0 reviews)

0.0

@GegaByte

Hi, We read your requirements and are able to provide you with a script which will do the function for and provide you a CSV format file.

$73 USD in 3 days

0.0

(0 reviews)

0.0

@jhamanoj

I have been working for 15 years in data processing field. I am committed to provide all types of converting, processing or typing jobs with required accuracy and with time limit. We are providing 24 hours availability. Our team is dedicated and responsible.

$88 USD in 3 days

0.0

(0 reviews)

0.0

@salimmurshed10

sir, i m an employer of a company really based on excel.................. so i can help you on this project ................................. details pm

$50 USD in 3 days

0.0

(0 reviews)

0.0

@eDataProofer

Hi, I have partially worked on the file that you attached. Blank rows have been deleted up to row1114. The first 30-40 records with the URL have also been corrected. I will send you the file (csv) in a private message. I look forward to working with you.

$66 USD in 3 days