Options
Last updated:February 27, 2023
The choice of options is what makes the ImportFromWeb function so powerful and flexible.
Options are specified as the 3d parameter into any =IMPORTFROMWEB() function and can be added in two ways:
A text of keys and values
Example:
=IMPORTFROMWEB("https://www.example.com", "table", "countryCode:us") forces the function to retrieve the data simulating a US IP adress
You can combine multiple options, separating them by a comma (spaces after the comma are not compulsory):
"countryCode:us, jsRendering:true, compare:true"
A reference to a two-column range
The left column defines option names and the second column contains corresponding values.
Example
=IMPORTFROMWEB("https://www.example.com", "table", A3:B5)
Some options might be limited or unavailable according to your subscription. Check out our plans for more details