App Icon
ImportFromWeb imports data from any websites into your spreadsheet using a simple function. It's like ImportXML but on steroids 💥
Listing updated:February 1, 2023
Works with:
93,927
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
Felipe Barreto
November 1, 2022
I use IMPORTWEB because IMPORTHTML or IMPORTXML are not so powerful and have rows constrains. It helps me SO MUCH! Customer support also is very good helping with setup and around all questions I had. Best automation tool around google marketplace for sure.
Is this review helpful?
Yes
No
Profile Picture
Vachik Khachatryan
January 27, 2023
At first, I put a bad review because the product did not work, but the company CEO(Adrien) himself contacted me and we solved the issue, very helpful tool and it WORKS like magic. Thanks a lot
Is this review helpful?
Yes
No
Profile Picture
Daniela Valenzuela
November 3, 2022
Excellent tool and brilliant service. I was stuck on an issue, and they suggested a way around it very quickly! Amazing technical support, it would be great to be able to pull URLs from images.
Is this review helpful?
Yes
No
Profile Picture
Wendy Green
January 20, 2023
Just started working with this, so far so good - I'm not very good with formulas etc but their customer service were super efficient - thank you!
Is this review helpful?
Yes
No
Profile Picture
awais dost
January 27, 2023
The IMPORTFROMWEB is best way to scrap any data from e-commerce sites. It also have many more features it's ready to save your time and manpower. Thanks.
Is this review helpful?
Yes
No
Profile Picture
Andrew Allen
October 29, 2022
Had to make sure it work before I leave a review! I've been looking for a scraper that work great, and IMPORTFROMWEB is one of the top five best web scraper out there, it return the right information, guys awesome scraper. Thanks also to Adrien for helping me to configure the scraper, many thanks.
Is this review helpful?
Yes
No
Profile Picture
Andrew Song
October 19, 2022
As a startup founder and Y Combinator alum, I've found this tool to be super helpful when scraping info from conference attendee lists and adding the contacts to my CRM so that I can place meetings prior to maximize my time to talk to potential leads. Generally, I would have to cut and paste each row and this saves me a ton of time. I also had an opportunity to talk to the COO and he was super helpful in getting everything setup. I would highly recommend trying out this tool.
Is this review helpful?
Yes
No
Profile Picture
Jack Bird
December 29, 2022
Works awesome but not for all cases. I use it for my goodreads extraction. But also for my complex eCommerce web-scraping case I would suggest eScraper service for eCommerce.
Is this review helpful?
Yes
No
Profile Picture
Changchun TANG
December 14, 2022
don't know where it goes wrong. I just copied the sample formula. And it turns out error.
Is this review helpful?
Yes
No
Profile Picture
Marco Casalini
September 28, 2022
Great tool that saves my team and I a lot of time when studying a particular niche on Amazon. Once you try it you'll never stop using it!
Is this review helpful?
Yes
No
1-10 of 96
Search
Clear search
Close search
Google apps
Main menu