Combine Excel Spreadsheets to Create a Master Mailing List
£250-750 GBP
Paid on delivery
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.
Project ID: #8844064
About the project
Awarded to:
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 More
84 freelancers are bidding on average £342 for this job
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.
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
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.
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 More
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 More
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
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 More
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 More
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 More
Hello, I am Excel and VBA expert. I can do the project (using macro) quickly and 100% accurately. Best regards Jan
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 More
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..
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 More
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