Combine Excel Spreadsheets to Create a Master Mailing List

Ukończone Opublikowano Nov 5, 2015 Płatność przy odbiorze
Ukończone Płatność przy odbiorze

I have a number of Excel spreadsheets containing client mailing data.

I need to combine and de-duplicate all of the entries to create a master mailing list for upload to a database.

There are around 30 different lists to combine with a total of about 15,000 entries.

However, the vast majority of these are duplicates and I estimate the master list will have a total of around 2,500 entries.

The information varies across the lists - some include only postal addresses while others have telephone numbers and email addresses. I want to combine all the available information for each unique contact.

Missing data does not need to be researched at this stage but I would like the final list to have columns for the contacts' full name as well as first name and surname separated. Much of this already exists but I'd like the gaps filled in.

Naturally, a high level of accuracy is required. I need to ensure that none of the contacts have been missed or duplicated and that all the information for the contacts has been aggregated into one entry for each.

Wprowadzanie danych Przetwarzanie danych Excel

Numer ID Projektu: #8844064

O projekcie

84 ofert Zdalny projekt Aktywny Nov 6, 2015

Przyznany użytkownikowi:

theresamcginley

This sounds like a great project for me. First I would organize each spreadsheet to contain the same headings in the same order, then I can easily merge them and sort by a specific column (e.g. surname). I will then Więcej

£250 GBP w ciągu 5 dni
(7 ocen)
5.2

84 freelancerów złożyło ofertę za £342 w tym projekcie

zExcel

A proposal has not yet been provided

£500 GBP w ciągu 4 dni
(255 Oceny)
7.6
P0L

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.

£350 GBP w ciągu 3 dni
(282 Oceny)
7.2
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

£250 GBP w ciągu 5 dni
(279 Oceny)
7.1
BithiXpert

Hello Dear, I can perfectly do it and interested for this project. Have an experience same and different types of projects. I am waiting to your quick positive reply. Feel free ask me question if any.

£250 GBP w ciągu 5 dni
(272 Oceny)
7.1
aarifakhtar

Hi: I have a quick question: Do you want to use the first name and surname to de-duplicate the records? Please also note that I have 100% completion rate and 5-star feedback on projects. More than 90% of my projects ar Więcej

£250 GBP w ciągu 4 dni
(167 Oceny)
7.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, databases, models and macros. Check my reviews. They speak for themselves. Best reg Więcej

£333 GBP w ciągu 1 dnia
(217 Oceny)
6.8
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr Więcej

£250 GBP w ciągu 9 dni
(174 Oceny)
7.0
zebracaro

I can do it for you quickly and exactly by VBA .

£250 GBP w ciągu 4 dni
(106 Oceny)
6.6
Beacon09

Hi I can combine and de-duplicate the 30 lists as described. I have great experience of achieving desired result for these tasks. Looking forward. Thanks. Regards Ahsan

£250 GBP w ciągu 3 dni
(87 Oceny)
6.7
danielgpratidya

Hi, Are those files have a same layout or same fields in the same columns? Eitherway, I can combine and aggregate those records accurately and fast with vba codes. Also filling in the fullname, first name and sure Więcej

£250 GBP w ciągu 3 dni
(193 Oceny)
6.6
imraz2016

A proposal has not yet been provided

£250 GBP w ciągu 10 dni
(167 Oceny)
6.3
pakee

EXCEL Expert and Experienced USER Here... Send me your all 30 different lists of excel and lets start.. I can combine them in one MASTER File... Consider its DONE with 100% ACCURACY and GUARANTEE.. Ready to START Im Więcej

£250 GBP w ciągu 9 dni
(191 Oceny)
6.6
raghav1101

Hi, I would love to work on this project. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros. Please contact with further details if interested. Regards R Więcej

£263 GBP w ciągu 4 dni
(99 Oceny)
6.6
fatimatuzzohura

I have versatile experiences about to do the online research, excel data analysis work. Please find below my overview: I am very much interested and have experience to do this work. Extensive Excel and pivot table de Więcej

£250 GBP w ciągu 10 dni
(155 Oceny)
6.4
sknadeem123

A proposal has not yet been provided

£555 GBP w ciągu 10 dni
(85 Oceny)
6.3
macroPOL

Hello, I am Excel and VBA expert. I can do the project (using macro) quickly and 100% accurately. Best regards Jan

£250 GBP w ciągu 2 dni
(90 Oceny)
5.9
manikhossain1111

Dear sir, I’m very interested in your job post involving these skills. I have good experience in data entry, excel, spreadsheet, data processing, data gathering, web research, web search, info collection, eCommerce si Więcej

£300 GBP w ciągu 10 dni
(55 Oceny)
6.0
expertatwork

hey there... please share all your 30 lists.. We can try to automate as much as possible so that highest accuracy would be ensured..please reply..we can complete everything in 48 hours..thank you..

£250 GBP w ciągu 2 dni
(152 Oceny)
5.8
Hassanmurtza

I have a strong and proven track record of doing DATA ANALYSIS, STATISTICAL ANALYSIS, SURVEY ANALYSIS AND FORECASTING FUTURE OUTCOMES IN FINANCIAL MARKETS. I have worked entire data analysis life cycle from requirement Więcej

£250 GBP w ciągu 10 dni
(21 Oceny)
4.9
adilsyed123

Expert here to do and complete this project professionally and quickly, I have done similar projects, I can do trial work before hire me sir , will wait for your reply, Thanks, Syed

£250 GBP w ciągu 8 dni
(37 Oceny)
4.8