ImportFromWeb imports data from any website into your spreadsheet using a simple function. It's like ImportXML but on steroids 💥
Write =IMPORTFROMWEB( url, path_to_content ) and retrieve all the data in a clean table
✓ Use the function hundreds of times per spreadsheet
✓ Uses a smart, customizable cache system to store results and prevent updating on every change
✓ Modify the returned results using regular expressions
✓ Stack results of multiple search pages into a single list
Fed up with ImportXML limitations? Try ImportFromWeb!
A simple function that imports content from any website directly into your Google Sheet in real time. It’s web scraping directly in Google Sheets… no coding knowledge required!
ImportFromWeb helps you to:
✓ Scrape search results in Amazon, Google, YouTube, Reddit, and more
✓ Analyze website links for SEO
✓ Gather data from Wikipedia pages
✓ Follow stock market trends
✓ Extract lists of homes in Zillow
✓ Display free photos in bulk from Unsplash
... and import any other public web data. The sky’s the limit!
✓ High volume - use the function hundreds of times per sheet
✓ Flexible - use CSS selectors or XPath queries to define data captures
✓ Native caching - stores results to prevent constant recalculations
✓ Localization - fetch results displayed in other countries via our built-in proxies
✓ Extras - stack results, use regular expressions to extract/replace data, and more!
How does ImportFromWeb compare to ImportXML, ImportHTML, ImportFeed, and ImportData?
✓ ImportFromWeb offers more features and flexibility compared to its native counterparts. ImportFromWeb can scale up with larger web scraping projects, and supports most websites with ease.
Many users of importJSON, Supermetrics, SheetGo, Google Analytics, Autocrat and Power Tools already love our scraper!
Read more at https://nodatanobusiness.com/importfromweb/
Import From Web, among the best add-ons for Google Sheets