App Icon
NoDataNoBusiness
•  7,138
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!

▶︎ Start for free with 100 requests per month ◀

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
A User of ImportFromWeb | Easy Web Scraping
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
A User of ImportFromWeb | Easy Web Scraping
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
A User of ImportFromWeb | Easy Web Scraping
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
Profile Picture
A User of ImportFromWeb | Easy Web Scraping
August 11, 2020
good
Is this review helpful?
Yes
No
Profile Picture
A User of ImportFromWeb | Easy Web Scraping
August 6, 2020
This was my first time scraping data from the web. I tried multiple tools and found them confusing and have a big learning curve and I didn't have time for that so I kept looking until I found this add-on and it did exactly what I wanted and it was fairly easy to learn and get started with and the templates and examples were a great help in that matter. In overall, I enjoyed using the tool and I'll definitely come back to use it in the future. Thank you and keep up the good work.
Is this review helpful?
Yes
No
Profile Picture
Denis Bourke
July 18, 2020
Found this Add-On and installed it. I used to get dividend rates and yields for a share market portfolio. Worked beautifully. However I now get a message "#MONTHLY_QUOTA_REACHED Check your quota in the sidebar, tab 👤". I have looked in the side bar tab but cannot find anything that informs me as to what the message means. I means, I understand some sort of limited has been reached, but what limit, how is it set, and so on.
Is this review helpful?
Yes
No
Profile Pciture
A user of ImportFromWeb | Easy Web Scraping
September 10, 2020
Hi; I am encountering this issue as well. do we have any resolution?
Profile Pciture
A user of ImportFromWeb | Easy Web Scraping
August 3, 2020
I had the same problem. How to solve it?
Profile Picture
A User of ImportFromWeb | Easy Web Scraping
July 1, 2020
Works like a charm - especially after Matt answered my question within minutes. Thanks so much!
Is this review helpful?
Yes
No
Profile Picture
A User of ImportFromWeb | Easy Web Scraping
June 4, 2020
SUCH a useful add-on and a really responsive team when you have a question.
Is this review helpful?
Yes
No
Profile Picture
Dave Winter
June 3, 2020
What a helpful team - we use sheets to monitor twitter. Keeping us up to date as twitterchanges is a real bonus.
Is this review helpful?
Yes
No
Profile Picture
A User of ImportFromWeb | Easy Web Scraping
May 20, 2020
How can we refresh the data every x minutes automatically?
Is this review helpful?
Yes
No
1-10 of 37
Additional information
NoDataNoBusiness
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu