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.
- High volume of requests per sheet
Use the function hundreds of times per spreadsheet
- 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
IMPORTFROMWEB() is an evolution of the native Google Sheets function IMPORTXML(). Unless the latter, it is much more powerful and reliable.
| 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
Check out the documentation