Data sources

This is the first argument of your =IMPORTFROMWEB( ) function.​

You can extract with the same function up to data sources. If you’re looking to extract more than 50 pages, consider splitting the inputs into various IMPORTFROMWEB() functions.

A source can be either:

A single URL or a reference to one cell or a range of cells that contain URLs (up to 50 URLs).

Example:

=IMPORTFROMWEB("https://www.imdb.com/chart/boxoffice")
=IMPORTFROMWEB(A1) or =IMPORTFROMWEB(A1:A10)

A piece of HTML code.

You may prefer to write it in a separate cell and call the content by its cell reference.

The ID of an HTML file that is hosted in a Google Drive.

ImportFromWeb allows to load files stored in your Google Drive.

  • Upload a text file containing HTML. Bear in mind that it cannot be a Google doc: you need to create a plain text file on your computer and upload it to your Google Drive.
  • Change the file permissions so that anyone who has the link can view the file

Web Scraping is quite different from loading a web page from your browser because a Web Scraper is not a human and may be rejected by the target website.

ImportFromWeb has been designed to load pages that cannot be loaded by most of the tools thanks to the use of cutting-edge technologies.

That said, The diversity of technologies that are used to create and serve web pages makes it impossible to ensure a deliverability of 100%.

If you don’t succeed at loading a specific website, just contact us.