Find Jobs
Hire Freelancers

Excel Expert to Compile List of Email Addresses from Hidden Characters

$30-250 USD

Completed
Posted over 4 years ago

$30-250 USD

Paid on delivery
I have a list of 10K rows of data, that has Email Addresses in one of the column, but those Emails are hidden by ****... Example, one of the cell has following information: "Employees Employee Seniority level Email address Phone number Social Durrah Hamdan Associate Director - AI and Predictive Solutions Lead - d*****@[login to view URL] - Kamraj Subramanian Associate Director Director k*****@[login to view URL] - Yang Zhengzhi Data Scientist - zhe*****@[login to view URL] - Nina Alag Suri Founder and CEO CXO nina*****@[login to view URL] - " Your job is to split out those columns & replace those *** with given name... U may need to calculate how many characters with those *** then replace with the name as per given, certain * could mean . or -, these are common separator in email addresses. So, the use of intelligent formula is important to "guess" the right email. In the end, we need 1 row of data with Company, Name, Job Title, Email Address... If there are 5 email addresses from same company, it shd have 5 rows of data with 5 different emails (and name & job title) but with same company name. Although this could be done manually, but remember there are 10K rows, it might mean there could possibly 50K emails to be "guessed"... So Excel expert could do this quicker.
Project ID: 20894428

About the project

