NoDataNoBusiness
•  1,177
Overview
ImportFromWeb imports data from any website into your spreadsheet using a simple function. It's like ImportXML but on steroids.
ImportFromWeb imports data from any website into your spreadsheet using a simple function. It's like ImportXML but on steroids.
> Read more...

Key features:
* Use the function hundreds of times per spreadsheet
* Supports JavaScript-rendered pages
* Uses a smart, customizable cache system to store results and prevent updating on every change
* Modify the returned results using regular expressions
* Stack results of multiple search pages into a single list

Fed up with ImportXML limitations? Try ImportFromWeb!
Overview
A simple function that imports content from any website directly into your Google Sheet in real time. It’s web scraping directly in Google Sheets… no coding knowledge required!

ImportFromWeb helps you to:
* Scrape search results in Amazon, Google, YouTube, Reddit, and more
* Analyze website links for SEO
* Gather data from Wikipedia pages
* Follow stock market trends
* Extract lists of homes in Zillow
* Display free photos in bulk from Unsplash

... and import any other public web data. The sky’s the limit!

Features:
* High volume - use the function hundreds of times per sheet
* High compatibility - supports JavaScript-rendered sites
* Flexible - use CSS selectors or XPath queries to define data captures
* Native caching - stores results to prevent constant recalculations
* Localization - fetch results displayed in other countries via our built-in proxies
* Extras - stack results, use regular expressions to extract/replace data, and more!

How does ImportFromWeb compare to ImportXML, ImportHTML, ImportFeed, and ImportData?
* The three native functions only work under certain conditions. For example, they cannot load Javascript-powered websites, and have usage limitations. 
*  ImportFromWeb offers more features and flexibility compared to its native counterparts. ImportFromWeb can scale up with larger web scraping projects, and supports most websites with ease.

Many users of importJSON, Supermetrics, SheetGo, Google Analytics, Autocrat and Power Tools already love our scraper!



Read more at https://nodatanobusiness.com/importfromweb/

--------------
Import From Web, among the best add-ons for Google Sheets
Reviews
Language:
Sort by:
A User of ImportFromWeb | Easy Web Scraping
March 24, 2020
How to scraped site that has 2 pages of table with same url (both JS rendered)..? Any way to navigate between JS pagination or show more entries?
Is this review helpful?
Yes
No
A User of ImportFromWeb | Easy Web Scraping
February 17, 2020
Great tool and excellent customer service as well. Highly recommend this tool, especially if you are running a lot of IMPORTXML formulas that eventually slow down, this tool will run multiple requests much faster.
Is this review helpful?
Yes
No
A User of ImportFromWeb | Easy Web Scraping
February 14, 2020
This tool works so well and I'm actually glad that it works within the formulas of Google Sheets. There are a lot of limitations to similar products that have a point and click interface. I have to look at 100+ pages per product for our price comparisons and this tool makes it so easy!
Is this review helpful?
Yes
No
A User of ImportFromWeb | Easy Web Scraping
February 5, 2020
Great tool. Excellent customer support. Thank you.
Is this review helpful?
Yes
No
A User of ImportFromWeb | Easy Web Scraping
February 4, 2020
Superb tool and great people behind it. Highly recommend for researching mass amounts of data with ease. Bravo!
Is this review helpful?
Yes
No
A User of ImportFromWeb | Easy Web Scraping
January 26, 2020
THIS IS AMAZING! Ran into some issues with too many URLs added in one function in the beginning, but figured out a fix for that. I have been using it to parse Youtube Data into a live dashboard for competitor videos.
Is this review helpful?
Yes
No
A User of ImportFromWeb | Easy Web Scraping
January 3, 2020
Excellent tool! Requires some technical know-how and troubleshooting, but very easy to get up and running.
Is this review helpful?
Yes
No
A User of ImportFromWeb | Easy Web Scraping
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!
Is this review helpful?
Yes
No
A User of ImportFromWeb | Easy Web Scraping
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!
Is this review helpful?
Yes
No
A User of ImportFromWeb | Easy Web Scraping
December 3, 2019
The setup page doesn't work. A formula returns 'Service Termporary Unavailable'.
Is this review helpful?
Yes
No
1-10 of 15
Additional information
NoDataNoBusiness
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu