ImportFromWeb extracts web data with Google Sheets™ using a simple function. It's like ImportXML but on steroids 💥
Listing updated:September 13, 2024
Works with:
229K+
Overview
Easy Web Scraping with Google Sheets™
Simply write =IMPORTFROMWEB( url, path_to_data ) and import any data from any website!

ImportFromWeb offers a simple function that extracts data from any website directly into your spreadsheets in real time. NO TECHNICAL KNOWLEDGE REQUIRED!

Why choose ImportFromWeb?

✓  A powerful alternative to ImportXML, ImportHTML, ImportFeed, and ImportData.
✓  Scrapes JavaScript-powered websites and most other sites with ease.
✓  Supports up to 50 URLs per function with unlimited data points.


Perfect for importing real-time data from:

Top Marketplaces and e-commerce websites (Amazon, Walmart, Flipkart, eBay, Shopee, Etsy, Target, Noon, Home Depot…), Google Search™, Google Maps™, Instagram, YouTube™, and many more!



📌 HOW IT WORKS

All you have to do is to describe the URL and the data path and then call the =IMPORTFROMWEB() function

1- Choose the URL of the webpage you want to scrape
2- Define the Data Path: Use XPath, CSS selectors, or our built-in selectors for popular platforms
3- Enter the formula =IMPORTFROMWEB( url, path_to_data )

Here are 2 nice examples : 
✓ Scrape product data from Amazon typing =IMPORTFROMWEB(“https://www.amazon.com/dp/B09LNCVCKW”, "title, sale_price,buybox_winner")
✓ Scrape Google Search™ results typing =IMPORTFROMGOOGLE(“keyword”,  "title,body,link”)


📌 MAIN FEATURES

✓ Easy onboarding thanks to a catalog of ready-to-use templates
✓ Flexible - works with CSS selectors or XPath queries to describe the data to be captured OR with built-in selectors for major websites (Amazon, Google Search™, Google Maps™, Walmart, YouTube, Instagram…)
✓ High volume - supports thousands of data points per spreadsheet
✓ Scalable - ready to be used hundreds of times per sheet 
✓ High compatibility - scrapes even JavaScript-rendered websites
✓ Powerful - uses proxy rotation to scrape the tough-to-scrape websites
✓ 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 
✓ and much more to come!


📌 POPULAR USE CASES

With Import From Web you can easily :
✓ Amazon & Walmart: Extract prices and ratings for hundreds of products
✓ Market Analysis: Analyze niches and categories on any marketplaces or e-commerce
✓ Google Search™: Analyze SERPs for multiple keywords
✓ Google My Business™: Build prospect lists
✓ Social Media: Track trends and influencers on YouTube™, Instagram, TikTok
✓ Finance: Monitor stock values from Yahoo Finance, Bloomberg, Nasdaq
✓ Crypto: Aggregate data from Binance, Coinbase, CoinMarketCap.
✓ General: Gather data from Wikipedia
... 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 Search™, Google Maps™, Amazon, Walmart, Target, Flipkart, Home Depot, Noon, Etsy, eBay, Instagram, Youtube™, LinkedIn, NSE India, Seeking Alpha, Market Watch, 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 remains 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 200 credits. No credit card required!
Then, choose between our plans according to the number of URLs you need to scrape. No risk, we offer a 7-day money back guarantee !
https://nodatanobusiness.com/importfromweb-pricing/


📌 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 at https://nodatanobusiness.com/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 ImportJSON, Coefficient, 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/
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
Madhukar R
September 17, 2024
ImportFromWeb has been an invaluable tool for scraping data from Amazon. The ease of use and efficiency in transferring data directly to my spreadsheet have significantly streamlined my workflow. Highly recommend for anyone needing reliable data extraction!
Is this review helpful?
Yes
No
Profile Picture
Usama Zahid
September 10, 2024
Amazing tool! The free trial is a great way to see if it’s right for you. The Google Maps data scraper is fantastic—highly recommend.
Is this review helpful?
Yes
No
Profile Picture
Tina Dabi
September 4, 2024
It works amazing I recommend trying to free trial first before purchasing any of their plans since the free trials helps you figure out if you want to keep using their products I really love the Google Maps data scraper it works great it gives you all the details and it works amazing overall.
Is this review helpful?
Yes
No
Profile Picture
shahriar uddin
August 8, 2024
It works amazing I recommend trying to free trial first before purchasing any of their plans since the free trials helps you figure out if you want to keep using their products I really love the Google Maps data scraper it works great it gives you all the details and it works amazing overall
Is this review helpful?
Yes
No
Profile Picture
Ashish Kumar
May 20, 2024
The web import feature is an easy-to-use tool for getting data from Amazon. I was impressed by how quickly I could collect the information I needed. It connects smoothly with Google Sheets, which made managing the data much easier. The guides and instructions were very helpful for finding data. However, keep in mind that this tool might not always work and should be used occasionally. Despite this, I highly recommend it for anyone working with Amazon data!
Is this review helpful?
Yes
No
Profile Picture
Joan Whittington
July 14, 2024
I wasn't able to get this to work with any of my inputs. I followed the video tutorial exactly and also the other samples provided. Nothing worked. #PARSING_FAILED, #ALL_SELECTORS_RETURN_NULL. Copied the full page link, and the full xpath, This should be easy but it does not work at all. Even the Function Builder does not allow clicking on any of the buttons. Glad this is only a trial, thankfully finding out it doesn't work before I pay for it!
Is this review helpful?
Yes
No
Profile Picture
Asif Rahman
September 8, 2024
I highly recommend trying the free trial before committing to any plans. It lets you see if their products, like the Google Maps data scraper, are right for you. I love it—works great and provides all the details you need!
Is this review helpful?
Yes
No
Profile Picture
Afisu Olabimtan
September 5, 2024
This product works great!I especially love the Google Maps data scraper—it’s super effective and gives you all the info you need. Definitely worth checking out!
Is this review helpful?
Yes
No
Profile Picture
Michael P
March 1, 2024
The web import feature is a user-friendly tool designed for extracting data from Amazon. I was impressed by how swiftly I could gather the required information. Its seamless integration with Google Sheets streamlined the process significantly. The provided guides and documentation facilitated the sourcing process effortlessly. I highly recommend it for anyone working with Amazon data!
Is this review helpful?
Yes
No
Profile Picture
juanfe sanabria
May 31, 2024
I am unable to extract data from any site, I tried amazon, seatgeek, ebay and even youtube and it wouldn't let me see it in my sheets. I get a "--" when I use the keywords given by the tutorial page, or a "#ALL_SELECTORS_RETURN_NULL" when I copy the Xpath and I have even tried copying the full path but nothing really worked. I am unable to find resources on how to solve this, it seems like its simple and it will work but it isn't.
Is this review helpful?
Yes
No
1-10 of 126
Search
Clear search
Close search
Google apps
Main menu