Closed

I have a list of companies in excel sheet that I've generated from an online tool. This list contains the company name. I work in sales. I'd like to be able to quickly search the email address of all the companies in this list without having to manually

I need you to develop some software for me. I would like this software to be developed for Windows.

I have a list of companies in excel sheet that I've generated from an online tool. This list contains the company name. I work in sales. I'd like to be able to quickly search the email address of all the companies in this list without having to manually google search for each company every time.

The first solution that I have been unable to find is a website or tool that will allow me to copy/paste my excel workbook/sheet into it and then have the searches automatically done.

The backup plan is to create an automated scraping tool. As far as I understand, this process will take two general steps:

1) Create a search macro or other system to pull data from a cell into a search tool or replace the search text in an existing Google Search Results URL. This will redirect the search results to a page that is unique to that set of search results which I need for step 2.

2) Scrape the hyperlink from the unique search results list to the excel spreadsheet.

3) Using the hyperlink cell from step 2, perform a second scrape, or skip step 2 and do this directly, this time, gather the coded mailing address for each company (or other similar company information easily found from googling the business), and export that information into another cell (in a new column again) for that individual company.

Beyond Step 3, I can manually manipulate the data or do what I need to make this work for me. Is there someone who can show me a solution that will solve this problem?

Skills: Software Architecture, Windows Desktop

See more: email search bot freelancer, extract email address email outlook vba, myspace email search, excel download, excel tips and tricks 2019, microsoft excel tutorial, excel formulas, how to use excel formulas, excel vba templates free download, excel online, vlookup, address radius search sql, free address email database individual, css contact name address email, address book search ajax, germany austria email search site, scrape address email website 2nd page, capture address email webpage, soccer clubs contact address email address, pakistani address email address

About the Employer:
( 0 reviews ) Mumbai, India

Project ID: #25839140

2 freelancers are bidding on average ₹11806 for this job

beanlle

Hello, I am a professional web scraper and have great experience in grabbing data from web pages. I am very interested in this project and would like to learn more details about this it. Looking forward to hearing from More

₹12500 INR in 7 days
(2 Reviews)
2.1
krishrajan44

I can do it for you very easily. Please visit my profile to know my technical abilities. I just delivered one high priority and big budget item for a client and made good reputation I m in Noida we can connect an More

₹11111 INR in 2 days
(0 Reviews)
0.0