---

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.

IMPORTXML	IMPORTFROMWEB
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 gets	It’s lightning quick!
Refreshes at any change in the spreadsheet	Caches the data on demand, so it doesn’t recalculate all the formulas at any change
Doesn’t work for most of websites	We 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 XPath	Works with CSS selectors or XPaths. CSS selector is within reach to anyone with basic html knowledge