How to retrieve/scrape data based on addresses already saved in Excel

[Travis Sanders]

I am trying to automate my data collection through excel. My thought is to take a compiled list of property addresses saved in Excel and then run data scrape from Zillow and Redfin on each of those addresses, pulling the property details back into excel and into the appropriate table I have set up. 

Any thoughts?