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 ;)
592 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.019
Reviews
A User of IMPORTFROMWEB: Imports data from any website
January 3, 2020
Excellent tool! Requires some technical know-how and troubleshooting, but very easy to get up and running.
Submit reply
Cancel
A User of IMPORTFROMWEB: Imports data from any website
January 2, 2020
Very useful tool for basic scraping. After having a minor issue I reached out the support and they helped out swiftly. Wonderful!
Submit reply
Cancel
A User of IMPORTFROMWEB: Imports data from any website
December 4, 2019
Amazing! I'm no techie, but I found this add-on easy to use for my basic IT knowledge. Works wonders for my PhD investigation - allows me to compile lots of data super efficiently. Yay!
Submit reply
Cancel
A User of IMPORTFROMWEB: Imports data from any website
December 3, 2019
The setup page doesn't work. A formula returns 'Service Termporary Unavailable'.
Submit reply
Cancel
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
July 15, 2019
Hi Matthieu, Thanks for this add on. Its really an great add on to get dynamic data. It solve most tedious and time consuming task. Need one more help in understanding or rather solving below error message received as on outcome of this add on. "#QUOTA_REACHED: Your quota has been reached for today" Please help me on above outcome as I need to use numerous time in a day. Thanks for the support. Hi Matthieu, Are you active here? Thanks
Submit reply
Cancel
A user of IMPORTFROMWEB: Imports data from any website
July 15, 2019
Hi Mukesh, I have seen your message and have sent you an email. I hope you've received it. Thanks
A user of IMPORTFROMWEB: Imports data from any website
July 15, 2019
Hi Matthieu, Are you active here?
A User of IMPORTFROMWEB: Imports data from any website
July 4, 2019
The big issue that I am having with it is that I am unable to pull from a range of urls. Specifically, I am trying to pull stuff from multiple pages of the same url, however since the url changes with every different page (urls end with ...&page=yourpagenumberofchoice) I am unable to just set it to pull the same data from all of them. This is a massive PITA because there are over 90 pages to pull from. In other words, as things are I would have to do the same url with only that page=# part different over 90 times in the same cell.
Submit reply
Cancel
A User of IMPORTFROMWEB: Imports data from any website
June 7, 2019
Thank you guys! If you are getting an errors, just change commas to semicolon
Submit reply
Cancel
1-9 of 9
Additional information
Search
Clear search
Close search
Google apps
Main menu