App Icon
ImportFromWeb imports data from any websites into your spreadsheet using a simple function. It's like ImportXML but on steroids 💥
Listing updated:December 2, 2022
Works with:
87,828
Overview
Write =IMPORTFROMWEB( url, path_to_content ) in your spreadsheet and import any data from any website !

ImportFromWeb is a simple function that extracts data from any website directly into your spreadsheets in real time. It’s web scraping directly in Google Sheets… no technical knowledge required!

ImportFromWeb is a good alternative to ImportXML, ImportHTML, ImportFeed, and ImportData. 
Our add-on overcomes ImportXML limits offering to load Javascript-powered websites and to scrape most websites with ease. Additionally, it supports up to 50 URLs per function with as many data points as you want.
ImportFromWeb, your perfect scraper for Yahoo Finance, Google, Instagram or Amazon !

📌 HOW DOES IT WORK ?

All you have to do is to describe the URL and the path to the data you want to output and then simply call the function this way =IMPORTFROMWEB( url, path_to_data ) 

As with ImportXML, the data to extract can be described using XPath or CSS selectors. We also offer you built-in selectors so that you don’t have to struggle with the page source code.  

Here are 2 nice examples : 
Scrape market data from Yahoo Finance typing =IMPORTFROMWEB(“https://finance.yahoo.com/quote/AAPL”,  "dividend, price, marketCap")
Scrape product data from Amazon typing =IMPORTFROMWEB(“https://www.amazon.com/dp/B018TE4Q30”, "image, title, sale_price")

📌 MAIN FEATURES

✓ High compatibility - scrapes JavaScript-rendered websites
✓ Powerful - uses proxy rotation to scrape the tough-to-scrape websites
✓ High volume - supports thousands of data points per spreadsheet
✓ Scalable - ready to be used hundreds of times per sheet 
✓ Flexible - works with CSS selectors or XPath queries to describe the data to be captured OR with our built-in selectors for major websites (Amazon, Google, Yahoo Finance, Instagram…)
✓ Customizable caching - stores results to prevent constant recalculations
✓ Localization - fetches results displayed in other countries via our built-in proxies
✓ Extras - compatible with regular expressions to extract/replace data
✓ Tries to automatically convert data as numbers and dates when possible 
✓ Easy onboarding thanks to our ready-to-use templates
✓ and much more to come ! 

📌 POPULAR USE CASES

With Import From Web you can easily :
✓ Import and monitor stock values from Yahoo Finance, Bloomberg or Nasdaq
✓ Access and aggregate crypto data from Binance, Coinbase or CoinMarketCap 
✓ Scrape search results in Amazon, Google, YouTube, Reddit, and more
✓ Analyze website links for SEO
✓ Extract e-commerce data such as prices and customer reviews
✓ Track the latest trends and influencers on Twitter, Tiktok or Instagram 
✓ Gather data from Wikipedia pages

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

Here are some websites our users love to import data from : Yahoo Finance, Bloomberg, Google, Amazon, Instagram, Youtube, NSE India, Facebook, Seeking Alpha, Market Watch, Linkedin, Zillow, Coin Market Cap…

📌 PRIVACY

ImportFromWeb is a Google Workspace add-on that has successfully passed Google’s security review. The add-on requires minimal permissions. Your data remain at all times your own property and ImportFromWeb will never transfer nor sell them to 3d parties. 
We will never save the content of your Google Sheets.

📌 PRICING

Try the add-on for free for 1 month with 1000 requests. No credit card required !
Then, choose between our plans according to the number of requests you need. No risk, we offer a 7-day money back guarantee !
https://nodatanobusiness.com/importfromweb/#pricing

1 request = 1 URL successfully fetched, no matter the number of data points collected. 

📌 SUPPORT

✓ Have a look at our repository of resources and demos at https://nodatanobusiness.com/resources/importfromweb/
✓ Check out our ready-to-use templates for the most popular platforms
✓ Browse our tutorials on our Youtube channel 
✓ Contact us and we’ll help you to get the most of our add-on ! support@nodatanobusiness.com 
 

--------------

Many users of Import JSON, Supermetrics, Mixed Analytics, KPI bees, DataConnector, SheetGo, Google Analytics, Autocrat and Power Tools already love our scraper.

ImportFromWeb, among the best add-ons for Google Sheets !

Read more at https://nodatanobusiness.com/importfromweb/
Additional information
PricingFree of charge trial
Privacy policy
Terms of service
ImportFromWeb | Web scraping in Google Sheets will ask for the permissions shown below. Learn more
ImportFromWeb | Web scraping in Google Sheets will need access to your Google account
This will allow ImportFromWeb | Web scraping in Google Sheets 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:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
A User of ImportFromWeb | Web scraping in Google Sheets
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 | Web scraping in Google Sheets
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 | Web scraping in Google Sheets
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 | Web scraping in Google Sheets
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 | Web scraping in Google Sheets
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 | Web scraping in Google Sheets
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
Nilesh Kitalikar
June 25, 2022
Tools is not working Could you please describe me how to use it
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
Nio Hind
October 11, 2022
Great work guys, a simple copy paste and done, all information sorted out for me.
Is this review helpful?
Yes
No
1-10 of 88
Search
Clear search
Close search
Google apps
Main menu