Yellow Pages Australia Scraping Needed

I need a complete, up-to-date export of every business listed on Yellow Pages Australia. The data must be captured reliably and delivered in a single Excel spreadsheet so I can feed it straight into my market-research workflow.

The spreadsheet should contain the following columns exactly as they appear on the site:
• Business Name
• Street Address, Suburb, State, Postcode
• Phone Number
• Email (where publicly shown)
• Business Category
• Short Description / Tagline

Because the file will drive quantitative analysis, coverage and consistency are critical. Please remove obvious duplicates, keep empty cells where information is missing, and preserve any special characters in company names or addresses.

You are free to choose your own stack—Python with Scrapy or BeautifulSoup, Selenium for dynamic pages, or a comparable approach—as long as it handles pagination, category browsing, and any anti-bot measures without degrading accuracy.

Deliverables
1. Excel workbook (.xlsx) with all records, ready for pivoting or filtering
2. A brief read-me describing your scraping approach and any limitations encountered

Acceptance criteria
• At least 98 % of publicly visible listings captured
• No malformed rows or mixed columns
• Random spot-check of 100 entries shows ≤ 2 % errors

Once the file passes those checks, the project is complete and the final milestone can be released.