none
Scrape Non-Tabular WebPage with Power Query RRS feed

  • Question

  • I'm not very experienced in what Power Query can do in terms of WebPage Scraping, but I want to scrape a property website called www.zoopla.co.uk

    I go to the website, I make a search and I arrive at: http://www.zoopla.co.uk/for-sale/property/essex/barking/sisley-road/ig11-9ss/?q=IG11%209SS&results_sort=newest_listings&search_source=home

    There are 26 pages with 100 results per page. I want to scrape them all.

    In the example I've come across, I saw that Power Query can identify if the data is in a tabular format on the webpage, and it can retrieve it and put it in an Excel table.

    However, this data is not in a tabular format. Can I have any success at scraping it with Power Query, or do I need to rely on traditional VBA methods?

     
    Sunday, September 11, 2016 8:12 PM

Answers

All replies