52 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, I can help to compile list of email addresses from hidden characters. I’m willing to give a sample for your review and comment. Please drop a PM if you’re interested. Best regards, Hoang
$50 USD in 4 days
5.0 (191 reviews)
7.2
7.2
52 freelancers are bidding on average $175 USD for this job
User Avatar
Dear Employer, I understand your job and I will get all your 50K email ids rectified through Excel automation. I am an expert with over 12 years of experience and will do a perfect job asap. Please do check my previous reviews once for your kind consideration!! :) Thanks and Regards, Ash
$250 USD in 7 days
5.0 (336 reviews)
8.5
8.5
User Avatar
Hello Sir Im excel expert (VBA macro and formula expert) i can do identify ** in your email by your given name quickly Sir i will have a better way todo that via VBA script or formula please ping me now to make sure all and im able to start working right now after all clear :) Thank you Galih
$70 USD in 2 days
4.9 (438 reviews)
7.6
7.6
User Avatar
Hello Sir, Ready to start now. I do have a team of 10 experts who can join with us in this project. I will make sure to replace the *** with given name into a well organized excel spreadsheet as per your requirements and within your targeted time. If needed I will also perform accurate web research to fill rest of the data. I am a professional web researcher and data entry expert. I’ve been working on research, data entry and lead generation projects for the past 4 years, having good skills and knowledge. I will make sure to deliver 100% accurate results without any error. I will be available all the time for quick updates and followups. Please share more information so I can perform a sample data entry for accuracy check. Looking forward to your quick positive response and build up long term relationship. Kind Regards Sarita P
$30 USD in 1 day
4.9 (293 reviews)
7.5
7.5
User Avatar
Dear Sir, Hope you are doing well. Sir I am very much interested to work on this project and I ensure my fullest dedication and effort in order to accomplish the 1st 500 emails before you award me the whole project. I ensure you quality work within given timeline and hope that you would appreciate my first work and we will work together further. I am eagerly waiting for your response, Sir. Thanks and Regards Nafis Imtiaz Bhuiyan.
$200 USD in 7 days
5.0 (21 reviews)
7.5
7.5
User Avatar
Hello there, I can guess this quickly. Had done similer work. I will use a shortcut for this. I had gone through your requirements and i can start now followed your instructions. I am very flexible in web research, data processing, web scrapping and research related everything. I can assure you that I will be able to assist you in your task with quality work. Allow me to start sampling. Please let me know further details. Waiting for your reply. Relevant skills and Experience- Data processing, Web Scrapping, Data Entry, Web research, Copy Typing, PDF Conversion, Extracting email, Ms office(all)... If you agreed my bid please give me a chance.
$60 USD in 2 days
4.9 (291 reviews)
7.0
7.0
User Avatar
I have understand all. message me. i can start new. thanks. ..............................................................
$500 USD in 10 days
4.9 (89 reviews)
6.9
6.9
User Avatar
Hi, I have the script which can do this job. That will also ensure better accuracy than a manual effort. If you can ping me the file, I can show you a demo/ sample and then we can take it ahead. Thank you!
$30 USD in 2 days
5.0 (33 reviews)
6.9
6.9
User Avatar
Hi, I have a team. I can handle this manually. This is not possible by program. Send me sample file. Waiting for your reply. Thanks
$2,222 USD in 15 days
4.9 (164 reviews)
7.2
7.2
User Avatar
Hi, I have read very carefully your project details about creating intelligent formula that will guess and compile email addresses from hidden characters. I am absolutely sure that I can complete this project professionally. I can tell you about how highly experienced and multi-talented I am. But I’m sure you need more than that. In less than 24 hrs, I can complete a sample of the job before you award the project so you can be sure you’ve entrusted your job in the best hands. No commitments required! I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time.
$150 USD in 7 days
4.9 (73 reviews)
7.0
7.0
User Avatar
Hi sir, I came to an idea how to get the right emails. I will write formula based on first and last name columns in combination with emails column. I will first split the emails into separate columns then first and second names. I have 5 years experience with excel DELIMATIONS, FORMULA, MACRO, replacements etc and I can get accurate results in minutes time.
$190 USD in 2 days
4.8 (246 reviews)
7.4
7.4
User Avatar
Hi. I can find business emails from name of employees in a company. Great app writer for your projects. I have writen scraping, excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
$100 USD in 7 days
5.0 (216 reviews)
6.6
6.6
User Avatar
Hello, I am an excel expert and I can create the required automation for replacing the *** with names. Please share your project files over chat and we can discuss on how to proceed. BR, Razvan
$200 USD in 3 days
5.0 (21 reviews)
6.1
6.1
User Avatar
HI, I am expert in MS excel . I did similar job already. so I am a best candidate for this project. I utilize your full requirements and I have 5 members of team to do this manually. even 50 also possible. so relax. if you agree I will make sample first. hope to hear back from you soon cheers
$250 USD in 15 days
4.8 (74 reviews)
6.0
6.0
User Avatar
Hello, I have read the project description and understood it. I don't think it can be done through any formula or something. It is a whole manual work. I can begin working on it with my team as soon as you hire me. I can find the correct email address and also once I am done, I can also verify the emails so that your email campaign has the minimum bounce rate and maximum efficiency. I focus mainly on the quality of work. I assure the employer's satisfaction. Thus, I am one of the highest repeat hire-rate freelancers of my niche which you can check in my profile. Initiate the chat to discuss the budget and timeline of the project. Looking forward to working with you. Best Regards, Kuldeep Gera
$100 USD in 7 days
5.0 (73 reviews)
5.9
5.9
User Avatar
Sir,      I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards
$194 USD in 3 days
4.7 (112 reviews)
6.3
6.3
User Avatar
Hi there, I am really interested in your project and would like to work on and complete your project. Python is a perfect solution for it; I have done so much data processing with Python. I will create the script and will feed your excel file and send you the resulted excel file. There is no need for manual work if Python is there to help. Your task will be completed so quickly and without any mistake. Just call me out. Your project will be completed within a day; but I scare of employer late replies can end my deadline. Can you trust and leave your project to me? See my portfolio in desktop computer/view please. I shall be very thankful to you, Ishaq
$100 USD in 4 days
5.0 (30 reviews)
5.0
5.0
User Avatar
Hi Good Day! A serious freelancer here. I want to help you with this. Can you share to me your file? I will check if I can create a formula or codes to do it quickly. Please consider my bid. I've done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. Message me anytime to discuss. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$50 USD in 2 days
4.7 (78 reviews)
5.4
5.4
User Avatar
Dear, employer. My name is Lee, I am an experienced web developer, and web scraping expert. I have good experiences in web scraping using PHP, Python, Java and so on. I read your job description, and I am interested in your project. And I think it is not matter to perform your project, and I can satisfy you by completing your project with high quality in deadline. If you want, I can show you my projects that I had made before, and I can make demo for you. As a dedicated full stack developer, I am always available for daily communication and ready for your full response. I am free now, I can start to work in your project immediately. I would love to have an opportunity to discuss with you for further details. Skill: Python, spider, scrapy, selenium, beautifulsoup, mechanize, requests, lxml, urllib2 Best regards.
$140 USD in 7 days
5.0 (5 reviews)
4.7
4.7
User Avatar
Hi, I am writing this after reviewed your project description. I am interested in your project and Kindly drop a message so we can discuss. 3+ years experience of following types of Work: 1. Lead list development, as per requirement. 2. Data Extraction/Web Scraping/Data Mining - I have Scrapped number of association, bar sites. 3. Email appending of company Executives - I append emails, test them & upload only valid emails to client. 4. Excel/Word Expert - Sound knowledge of excel word, Formatting of data, cleansing of data. 5. Email Testing - Test emails for valid & invalid emails. 6. Data Entry online or offline 7. Email/Mailing List Development 8. Addition of products on portal on websites like (Amazon, Ebay, Walmart, Newegg, Shopify) 9. Website & Email searching of Companies. 10. Yellow / White Pages Data Entry/Scraping Request you to kindly consider my proposal and give the opportunity to serve you in this project. Looking forward to hearing from you.
$150 USD in 7 days
5.0 (19 reviews)
4.9
4.9
User Avatar
Hello Sir, I have 2 years of experience working with Python and I can create a script that does the job that you described. Script will complete this work much much faster than any manual work, plus at the end you will have the script that you can run in the future. If you can send me your spreadsheet I will be happy to send you example output before you make your decision on whether to hire me. Have a nice day and hopefully hearing from you soon.
$30 USD in 1 day
5.0 (12 reviews)
4.3
4.3

About the client

Flag of MALAYSIA
Petaling Jaya, Malaysia
4.7
10
Payment method verified
Member since Dec 19, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.