Find Jobs
Hire Freelancers

Automated excel macro capturing data from website

$30-250 USD

Completed
Posted about 10 years ago

$30-250 USD

Paid on delivery
I am doing a project where I need to input into excel a listing of all tradespeople and their license information. I am looking for an automated macro that I can use to grab column data from a web page. I would like to manually select the type of license I am looking for and search the state database based on zip code. I want an automated macro that will take zip codes that I have on a spreadsheet and run the search. From the results page I need the macro to capture all data in the respective columns and put it into excel. Once the macro is finished capturing all the data that is returned, it needs to go back to the previous page and replace the zip code with the next one on the list and conduct the next search and data capture. The website and input fields are located at [login to view URL] As an example, once you are on the page, select ELECTRICIANS from the drop down menu of license type and input 02494 into the zip code field and press search to see the results. This automated macro needs to be simple to use and function as I do not have experience using them.
Project ID: 5408075

About the project

18 proposals
Remote project
Active 10 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, What column data would you like to scrape ? I am an expert in web scraping (ranked #1 for Web Scraping https://www.freelancer.com/freelancers/skills/Web_Scraping/). I have done many similar jobs. Thanks, Alex
$79 USD in 3 days
5.0 (103 reviews)
6.5
6.5
18 freelancers are bidding on average $118 USD for this job
User Avatar
Hi nbouchard. I have seen the site and I can write a webscraper for you that would search and retrieve the data based on the zip codes provided in your sheet. Kindly message and discuss so we may begin. Regards.
$160 USD in 3 days
5.0 (67 reviews)
6.7
6.7
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$194 USD in 10 days
4.9 (115 reviews)
6.2
6.2
User Avatar
I am an excel vba expert and I can help you with your project .......................................................................... ..................................................................
$222 USD in 3 days
5.0 (37 reviews)
5.3
5.3
User Avatar
Hi, I build robust, strategic business solutions. Period. I built an Excel based scraper for finanicial data from Bloomberg, REUTERS and FTID. Other people will build just a dumb macro but I build one with all checks and balances (i.e. is there internet connection, is the page actually available, has the page format chanegd ? If so, alert the user..). You get what you pay for I think..SteveP. PEDIGREE / PREVIOUS WORK My pedigree includes these (my own sites and my own developed software): My Excel and Access development site (I also TEACH development): vbafasttrack.com. I recently completed a project to build a Bitcoin trading application, a binomial and trinomial employee stock options model for a mid-tier US investment bank and have an Insto finance and trading background myself. I am also the developer of the following software freelancesniper. Be advised I have my own company doing this stuff and have an institutional IT background. Cheers. SteveP.
$175 USD in 5 days
5.0 (4 reviews)
4.7
4.7
User Avatar
I have created many macros for various purposes. This one seems to be an easy one and I can do it to your satifaction. In an Excel sheet you have to give all the zipcodes and the trades. The macro wll give the licence datails.
$35 USD in 3 days
4.5 (50 reviews)
4.9
4.9
User Avatar
Thanks for your detailed instructions. I will provide you VBA macro script under windows excel and internet explorer which will be able to handle any number of zip codes and search results with one click. The script will be one click process. Highly efficient and accurate.
$30 USD in 1 day
4.9 (15 reviews)
3.6
3.6
User Avatar
Hi, I can do this for you. I'm a programmers, I have experience in the field of Web Auto Try to hire me, I will make you feel satisfied.
$35 USD in 1 day
5.0 (2 reviews)
3.2
3.2
User Avatar
I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high quality.
$147 USD in 3 days
5.0 (9 reviews)
3.1
3.1
User Avatar
Sir I'm expert on Data Entry and Web Research and Excel. I have done many project like this . I will give you best quality and service. Hope positive reply from you. I'm ready to start now . Thanks
$30 USD in 1 day
4.4 (6 reviews)
2.4
2.4
User Avatar
Hello, I am interested to work on your project. I have skills on DataEntry work, MS Word, Outlook, Access, Excel Macros and Photoshop. I have trained nearly 200 head counts on Excel in private sector. I will complete your project on time because i have experience in connecting web and excel. Please let me know if i am eligible for this job. And i am ready to work at your cost. Thank you, With Regards, V. Sivanath
$30 USD in 3 days
5.0 (1 review)
1.3
1.3
User Avatar
Hi, I would like to apply as a data entry specialist in your job post. It says that you are looking for someone who knows Microsoft Word and Excel and also who is a detail-oriented person. I think that I am the right person for the job. I am new here but My 9 years plus work experience helped me develop mastery in Word and Excel. As a data entry specialist, I also am detail-oriented. Rest assured all the data will be accurately entered, no more, no less. I am looking forward to discussing with you about this job post. Please feel free to contact me, I am available online 12 hours a day. The 5 things made me different from others 1. I feel I am the best fit for this job, because I am a team player, very energetic. 2. I’m an Expert, Honest, Sincere and Responsible worker as I’m taking my work like my Responsibility. 3. Great communication with my Clients. 4. I love to juggle multiple tasks; will go the extra mile to get the job done. 5. 100% GURANTEED Satisfaction. I have also a few clarifying questions on the project: * How much time will need to end this project? * I would be glad to talk about this project with you. I am really interested to know more about your project. What are the other things that I can do to satisfy you for your project? I would love to build an awesome working relationship with you by my Expertise, Honesty, Sincerity and Hard Work. Looking for soonest reply from you. Thanks Deepali
$155 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Generally I have generate macro code your requirement. I have advance experience in macro for more than 5 years. If you have a question, please do not hesitate to contact me. Alexs
$222 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Needham, United States
5.0
3
Payment method verified
Member since Jul 29, 2013

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.