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.
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. |