I have a web scraping project. It's quite urgent but I think it is fairly straightforward and may even be possible using the Excel Power Query. There are no password issues and all data is publicly available.
I am including to a link to a video for my client web site that shows the process to select the scrape data. Please view this before responding https://www.dropbox.com/scl/fi/n7xda6xvlq2x7e2h4u3or/Website.mp4?rlkey=t2sde1e5qaef6jl3gxrnlmwj2&dl=0
The client sells hundreds of different paint products from different manufacturers. This project is a proof of concept to prove that you can provide an automatic solution and acceptable output format to scrape just 7 of the products. Each Manufacturer supplies Product and Safety Sheets for the product. In most cases the Manufacturer sheets are downloadable via a link to the Manufacturer's site. Sometimes the client has the sheet stored in their own db. The client wants to scrape the website to be able to download every sheet into a single directory and produce an Excel sheet that has an index of the different products and also shows the url trail from the website. The sheet may have a completely different name from the website so we need to be able to index every sheet and be able to retrieve it. If this is something you are interested in I need you to prove the process with the following very simple Test Project ... To prove the concept and output formats I want you to just scrape the Product and Safety sheets for the seven paints in the Anti-Condensation category shown in the attached video tonight? We are only interested in the Product and Safety sheets. Some products have other sheets - we are not interested in these. Some products may have several Safety sheets we are interested in all the Safety sheets. Let me know if you think it can be done in Excel, a mix of Excel/Macros/VBA or using an alternative solution (and let me know what your alternative is). If you are successful with this project I will then create a new project to scrape the whole site. You must have excellent written English and preferably a track record of at least a dozen similar projects Please start your reply with the word Blackpool so that I know you have read to the end. ... and please dont just send some auto AI response. I am getting a bit tired of these Best of luck Chris
