The brief is to scrape the website [login to view URL] and fill in the following columns in an Excel document with the contact details for EACH company in the Sheffield Business Directory under the following headings:
Excel template:
Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 Column 7
Company name Address Line 1 Address Line 2 Address Line 3 (if appropriate) Postcode Email address Email address 2 (if appropriate)
Headings:
Accountants (36)
Advertising Agencies (12)
Architects (27)
Artists (18)
Bookkeepers (24)
Bouncy Castle Hire (8)
Car Dealerships (12)
Caterers (17)
Clothing and Accessories (34)
Commercial Cleaning (28)
Complementary Therapy (91)
Computer Repair (42)
Computer Support (28)
Computer Training (8)
Copywriters (15)
Counselling (27)
Estate Agents (31)
Event Organisers (17)
Financial Advisers (17)
General Engineering (13)
Graphic Design (70)
Haulage (5)
Health and Safety (21)
Hotels (5)
Industrial Equipment (15)
Internet Marketing (29)
It Consultancy (14)
Letting Agents (20)
Management Consultants (21)
Marketing (67)
Marketing Consultancy (75)
Mortgage Brokers (8)
Mortgages (9)
Networking (15)
Online Advertising (9)
Printing (44)
Property Consultants (31)
Public Relations (14)
Recruitment Agencies (43)
Secretarial Services (15)
Sign Makers (16)
Software Development (23)
Solicitors (14)
Surveyors (7)
Translation Services (17)
Travel Agents (11)
Video Production (22)
Web Designers (150)
Web Development (47)
Web Hosting (16)
The numbers in brackets refer to the number of entries under that section, so the “Accountants” category will generate the details of 36 businesses, i.e. 36 rows in Excel. Please complete the first section (“Accountants”) and then send the document to me so that I can check it matches my requirements. Once I have approved the list I will then ask you to complete the task by scraping the data for the remaining categories.
Dear Hiring Manager,
I want to do this "Web scraper" project now, let's start immediately. I have read the job description. Please send me more details of the job.
Regards,
Oliver