App Icon
ImportFromWeb imports data from any website into your spreadsheet using a simple function. It's like ImportXML but on steroids 💥
Works with:
39,982
Overview
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
✓ Tries to automatically convert data as numbers and dates when possible

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 1000 requests to use in 1 month ◀
(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
Additional information
Privacy policy
Terms of service
ImportFromWeb | Easy Web Scraping will ask for the permissions shown below. Learn more
ImportFromWeb | Easy Web Scraping will need access to your Google account
This will allow ImportFromWeb | Easy Web Scraping to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
A User of ImportFromWeb | Easy Web Scraping
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
Is this review helpful?
Yes
No
Profile Picture
A User of ImportFromWeb | Easy Web Scraping
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.
Is this review helpful?
Yes
No
Profile Picture
A User of ImportFromWeb | Easy Web Scraping
June 7, 2019
Thank you guys! If you are getting an errors, just change commas to semicolon
Is this review helpful?
Yes
No
Profile Picture
A User of ImportFromWeb | Easy Web Scraping
May 10, 2020
Function really well, only 4 starts because i am using it with some french char (é/è/à) and i did not find a solution to get past this problem
Is this review helpful?
Yes
No
Profile Picture
A User of ImportFromWeb | Easy Web Scraping
April 13, 2020
This add-on is absolutely incredible! I can't wait to see all the things I can do with this new super power! On top of that, they also have great support that can help you if you get stuck like I did at first.
Is this review helpful?
Yes
No
Profile Picture
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
Profile Picture
Omar Masari
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
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
Profile Picture
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
Profile Picture
sharbin1181
January 24, 2021
I've only used the free version but it's amazing. Super fast and easy to use. Scraping websites has never been easier!
Is this review helpful?
Yes
No
1-10 of 54
Search
Clear search
Close search
Google apps
Main menu