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 selectors (xpaths or CSS selectors). It returns the results of the selectors for each url.

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

Also available in the Chrome Store

Features

  • High volume of requests per sheet
    Use the function hundreds of times per spreadsheet
  • Scrape pages loaded with Javascript
    Our powerful engine allows to return elements from Javascript-powered websites
  • Works flawless with many websites
    A pool of proxies from all around the world allows IMPORTFROMWEB to load most of the websites.
  • Stores results so it doesn’t recalculate at any change
    Unlike IMPORTXML, it doesn’t update the cells at any edition of the spreadsheet. Instead it uses a smart and customizable cache system so you keep data for hours or days.
  • Use CSS selectors or XPaths to find elements on the page.
    CSS selectors is so easy to learn, but XPath is so powerful… well, just choose your flavor
  • Choose your country
    You can query a website from many different places. Super useful to import local content or compare what a page displays in various countries
  • Stack results of multiple search pages in one list
  • Optional regular expressions manipulations
    Uses the power of regexs in order to extract or replace specific parts of texts. It helps you keep your data clean for further analyses

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 most of websitesWe use proxies and emulate browsers so it works with the most refractory websites
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
Requires to learn XPathWorks with CSS selectors or XPaths.
CSS selector is within reach to anyone with basic html knowledge

Check out the documentation