Find Jobs
Hire Freelancers

Need EXCEL expert for job task...

$10-30 USD

Completed
Posted over 7 years ago

$10-30 USD

Paid on delivery
Scope of work: I have two product CSV files each containing approx 16k rows of product URLs. I need someone to match as many products from CSV 1 and put them in a column beside all found matches form CSV2. There will be a lot that are not a match, this is ok. I just need as many as possible matched. Here is the actual task detail: THE TASK INSTRUCTIONS: Scope of work: 1) From CSV file (1) (named [login to view URL]) you need to find as many product URLs that match with CSV file (2) (named [login to view URL]) respectively. Once you have found matches you will place them in the destination CSV file (named [login to view URL]) The correct format to follow can be viewed in the sample destination CSV file. See sample CVS file (named [login to view URL]) for how the final should be formatted. Column A Example: Column (A) format needs all product rows to have these prefixes and suffixes added to each of them like this: /xcart/added as prefix and .HTML added as suffix. In Column (A) they will be formatted like this: Example: /xcart/[login to view URL] ---------- Column B Example: Column (B) format needs all product rows to remain as they are in their original CSV file (named [login to view URL]) The will appear like this: Example: [login to view URL] ---------- NOTE: When searching for matches.... 2) Product titles may be slightly different. If the search for a particular match proves not to come close it's ok to omit it and move on. If it appears to be the same product (just worded slightly different) you cna match it. Sometimes the CSV file (1) (named [login to view URL]) will have a listing like this: BIG-WARHEAD-SLEEVE-CLEAR-JELLY And the CSV file (2) (named [login to view URL]) will have it listed like this: BIG-WARHEAD-SLEEVE-CLEAR So typically the 1st 2 to 3 words in the "product title names" will show up in a EXCEL search. Can you do "relative match" instead of "Absolute match" when searching to find the matches?
Project ID: 11455265

About the project

9 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

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:
User Avatar
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
4.9 (286 reviews)
7.2
7.2
9 freelancers are bidding on average $33 USD for this job
User Avatar
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I have 100% client satisfaction ratio. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.
$30 USD in 1 day
4.9 (312 reviews)
7.8
7.8
User Avatar
<*>*<*>*<*> Hello Dear <*>*<*>*<*> I am interested to your job. For a detailed discussion please reply to private messages. If you want to know about my experience, then please visit my profile- https://www.freelancer.com/u/sajibdigital.html Thanks, Sajib
$30 USD in 1 day
5.0 (71 reviews)
5.7
5.7
User Avatar
Hello, I can do the task in less time, and 100% accurate - I have a long experience with MS-Excel (formulas & VBA macros). Also: - I'm an experienced software developer specialized in desktop applications, tools, and scripts. - I write programs using .NET since 2013, and using classic VB6 since 2007. - Have long experience with web scraping applications, socket communications, FTP connections, mathematics & formulas, applications that manipulate files & folders, and creating mini-tools that automate tasks while working in background. - Very good experience with multi-threaded applications. - Very good Experience with database based applications (MS-Access, SQL Server, and MySQL). - Accuracy and precision is one of my principles, also one of my best advantages. - Commitment to deliver tasks in time. I I'm looking forward to working with you, helping you to solve problems :) Please feel free to contact me to discuss any further details.
$40 USD in 1 day
5.0 (8 reviews)
4.3
4.3
User Avatar
Lets start work now.I assured you i will never let you down. Over the last 3 years, i have completed a wide range of data entry and typing projects. Most of these jobs were simply copy-pasting tasks for start up advertising companies. I have also published numerous articles for renowned article sites such as and wise geek.com.
$25 USD in 4 days
4.9 (5 reviews)
2.1
2.1
User Avatar
I have 15 years experience in Excel.
$30 USD in 1 day
5.0 (2 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Burbank, United States
4.9
20
Payment method verified
Member since Feb 11, 2003

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.