Import datafrom any
websitethrough
a simple Google
Sheets function

Import in real time, cross sources, make powerful dashboards,
…all within the spreadsheet.
A must have for all Data, Marketing, e-Commerce, Financial analysts

FREE INSTALL

Start web scraping
in Google Sheets in minutes


Our users rate ImportFromWeb 4.6/5
in the G Suite Marketplace


Advanced web scraping features – right in Google Sheets!

  • Works flawlessly with most websites
    Under the hood, the function will find the best server from all around the world to load the toughest pages.
  • Scrape pages loaded with JavaScript
    If needed, it can run a browser in our servers to render the page and scrape elements that only show up with a real navigation.
  • High volume of requests per sheet
    Use the function hundreds of times per spreadsheet.
  • It uses a smart and customizable cache system so you keep your data for hours or days.
  • Use CSS selectors or XPaths to find elements on the page.
    CSS selectors is so easy to learn, but XPath is so powerful… ImportFromWeb supports both!
  • Choose your country
    You can query a website from many different places. Super useful to import local content or compare what a page displays in various countries.
  • Stack results of multiple search pages in one list
  • Optional regular expressions manipulations
    Uses the power of regular expressions in order to extract or replace specific parts of texts. It helps you sanitize your data for further analysis.

Sample use cases

Search Engine Optimization

  • Scrape Google search results
  • Scrape Google search suggestions

Ecommerce

  • Scrape search results from Amazon and other sites
  • Scrape product prices, reviews, and descriptions

Competitor Research

  • Scrape job listings from Glassdoor and other sites
  • Scrape latest articles and posts
  • Scrape competitor pricing and keywords

Reputation Management

  • Monitor follower counts on YouTube, Instagram, etc.
  • Scrape reviews for companies from Trustpilot and other sites

And Much More!

  • Check status of deliveries
  • Scrape local business details for lead generation

An alternative to ImportXML

ImportFromWeb is an evolution of the native Google Sheets function ImportXML, designed to be a much more powerful and reliable alternative.

ImportXMLImportFromWeb
Often buggy when it is called more than a dozen times in a spreadsheet.
Works flawlessly with hundreds of formulas per sheet.
The more formulas, the slower it gets.It’s lightning quick!
Refreshes at any change in the spreadsheet.Caches the data on demand, so it doesn’t recalculate all the formulas at any change.
Doesn’t support many websites.We use proxies and emulate browsers to maximize compatibility with complex websites.
Very basic, no advanced options.Many options available for powerful web scraping in Google Sheets: country codes, regular expressions, base selectors, and more.
Requires a knowledge of XPath.Works with CSS selectors or XPaths.
CSS selector is within reach to anyone with basic HTML knowledge.