Help & Support
Send Feedback
IMPORTFROMWEB: Imports data from any website
IMPORTFROMWEB imports data from any website into your spreadsheet through a simple function. It's like IMPORTXML but on steroids. Fed up with IMPORTXML limitations? try IMPORTFROMWEB() IMPORTFROMWEB is a function that allows you to import any content from any website in seconds - 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 It's like IMPORTXML but on steroids ;)
320 users
Works with
Install
Overview
A simple function that imports in real time any web content directly into your Google Sheet.
No coding knowledge required!

USE IT TO:

* Retrieve search results in Amazon, Google, ...
* Analyze websites links for SEO
* Gather information from multiple Wikipedia pages
* Follow stock market trends
* Extract lists of homes in Zillow
* Watch free photos in bulk from Unsplash

... and wherever your imagination brings you


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 various pages of search results 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


QUICK STEPS

To extract content from a website, just call the IMPORTFROMWEB function and fill the urls and XPaths of the elements you are looking for:
Ex: IMPORTFROMWEB("https://www.espn.com/nba/stats", "//table[contains(@class,"Table2")]//td[2]")


WHY IS IT BETTER THAN IMPORTXML, IMPORTFEED or IMPORTDATA?
- The three native functions only work in certain conditions. For example, they cannot load Javascript-powered websites. 
-  IMPORTFROMWEB offers much more flexibility and make the native counterparts useless


 
If you are used to Google's native IMPORT functions, you should give it a try ;)
If you are new to importing web content, remember that it will give you super powers: 
- Any data directly in your spreadsheet
- No more copy/pasting
- Your content refreshed regularly
- ...

Many users of Supermetrics, Slemma, Yet Another Mail Merge, Autocrat and Power Tools already love it!

Version: 2.015
Reviews
A User of IMPORTFROMWEB: Imports data from any website
October 21, 2019
Worked well for a while, but stopped working altogether. No explanation why.
Submit reply
Cancel
A user of IMPORTFROMWEB: Imports data from any website
October 23, 2019
Hi, Can you give us more details about your issues? You can use the message button in the add-on sidebar
A User of IMPORTFROMWEB: Imports data from any website
September 23, 2019
it so helpful for ecommerce guy, thanks a lot
Submit reply
Cancel
A user of IMPORTFROMWEB: Imports data from any website
November 11, 2019
how can u explain.?
A User of IMPORTFROMWEB: Imports data from any website
June 20, 2019
I am an e-commerce owner and I use it to compare prices from my competitors. Now I can see all their latest products in a sheet. That saves me all the hassle of going through all the websites
Submit reply
Cancel
1-3 of 3
Additional information
Search
Clear search
Close search
Google apps
Main menu