One or a list of xPaths, CSS selectors or preprogrammed selectors describing the elements to retrieve in the pages (required)
It should always be the second parameter of your IMPORTFROMWEB function.
Examples:
=IMPORTFROMWEB(A1, "table")
Will display the table from the target pageCopied!
=IMPORTFROMWEB(A1, A1:F1)
Work with preconfigured descriptors
We provide a list of useful elements users may look for
| Keywords | Definitions |
|---|---|
| title | The page title |
| h1 | the main headings |
| h2 | secondary headings |
| the emails contained in the text of the page | |
| linkUrl | the link urls |
| linkAnchors | the link anchors (i.e. the clickable text of the link) |
| metaTitle | the title form the <meta> tag |
| imageSources | the image sources |
| metaKeywords | the keywords in the <meta> tag |
| metaTwitter id | the id of the related Twitter account |
| metaDescription | the descriptions in the <meta> tag |
| imageAlternatives | the image descriptions form the image alt attributes |
Examples:
=IMPORTFROMWEB("https://any.website.com", "title, h1, h2, h3")
=IMPORTFROMWEB("https://any.website.com", "linkAnchors, linkUrls")
We are building a growing list of preconfigured websites. For those websites you don’t need to look at the page source code. We’ve done the work for you!
Currently available platforms:
- Amazon product pages
- Google Search results pages
- Yahoo Finance tickers
Work with xPaths
As xPaths are usually a long string of keys, they can look a bit scary.
However, with the help of your Web browser, It can be very easy to find the right xPath for the piece of data you are looking for.
Find out more in this article:
Find an xPath with limited HTML knowledge
Work with CSS Selectors
are less powerful than XPaths to find complex elements in complex HTML pages, but they usually do the job and are also easier to build.
Standard CSS Selectors don’t allow to load values contained in attributes. With ImportFromWeb it is possible by indicating /attributeName just after the element.
For example div a img/src should return the source of the image.
Find out more in this article:
Introduction to CSS selectors