Data sources

It specifies the source that you want to get content from (Required).This is the first parameter of your IMPORTFROMWEB function.​

A source can be either:

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

Example:

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

An 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.

The file has to be a text file uploaded from your computer. It does not work with HTML content pasted in a Google Doc

There is a limit of 50 data sources per function. If you’re looking to extract more than 50 pages, consider splitting the inputs into various IMPORTFROMWEB() functions.

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.