ImportFromWeb imports data from any websites into your spreadsheet using a simple function. It's like ImportXML but on steroids 💥
Listing updated:February 28, 2024
Works with:
183K+
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 credits. 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

📌 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
Abdul Rehman
December 31, 2023
NoDataNoBusinesses transforms jumbled Google Sheets into readable files, saving me hours of laborious data extraction. I find it very helpful, especially when it comes to using Google Maps to gather information for lead generation. Additionally, they have excellent customer service and are always willing to assist.
Is this review helpful?
Yes
No
Profile Picture
Paul Baterina
January 29, 2024
"importfromweb" function is not working. I reached out to you via e-mail. I will gladly change the ratings once we figure this out.
Is this review helpful?
Yes
No
Profile Picture
Spencer Shearer
October 26, 2023
A Game-Changer for Data Retrieval and Accuracy I can't say enough good things about ImportFromWeb! This tool has been an absolute lifesaver for me, and it's transformed the way I gather and process data from the web. 1) Time-Saving Marvel: ImportFromWeb is a true time-saver. It shaves off hours from my weekly routine by automating the data retrieval process. I no longer have to manually scour websites for information, which means I have more time to focus on higher-value tasks. 2) Accuracy Boost: The accuracy provided by ImportFromWeb is nothing short of remarkable. It eliminates human errors that often occur during manual data processing. With this tool, I can trust that the data I collect is pristine and free from mistakes. 3) Top-Notch Documentation: The documentation provided with ImportFromWeb is incredibly helpful. It's clear, well-structured, and makes the learning curve a breeze. Even if you're new to the tool, you'll find the documentation to be a valuable resource. 4) Fantastic Support: The support team behind ImportFromWeb is simply fantastic. Whenever I've had a question or encountered an issue, they've been responsive and helpful. It's reassuring to know that there's a dedicated team ready to assist if needed. 5) Always Fresh Data: Thanks to the automation features of ImportFromWeb, my data is always fresh. I no longer worry about outdated information, and this real-time data availability has helped me make better decisions, faster. In summary, ImportFromWeb has been a game-changer for me. It not only streamlines my data retrieval process but also ensures that the information I collect is accurate and up-to-date. With excellent documentation and outstanding support, it's a tool I can rely on with confidence. If you're looking to boost productivity, accuracy, and decision-making, do yourself a favor and give ImportFromWeb a try—you won't regret it!
Is this review helpful?
Yes
No
Profile Picture
Petar Vuksanovic
January 9, 2024
Importfromweb has been fantastic addition to our list of tools. It saves us one whole day of manually data retrieving per week and now we can focus more on the core activities of our business like sending marketing campaigns, contacting potential customers etc. Thank you for creating such a useful tool guys!
Is this review helpful?
Yes
No
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
Gopal Shah
January 24, 2024
NoDataNoBusiness allows complete flexibility in scraping. This has been a game changer for all things digital. And the NDNB team have been excellent partners!
Is this review helpful?
Yes
No
Profile Picture
Eugenio Luciano
February 2, 2024
Used to scrap information about video games. I'm not an expert on Google Sheets at all, but I've found it very easy to use. For those struggling or feeling overwhelmed, all I did was 1. right-click on the web page you want to get info from and select Inspect 2. Ctrl-Shift-C to select the single element you want to scrap 3. On the inspection tool on the right, right click and copy 'Xpath' (sometimes, when it doesn't work, copy 'Full XPath'') 4. Now in the IMPORTFROMWEB formula on your Sheet document, insert the URL of the website as first argument, and paste the xpath as the second argument. 5. This should work.
Is this review helpful?
Yes
No
Profile Picture
Lauren Boucher
February 15, 2024
Import from web is an easy-to-use tool for scraping data from Amazon. I was amazed with how quickly I was able to compile the information I needed. The direct integration with Google Sheets made the process so easy. The guides and documentation made it very easy to source what I needed. Highly recommend for Amazon!
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
Langley Disc Golf Club
November 14, 2023
Customer service is usually quick to respond and very helpful when I got stuck. Highly recommended.
Is this review helpful?
Yes
No
1-10 of 114
Search
Clear search
Close search
Google apps
Main menu