IMPORTFROMWEB is a new add-on for Google Sheets that retrieves any content from webpages into a sheet.

IMPORTFROMWEB creates a new function IMPORTFROMWEB() that takes as main parameters a range of web urls and a range of xpaths. It returns the results of the xpaths for each url.

Install this add-on for Free from the G Suite Marketplace

Features

  • High volume of requests per sheet
    Use the function hundreds of times per spreadsheet
  • Scrapes pages loaded with JS
    Our powerful engine allows to return elements from Javascript-powered websites
  • Caches results so it doesn’t recalculate at any change
    Unlike IMPORTXML, it doesn’t update the cells at any change in the spreadsheet. Instead it uses a smart and customizable cache system
  • Regex manipulations
    Uses the power of regexs in order to extract or replace specific parts of texts
  • Stack results of multiple search pages in one list

An alternative to IMPORTXML

IMPORTFROMWEB() is an evolution of the native Google Sheets function IMPORTXML(). Unless the latter, it is much more powerful and reliable.

IMPORTXMLIMPORTFROMWEB
buggy when it is called more than a dozen of times in a spreadsheet.
Works flawless with hundreds of formulas per sheet
The more formulas, the slower it getsIt’s lightning quick!
Refreshes at any change in the spreadsheetCaches the data on demand, so it doesn’t recalculate all the formulas at any change
Doesn’t work for dynamic content generated by JavascriptWorks with Javascript
Very basic. No option!Many options available for powerful scraping.
For instance, it gives options to extract or replace parts of the results with regexs

Check out the documentation