ImportFromWeb data sources

Data source is the 1st argument you input in any =IMPORTFROMWEB( ) function.​

You can extract with the same function up to 50 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 / a range of cells that contain URLs

Example:

=IMPORTFROMWEB("https://www.example.com", some_selectors)
=IMPORTFROMWEB(A1, some_selectors) or =IMPORTFROMWEB(A1:A10, some_selectors)

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

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