Excel Zillow Square Footage Scraper
Budget: $30 – $250 USD
I keep an Excel file that already holds a column of property addresses. I now need a small program that will open that workbook, read each address, head over to Zillow, pull the home’s listed square-footage, and drop that number back into the next empty column of the same row.
I don’t mind if you write the solution in Python (requests / BeautifulSoup, Selenium, openpyxl, etc.) or build the logic directly in VBA; whichever keeps the process as quick and reliable as possible. What matters is that I can run the tool myself on demand, point it at any worksheet with the same layout, and watch the square-footage cells fill in automatically.
Acceptance criteria:
• On a test sheet of 50 sample addresses, at least 90 % of the rows must return the correct square-footage value straight from Zillow.
• The workbook is saved with the new data in place, without disturbing other columns or formatting.
• A short read-me or inline comments show me how to adjust paths, column letters, or Zillow selectors later if needed.
Send over the finished script, the annotated source, and a quick guide so I can set it up and run it myself.
I don’t mind if you write the solution in Python (requests / BeautifulSoup, Selenium, openpyxl, etc.) or build the logic directly in VBA; whichever keeps the process as quick and reliable as possible. What matters is that I can run the tool myself on demand, point it at any worksheet with the same layout, and watch the square-footage cells fill in automatically.
Acceptance criteria:
• On a test sheet of 50 sample addresses, at least 90 % of the rows must return the correct square-footage value straight from Zillow.
• The workbook is saved with the new data in place, without disturbing other columns or formatting.
• A short read-me or inline comments show me how to adjust paths, column letters, or Zillow selectors later if needed.
Send over the finished script, the annotated source, and a quick guide so I can set it up and run it myself.