Python Web Scraper: 1,000 Products to Excel in 59 Seconds

Copying product data from a website by hand takes hours, and a simple script can stop at the first error.

A Python scraper for books.toscrape.com, a public site made for scraping practice. It collects the full catalog and creates an Excel file with charts, a CSV file and an HTML report.

Async Python with a limit on parallel requests, a small delay between requests, and automatic retries. If one page fails, it is logged and the run continues. Each run is compared with the SQLite database, so new products and price changes are counted and the price history is saved.

1,000 books, 1,081 pages, 59 seconds, 0 errors. For a client, hours of copying by hand become one command, and every new run shows what changed. This is a demo project, not a client project.

See it at alfredospizza.github.io