In Progress

Data merge- Excel/DataProcessing

The project is to merge datasets. I have a master dataset of 5138 entities. This data includes business name, business address, longitude/latitude, etc. This is in text (tab delimited) format. Then, I have 51 files of 50-150 entries each that contain business name, address, longitude/latitude. These 51 files merged into one long file. I want the entity identifier from the master data set matched onto the entries on the second dataset. The names and addresses will match but not always textually exactly. (For example, the address in one might say 5158 S Windsor Dr and the address in the other might say 5158 South Windsor Dr).

Please specify how you would do this. By hand is one possibility, but you must have facility with US address/language conventions.

Skills: Data Processing, Excel

See more: data processing business, how to master excel, business entities, master excel, merge data, master data, longitude, latitude, format excel, excel us, data merge, data longitude, tab delimited text, tab delimited format, merge excel project, delimited data, match merge excel, file entity, file name excel, merged, address excel format, data entity, excel data set merge, name data processing business, names data processing business

About the Employer:
( 30 reviews ) New Haven, United States

Project ID: #1256940

Awarded to:

greggfletcher

Hello, i am an expert at data mining and consolidation. Please refer to your PMB. Regards.

$250 USD in 1 day
(39 Reviews)
6.4

21 freelancers are bidding on average $256 for this job

diamond247

Hello, Business database expert. Let's speak in PM. Thanks

$250 USD in 3 days
(81 Reviews)
6.5
pishty

I am interested on your project. I left you a message for more details.

$250 USD in 3 days
(49 Reviews)
6.0
binaryromel

##### Excel expert here! Please check PM. #####

$250 USD in 1 day
(68 Reviews)
5.7
nagybatonyi

Most items can be matched by a series of refined matching formulas gradually decreasing the number of unmatched entries which shall be matched ba a final visual check. If you send me some sample files I'll do a pilot s More

$250 USD in 2 days
(53 Reviews)
5.7
vbexcel

Excel/VBA expert - ten years experience.

$250 USD in 2 days
(28 Reviews)
5.5
dataconsultants

Please check PMB for details, Thank you

$270 USD in 3 days
(71 Reviews)
5.4
MDavidCrompton

Hi, This is not a problem I have done several such projects. Check my feedback and a reference in private message. I would set up multiple match criteria and then ultimately visual check. The result would be spot on. More

$300 USD in 4 days
(26 Reviews)
5.0
psprongs

Hi, I have a good deal of experience in excel data processing. I can help with merging of the datasets and can start immediately. Please check PMB psprongs

$250 USD in 1 day
(10 Reviews)
4.5
abbie3290

Please check your PMB.

$250 USD in 5 days
(20 Reviews)
4.5
jkumarsanson

Please refer my inbox

$250 USD in 2 days
(10 Reviews)
3.4
Uthe2009

Hello, I'm available to work on your data conversion task. Thank you.

$250 USD in 5 days
(7 Reviews)
3.1
prabhabusiness

Hi, Please check PMB

$250 USD in 3 days
(1 Review)
1.0
cristinacazacu

I can do that. I work in Excel.

$250 USD in 2 days
(0 Reviews)
0.0
BioDramaticGurl

Hello I'm so interested in this job and I've taken my ICDL with a very good knowledge of EXCEL , for more informations I've sent my CV in PM Thank you and hope to hear from you soon !

$300 USD in 5 days
(0 Reviews)
0.0
feathersky

I can use C# to finish this task. I have finished some code that can deal with CSV file and calculate the similarity of two string.

$250 USD in 1 day
(0 Reviews)
0.0
jennibrite

Hello, I am new to freelancer, but this is a task I can do quickly and without error. I have expert level excel skills and a lot of experience with large sets of data. I will be following up with a personal message More

$250 USD in 2 days
(0 Reviews)
0.0
waheeduddin

Sir, i am ready to work on your project.

$250 USD in 1 day
(0 Reviews)
0.0
raviprakash10

i am excel certified. I would be happy to talk more about the requirements and my approach. thanks

$250 USD in 2 days
(0 Reviews)
0.0
Arctechno

Dear Sir, We can very well understand your requirement and will be happy to get started with the work. Please Send your File. I am ready to start this work immediately. Please Try us once & you will be HAPPY that you h More

$250 USD in 2 days
(0 Reviews)
0.0
dangerald

i'm willing to do the job and deliver the goods ahead of time

$250 USD in 1 day
(0 Reviews)
0.0