Do some Excel Work

Completed Posted May 20, 2014 Paid on delivery
Completed Paid on delivery

Data cleaning required.

We have approximately 60,000 rows of UK business details.

Company name, address, etc in Excel.

We would like to combine duplicate entries, to produce a clean set of business contact details.

This will need to be manually reviewed, please see screenshot for an example of the kind of problems the data has, for example:

- postcode in wrong column

- the same business's names do not match exactly due to abbreviations

Some businesses may genuinely have more than one address and we need to preserve these in different rows.

So the end result should be a list of businesses with all existing data and columns preserved, but duplicate business details combined so that each row represents a unique business and location.

Data Entry Data Processing Excel

Project ID: #5965990

About the project

102 proposals Remote project Active May 22, 2014

Awarded to:

ankitsuhane95

Dear Employer, This project can only be done manually as Rows contents are little bit different but meaning is same Eg. Ser. and Services are same but meaning is same. We can do this job very fast. We have a team o More

$111 USD in 3 days
(1 Review)
2.2

102 freelancers are bidding on average $135 for this job

TypingxpertRehan

so basically you want to remove the duplicates and want a clean set of business details. i can do that for you. if you could provide me the file thank you

$250 USD in 2 days
(1556 Reviews)
9.3
hdlong66

Dear Sir/Madam. I can do it manually with accuracy. I thing we need start with sorting by phone number >> postal code >> name. I can start immediately and do it ASAP, only for your project if you consider my proposal. More

$250 USD in 10 days
(183 Reviews)
7.1
k00lcaptchrz

Hi, I have done alot of similar projects. I have team of expert persons. So i can get your task done quickly and with great accuracy. Refer to Pm so we can disucss .. Waiting for your positive resply soon. thanks More

$101 USD in 1 day
(139 Reviews)
6.6
DeepSyaal

Lets start. Having a team of Excel Professionals. We provide high quality work with accuracy. Would you like to discuss more about your project?

$50 USD in 2 days
(301 Reviews)
6.7
Anamika97

Hi, I can do this job efficiently. I have more than 10 years of experience in this filed. I am flexible about working time and money. I believe work speaks better than words. Hope to have a positive response. Good day, More

$194 USD in 4 days
(243 Reviews)
6.6
koolsidz

Hello :) I am an VB / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 then you will notice that I have not More

$111 USD in 2 days
(150 Reviews)
6.5
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

$189 USD in 1 day
(168 Reviews)
6.5
tmoi06

Respected Sir/Madam, It is my pleasure to be able to bid on your project. I have minutely gone through the details mentioned in your project description, and very much excited to be a part of your esteemed projec More

$250 USD in 25 days
(481 Reviews)
6.5
hudax

Hello, i'm student from Lithuania, studying at KAUNAS UNIVERSITY OF TECHNOLOGY -automatic controlling bachelor. Now i got a lot free time, so i can do this job as soon as you give me the information. I can work over ho More

$88 USD in 2 days
(21 Reviews)
5.7
dangersystem

Dear sir, I can do this work according to your requirements. i am able to handle this with my best care and creativity. I have done this type of Cleaning Spreadsheet data entry project previously.i assure you tha More

$100 USD in 5 days
(120 Reviews)
5.7
hemi

Hello Sir, I am an expert in data processing and data manipulation in various file formats like excel, CSV, text, xml etc that you can see in feedback I gained from earlier employers. I have been reviewed screen More

$200 USD in 4 days
(39 Reviews)
5.0
OutsourceMan

We will help you with: Do some Excel Work Hello, Greetings from "Hire WordPress and Design Experts". We have gone through the information provided by you. We would like to tell you that we have a right expertise i More

$30 USD in 1 day
(12 Reviews)
5.0
teeares

60, 000 is definitely a very large number. If I spend I min on each record, then the total time required will be 1000 hours. or at 10 hours of work per day, 100 days. I presume this database has already been checked by More

$555 USD in 50 days
(62 Reviews)
5.3
JovenR

Hi! I am interested to work in your project, I already saw the attached file I know an I can do it for you, please give me a chance to handle on it and I can start working on it immediately, looking forward to heard fr More

$40 USD in 2 days
(31 Reviews)
4.9
JonNxt

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have many years of experience working with macros and writing code / debugging excel VBA code. I can write More

$105 USD in 3 days
(37 Reviews)
5.0
shanthimv

Hi, I have good experience in data entry. I will give you the clean excel sheet with reliable information and wrong entries corrected. Looking forward to work with you. Thanks, Shanthi

$111 USD in 3 days
(12 Reviews)
4.6
dank111

Hi, My name is Dan. I am an expert in excel. I have recognized a pattern in your dataset and I can cleanse it with absolute accuracy by utilizing some advanced excel functionalities as well as manual review and audi More

$94 USD in 3 days
(10 Reviews)
4.3
jiashahood

Hello I am a student and a freelancer. I had done projects of excel, virtual assistance and data entry before as you can check my profile. I can provide you samples of my previous work. I hope you would like to work More

$100 USD in 3 days
(18 Reviews)
4.8
ElaineTeo

If hired by you I will deliver my best work at high standard. I look forward to being hired by you for your jobs.

$77 USD in 7 days
(43 Reviews)
4.6
shivamulumudi

hello employer, I can do this, Consider me and get it done perfectly as well as quickly. Please come for the discussion. Thank you.

$230 USD in 7 days
(6 Reviews)
3.5