Selectors

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

KeywordsDefinitions
titleThe page title
h1the main headings
h2secondary headings
emailthe emails contained in the text of the page
linkUrlthe link urls
linkAnchorsthe link anchors (i.e. the clickable text of the link)
metaTitlethe title form the <meta> tag
imageSourcesthe image sources
metaKeywordsthe keywords in the <meta> tag
metaTwitter idthe id of the related Twitter account
metaDescriptionthe descriptions in the <meta> tag
imageAlternativesthe 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