All Forum Posts by: Travis S.

if you have the budget pull from API.

If you dont see if the county where the properties are offer free sales/ownership data which you can download and then find the data you want and build a dataset inside excel.

How many addresses? can you build or code macros? Using power query or?

learn to use a tool which gets data from a wider spectrum of websites.

No code/low code tend to be free at first but not the long run and and have limited uses.

Kieron,

Thank you for the response. Unfortunetly, I do now have any coding experience or know how to utilize API.

My target county does make property data availiable and I have downloaded much of it. What I have done already is pulled the county records for 10s of thousands of properties in my county. I have compiled many of them from target areas into excel with owners info, address, ect. I do still need to collect/scrape property details such as Sq. ft., bed, bath, ect. I think this will be the easier part that I can complete with something like the custom bot from browse ai, but idk about doing it at that kind of volume which will likely be an issue. Even Excel on a strong computer has trouble with how much data there is.

Most importantly, what I would like to be able to do is run "initial analysis" on all the addresses in the excel dataset, such as compiling comps based on customized parameters on every address in the database for example, giving me a snap shot of the ARV for all properties in the targeted area. This will allow me to search for investment opportunities through filters and comp values. Part of my marketing can be determined by my database which has done much of the preliminary work for me through automation.

In theory I know what I want to be able to do, but I am over my head technically on this one.

Thanks

0 Votes

Quote from @Hana Kooker:

Hi Travis,

Are you looking for a no-code option? Maybe take a look at Browse AI I believe they have pre-built data scraping bots for Zillow and Redfin. If those don't work for you it is fairly easy to train a custom bot on their platform as well.

Hana,

Thank you for this recommendation. I did check out browse.ai early on and I believe the custom bot is the way I would need to go with them. The pre-builds weren't quite what I needed.

I have zero coding experience. I do have a good working knowledge with Excel, but not beyond its internal workings.

Thanks

0 Votes

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?

0 Votes

All Forum Posts by: Travis S.

Travis S. has started 1 posts and replied 3 times.

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

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

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