Import data
from anywebsite
into aGoogle Sheets
table
FREE INSTALL
Start web scraping in Google Sheets in minutes
Our users rate ImportFromWeb 4.5/5
in the G Suite Marketplace
Advanced web scraping features – right in Google Sheets!
- High volume of requests per sheet
Use the function hundreds of times per spreadsheet. - Scrape pages loaded with JavaScript
Our powerful engine allows to return elements from JavaScript-rendered websites. - Works flawlessly with many websites
A pool of proxies from all around the world allows ImportFromWeb to load most websites. - Stores results so it doesn’t recalculate at any change
Unlike ImportXML, it doesn’t update the cells at any edition of the spreadsheet. Instead it uses a smart and customizable cache system so you keep 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.
| 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. |