Transfer Data in Excel & collect contact info online.

I have two excel files that has a list of pest control operators that have used pesticides in a county for a 2 month period. I would like that data of user information to be transferred into a clearer format like first name, last name, address etc. I also would like to further find the email address and contact info of that company online. There is also a site to look up the pest control licensing information to obtain both the operators & company's license numbers. I wanted to exclude the contact information of the Agriculture companies.
Additionally, I would like all of the chemical information sorted to see what type and the quantity has been used by everyone which should be fairly straightforward for an Excel wizard. All data needs to be in lower case which can be time consuming. I do not have the bandwidth to get this accomplished.

Thanks! Jim