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.
- Set up automatic updates by hour, day, or week
- 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. - Parse in-cell HTML code with no limitations
- Top-notch customer service. We want you to make the most of the function and we’ll go out of our way for that!
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.
| ImportXML | ImportFromWeb |
| 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. |