'Is it possible to use Google sheet's IMPORTXML to extract data from a website document which file format is unknown to me?
I'm wondering if there's a way to extract data/information from the document shown in the link below, using Google sheets' IMPORTXML?
I tried understanding and using XPath, but can't make it work. I would greatly appreciate any help from someone. Thank you very much.
Solution 1:[1]
The site you're trying to extract data from, loads with JavaScript and the IMPORT function can’t extract content that loads with JavaScript. You can check this thread.
You can check that the website is JavaScript controlled by clicking on the ‘Lock’ icon beside the browser’s address bar, select ‘Site settings’ and set JavaScript to ‘Block’. Reload the page and as you can see the screenshot below, the site needs JavaScript enabled to load data.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Lorena Gomez |