Python Excel Web Scraping Upgrade
Budget: $10 – $30 AUD
I already have a working Python script that scrapes and downloads data from a Web site into an Excel workbook. I now need that script expanded so it can automatically locate and scrape fresh numerical data from the same page on the target website, then drop each new value into a dedicated column alongside the existing content.
Here is what I need done:
• Extend the current code to perform web scraping (requests / BeautifulSoup / Selenium—use what fits best) and pull the required numerical figures.
• Append those figures into a new column in the same workbook using openpyxl or pandas so the original data remains untouched.
• Provide clean, commented code plus a brief README showing how to run the script end-to-end.
If you have solid experience combining Python scraping with Excel automation, this should be a straightforward upgrade. Send over a short note on how you would tackle the scrape and I’ll share the repo and test file right away.
Here is what I need done:
• Extend the current code to perform web scraping (requests / BeautifulSoup / Selenium—use what fits best) and pull the required numerical figures.
• Append those figures into a new column in the same workbook using openpyxl or pandas so the original data remains untouched.
• Provide clean, commented code plus a brief README showing how to run the script end-to-end.
If you have solid experience combining Python scraping with Excel automation, this should be a straightforward upgrade. Send over a short note on how you would tackle the scrape and I’ll share the repo and test file right away.