Web Scraping Using ImportXML

For scraping the recent posts from a site, we can use ImportXML

Follow the formula where First field having the site name Take an example of site legendofthecryptids.org

=importxml(“http://legendofthecryptids.org/”,”//div[@class=’box-post-content’]//a/@title”)

Here // – this means select all elements of the type, //div – this means select all elements under <div> tag, [@class=”] – this means only select those elements that meet the criteria given, //div[@class=box-post-content’] – this means only select elements that look like: <div class=”box-post-content”>. //a/@title is represents title element under<a> tag. like, <a title=” “>.

Screenshot:

website scraping

 

Leave a Reply

Your email address will not be published. Required fields are marked *