Find Jobs
Hire Freelancers

Data merging and cleaning of about 20,000 records from 8 different excel files

$30-250 USD

Closed
Posted almost 11 years ago

$30-250 USD

Paid on delivery
I have about 20,000 records of companies from 8-10 different sources in excel tables. The data has a number of different fields with some tables having more data than others. Most of the table have a minimum of :: BUSINESS NAME :: ADDRESS :: CITY, STATE, ZIP :: PHONE :: FAX :: EMAIL ::WEBSITE :: Contact Name :: SOURCE :: Additional Fields could include: Keyword (specific to source), Primary NAIC code, Rating (Yelp, Yellowpages, Houzz), Trade Associations, Project Size, Year Established, Category, License(s), Geographic area served, Map ID (URL) and others... I would like bids for the following data merging and cleaning deliverables: :: combine files into one master file encompassing all of the fields available across the files (save this file separately) :: merge any duplicate records, appending any additional fields so that each company record is complete :: remove any duplicate records that couldn't be merged to or appended to the other existing records (save this as a separate worksheet) :: sort by state and provide me with counts by state (please enter summary in separate worksheet) Accuracy, and attention to detail are key for this project. We are looking for someone with SQL or high level excel skills to complete this task using scripts or cleaning tools. After as much automated merging and cleaning as possible can be completed, please review a sample of the records manually to ensure accuracy. We will check final records for accuracy and to ensure that no companies have been deleted.... Looking forward to working with you. We will select a bidder early next week (May 6, 2013)and hope the project can be completed in a few days.
Project ID: 4484198

About the project

68 proposals
Remote project
Active 11 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
68 freelancers are bidding on average $119 USD for this job
User Avatar
Will create a sample application that will do it automatically and in the end you will have your clean and neat data and application as well so in future if you want to do it again you can do it yourself.
$220 USD in 5 days
4.8 (77 reviews)
7.3
7.3
User Avatar
Hello, i have expertise in data processing. I would like to see a sample of the files. Best Regards.
$262 USD in 5 days
5.0 (61 reviews)
6.9
6.9
User Avatar
I am interested in your project.
$100 USD in 3 days
5.0 (56 reviews)
6.1
6.1
User Avatar
Hi, I am expert in SQL and Excel both and complete this work easily. I am expert in this kind of work and already completed more than 195 projects. tks.
$110 USD in 3 days
4.9 (131 reviews)
6.4
6.4
User Avatar
Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards
$79 USD in 4 days
4.6 (61 reviews)
6.0
6.0
User Avatar
we do not offer package we offer Only guaranteed results..100% quality work within time limit and ...Read more in PMB
$144 USD in 3 days
4.4 (33 reviews)
6.0
6.0
User Avatar
Hi I have more than nine years experience Database Administration and Data migration. let me get a chance to do the job. I will ensure you best quality of work. thanks.
$90 USD in 3 days
4.9 (35 reviews)
5.0
5.0
User Avatar
I am interested in working on this project.
$198 USD in 3 days
5.0 (2 reviews)
4.9
4.9
User Avatar
I have experience in SQL. I can help you in this. Please check PMB.
$275 USD in 3 days
4.8 (22 reviews)
4.8
4.8
User Avatar
Greetings, We are good at excel , we got experience in doing such kind of projects, which can be verified with our feebacks. You can proivde us with the file to clean, we can start working on it thanks and regards
$84 USD in 3 days
4.7 (49 reviews)
5.1
5.1
User Avatar
Hi, easy task if done through programming, please let me know if you are interested in a program which will make this task, i can do it, thanks.
$82 USD in 3 days
5.0 (16 reviews)
4.7
4.7
User Avatar
i can do it
$30 USD in 7 days
5.0 (39 reviews)
4.8
4.8
User Avatar
Hi, Ready to start your work. Eagerly awaiting for your positive reply. Please check your inbox for further details. Thanks, Shaik.
$99 USD in 3 days
5.0 (31 reviews)
4.8
4.8
User Avatar
Dear Kyle, I can do this with high accuracy. I have done many similar jobs. Can provide a set of macros to process the data as you need. Best regards, Cuong NH
$99 USD in 10 days
4.8 (25 reviews)
5.0
5.0
User Avatar
Hi, Ready to start the project
$154 USD in 3 days
5.0 (23 reviews)
4.4
4.4
User Avatar
Kyle, I have completed similar assignments already, but I am sending you an 'interactive' graph that will let you judge my Excel skills in data manipulation for yourself. I will work under a Confidentiality and Non-Disclosure Agreement if you want, and will start as soon as you want next week. Based on your description I am confident you will have the 'blended' material back within 24 hours, More details on the Private Message Board. Bob Allen-Turl
$123 USD in 2 days
4.5 (11 reviews)
4.5
4.5
User Avatar
I have lots of experience with databases (SQL, MongoDB, SQL Server) and can start immediately for you.
$165 USD in 3 days
4.7 (5 reviews)
4.2
4.2
User Avatar
I can create standard or customized algorithms according the needs of the project.
$133 USD in 10 days
5.0 (7 reviews)
4.1
4.1
User Avatar
Hello sir I can do this project, Kindly check your Inbox for my resume. Thanks
$99 USD in 3 days
4.8 (11 reviews)
4.0
4.0
User Avatar
Sir, I can do this job
$34 USD in 7 days
4.9 (11 reviews)
3.8
3.8

About the client

Flag of CANADA
Vancouver, BC, Canada
5.0
34
Payment method verified
Member since Apr 11, 2013

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.