ImportFromWeb imports data from any websites into your spreadsheet using a simple function. It's like ImportXML but on steroids 💥
Listing updated:September 26, 2023
Works with:
148K+
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
Alex Gillespie
September 5, 2023
Importfromweb has been an extremely beneficial tool for me so far. The getting started guides are great, and the tool is easy to use. Customer service has also been impressive - I had a question about a more advanced data pull, and support was prompt in helping me solve it. Highly recommend!
Is this review helpful?
Yes
No
Profile Picture
David Dagger
September 12, 2023
Absolutely game-changing! This app effortlessly extracts crucial information from any website, making research a breeze. Its intuitive interface and lightning-fast processing speed make it an invaluable tool for anyone seeking to streamline data collection. A must-have for productivity enthusiasts!
Is this review helpful?
Yes
No
Profile Picture
Ubaid Qureshi
August 30, 2023
Impressive Support and Resolution! I encountered issues with premature content completion and quality using Import From Web. However, their customer support was quick to respond and resolved my problems efficiently. I appreciate their dedication to ensuring a positive experience for customers. Thank you!
Is this review helpful?
Yes
No
Profile Picture
Betsy Wolf
August 28, 2023
ImportfromWeb has been an amazing tool for me, saving me endless hours and making my data capture incredibly easy and convenient. Petar has been wonderful in his support, helping me work out the more tricky data pulls I've encountered and assisting me with this expertise. I cannot recommend this app more highly.
Is this review helpful?
Yes
No
Profile Picture
Yuliya Mironchyk
August 30, 2023
Great extension. I highly recommend it. I use it every week and it helps me to save time and effort. Customer service is amazing - they reply to my questions very quickly and provide assistance if any issues occur.
Is this review helpful?
Yes
No
Profile Picture
Pavol Malinovský
July 11, 2023
The importfromweb add-on for Google Sheets has transformed my web data gathering experience with its remarkable functionality. Even without a background in programming, the tool is easy to use, and its automatic updating feature ensures data is always up-to-date. Exceptional customer service sets it apart, swiftly addressing any issues. Overall, it's a highly recommended for efficient data import into Google Sheets.
Is this review helpful?
Yes
No
Profile Picture
Ryan Mercer
May 23, 2023
Initially, I installed it and was like, "it doesn't show up in extensions, I can't activate it!" DOH! I was looking in Chrome extensions, not in Google Sheets. If you can't figure it out, maybe you're doing the same thing as me!
Is this review helpful?
Yes
No
Profile Picture
Pablo Testa
September 5, 2023
ImportFromWeb has been a fantastic tool to scrape data for stock analysis purposes. Would definitely recommend!
Is this review helpful?
Yes
No
Profile Picture
C. A.
May 29, 2023
As a mere code-ignorant, I was hopelessly looking around to find a solution to my scraping problem. ImportFromWeb works like a charm, especially to scrape dynamically generated tables. And Petar is super friendly and helpful. This is a must have Google Sheets function.
Is this review helpful?
Yes
No
Profile Picture
Nighil Shamsudeen
June 22, 2023
The best extension ever, am not the kind of person who usually use these extension, or any special tools, I used to find it so confusing, without having much of an excel or coding expertise, I was always uncertain on how to use these tools for my personal and professional advancement. Hats off to nodatanobusiness team, this has helped me be better at finding leads and improving research skills
Is this review helpful?
Yes
No
1-10 of 130
Search
Clear search
Close search
Google apps
Main menu