Home > Back-end >  IMPORTHTML/ IMPORTXML to get Image in Sheets
IMPORTHTML/ IMPORTXML to get Image in Sheets

Time:08-02

Only found a couple of articles on using these two Google Spreadsheet functions to import/scrape images from pages, but the solutions didn't really work for me. I'm looking to apply it to Wikipedia or DBpedia structure. I don't necessarily want the image imported into Sheets, it would be enough to get a TRUE / FALSE if there's a pic in the first place, but since what I've tried is forever "Loading..." can't tell if it's working or not.

=IMAGE(QUERY(IMPORTXML(A1,"//a/@href"),"where Col1 contains 'image'"))

enter image description here

also if you get this extension:

enter image description here

  • Related