Consolidate email list & find city & country for the full email list
$50-100 USD
Paid on delivery
We have 2 email lists - one is 43,000 contacts & is a subset of a larger list of 65,000 contacts. The 43,000 contacts list has only 2 columns - name & email id, where as the 65,000 contacts list has more details like name, email id, phone number, address, city, country, business website, & business name.
As a first step we want you to add the other details from the 65,000 list to the 43,000 list like phone number, address, city, country, business website, & business name. You can do this using excel vlookup or INDEX formulas or anything else. This 43,000 list after adding the above details will become an "Updated 43,000 List".
The second step is to get the country & City column filled for the "Updated 43,000 contacts list". You can do this by pinging the email servers or by any other means to figure out the email addresses' City & Country. Kindly note that there are contacts that already have this data available, we want it for all contacts in the list.
Kindly note that the final output has to be the 43,000 contacts list which has the details from the 65,000 list & also has the city & country for all the email contacts.
Do let me know if you have any questions & use the words "sort" at the beginning of the proposal so that I know you have read the full description.
Kindly give a proposal with details of the time you will need to finish this work.
Time is of the essence here, we are looking for a quick turnaround for this project & then we can look at on-going work on other projects, if the performance on this project is good & there is a fit.
Kindly ignore the budget range for the project - its there by mistake.
Kindly include your actual fee / bid in the cover letter it self please.
Project ID: #10718729
About the project
46 freelancers are bidding on average $1202 for this job
SORT. Hello, I can do this matching and I can detect location by pinging email domain and cross-referencing it's ip with ip2locations database and/or check domain's WHOIS records (at additional fee)
Sort. Hello, We have more than 5 years of experience. Our team is capable enough to do both the steps for you. I eould like to see the file or sample email addresses and provide you a free sample work just to ensure th More
Hello there, We have reviewed the requirements thoroughly and have understood the requirements. The first part of the job can be accomplished swiftly using Vloop/Index function and we fetch address,phone, city,co More
Sort Hello, I have read and understood the project description. I can complete both the task in 15 days. It will be good if you could provide us sample data for review Regards, Swapnil
"SORT" Once the 65,000 contacts is cleared with City & Country, the second step is quite easy to extract the 43,000 contacts fully updated. Our price is $2000. We can complete this task in 10 days maximum. We More
sort Hi! I can get the details from other file using Index(Match) and I feel that the major part is to get the city and country of the email addresses. Right ?
"sort" Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
sort Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. B More
Hello I am highly interested to do your project.I believe, I can do this work properly by your instruction. We can again discusss about the budget. Always try my best to give you a best work. Moreover, I have More
Hi I have a team of 7 members, expert in web scraping & excel work. I understand the requirements of your project and I can assure you of completion with desired quality of work. I have good skills and experience in ♦ More
"sort" Hello, I read your requirements very-well and ready to start work from now. Hope you will give me a chance to do work with you, waiting for your reply, Thank you
Hello sir, "sort" I read your full project completely and understand what you exactly need for this project. I want to introduce myself as a expert of expert of lead generation, web scraping, data mining, web rese More
Hello, good day. My name is Mae and I can do this job for you within 1 month. I'll make sure to complete all the required information and that they were all correct and accurate. I'll work hard and fast to finish it More
Hello We believe in quality work that meet the clients Expectations and satisfied the clients. Please have a look at the Feedback/Rating that we have got, which proves we are the best candidates for your project. We More