App Icon
NoDataNoBusiness
•  13,059
Overview
ImportFromWeb imports data from any website into your spreadsheet using a simple function. It's like ImportXML but on steroids 💥
Write =IMPORTFROMWEB( url, path_to_content ) and retrieve all the data in a clean table
...

✓ 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!

▶︎ INSTALL IT to start your FREE trial with 500 requests to use in 2 weeks ◀
(No payment information needed)

Want more? Check out our plans: https://nodatanobusiness.com/importfromweb/pricing/

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:
Profile Picture
Michael Mountain
December 30, 2020
Using the free version right now to help import data for my Investments. Wonderful will be upgrading soon to a paid version for more imports. Absolutely "MUST HAVE ADD ON"!!!
Is this review helpful?
Yes
No
Profile Picture
Max Brawer
December 28, 2020
Just amazing what this can pull off! Scrapes sites that others say are unscrapable
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
December 7, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
Profile Picture
linh tran
November 23, 2020
Importfromweb is very useful and easy to use.
Is this review helpful?
Yes
No
Profile Picture
Brandon Hurley
October 18, 2020
I've been donating my time to help my fantasy football league organize stats on a GoogleSheets page. I found ImportFromWeb is exactly what I needed, being as ImportXML was so hit or miss. Should I need this function for any commercial reasons, I won't hesitate to get one of the subscriptions. The developer is also very helpful, even with someone just using the basic account. I wish everyone provided this kind of service.
Is this review helpful?
Yes
No
Profile Picture
Ivan C.
October 14, 2020
Great addon for Google sheets. Works with any webpage, jsRendering is amazing! Thank you to Matt for putting out a great product!
Is this review helpful?
Yes
No
Profile Picture
David O
October 7, 2020
Worked great, bought the Basic Subscription. It stopped working after 1 week, trying to figure out how to cancel subscription. Update 10/7/2020: Matt and his team reviewed my google sheet. Within 8 hrs Matt had found my errors (multiple) and pointed out my incorrect use of the parameters and options. He fixed my errors, and reset my usage. I do not remember customer service this fast, professional and CORRECT! This addon is soooo useful I'll have to upgrade my subscription :), I was using it in multiple sheets for multiple imports. REALLY IMPRESSED WITH MATT'S TEAM!
Is this review helpful?
Yes
No
Profile Picture
Jennifer Lorimer
September 12, 2020
Great tool for a relative novice, I just wanted to not have to copy/paste data into my googlesheets and was struggling with other solutions to work with the content I was copying - this tool was easy to navigate and help documentations and demo's helped me to produce the data I wanted .
Is this review helpful?
Yes
No
Profile Picture
Aries Vazquez
August 25, 2020
Amazingly empowering tool for non-developers. Makes hard coding almost non-essential for data analysis
Is this review helpful?
Yes
No
Profile Picture
Muhammad Kashif Saif
August 25, 2020
Hi I am getting this message, whereas it was working perfectly until last week "#MONTHLY_QUOTA_REACHED Check your quota in the sidebar, tab 👤"
Is this review helpful?
Yes
No
1-10 of 44
Additional information
NoDataNoBusiness
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu