Web-to-Excel Data Automation
Budget: $250 – $750 AUD
I need a small automation that grabs both text and numbers from a handful of web pages (anywhere from two to ten) and places the results straight into Excel. The exact column layout is still open, so feel free to suggest a clean, logical structure that keeps the data easy to read and ready for quick analysis.
The solution can be a lightweight Python script (requests / BeautifulSoup / pandas), a VBA macro, Power Query setup, or another tool you trust—whatever reliably fetches the information and drops it into a workbook with one click. A short read-me or inline comments showing me how to point the script at a new page and rerun it will wrap things up.
Once the automation:
• pulls every required field from each page
• writes them into Excel without manual copy-paste
• runs error-free on the sample pages I provide
the job is complete.
The solution can be a lightweight Python script (requests / BeautifulSoup / pandas), a VBA macro, Power Query setup, or another tool you trust—whatever reliably fetches the information and drops it into a workbook with one click. A short read-me or inline comments showing me how to point the script at a new page and rerun it will wrap things up.
Once the automation:
• pulls every required field from each page
• writes them into Excel without manual copy-paste
• runs error-free on the sample pages I provide
the job is complete.
Related categories:
Python
Visual Basic
Excel
Web Scraping
BeautifulSoup
Data Analysis
Data Integration
Automation