ImportFromWeb extracts web data with Google Sheets™ using a simple function. It's like ImportXML but on steroids 💥
정보 업데이트:2024년 9월 20일
호환 기기:
24만+
개요
Easy Web Scraping with Google Sheets™
Simply write =IMPORTFROMWEB( url, path_to_data ) and import any data from any website!

ImportFromWeb offers a simple function that extracts data from any website directly into your spreadsheets in real time. NO TECHNICAL KNOWLEDGE REQUIRED!

Why choose ImportFromWeb?

✓  A powerful alternative to ImportXML, ImportHTML, ImportFeed, and ImportData.
✓  Scrapes JavaScript-powered websites and most other sites with ease.
✓  Supports up to 50 URLs per function with unlimited data points.


Perfect for importing real-time data from:

Top Marketplaces and e-commerce websites (Amazon, Walmart, Flipkart, eBay, Shopee, Etsy, Target, Noon, Home Depot…), Google Search™, Google Maps™, Instagram, YouTube™, and many more!



📌 HOW IT WORKS

All you have to do is to describe the URL and the data path and then call the =IMPORTFROMWEB() function

1- Choose the URL of the webpage you want to scrape
2- Define the Data Path: Use XPath, CSS selectors, or our built-in selectors for popular platforms
3- Enter the formula =IMPORTFROMWEB( url, path_to_data )

Here are 2 nice examples : 
✓ Scrape product data from Amazon typing =IMPORTFROMWEB(“https://www.amazon.com/dp/B09LNCVCKW”, "title, sale_price,buybox_winner")
✓ Scrape Google Search™ results typing =IMPORTFROMGOOGLE(“keyword”,  "title,body,link”)


📌 MAIN FEATURES

✓ Easy onboarding thanks to a catalog of ready-to-use templates
✓ Flexible - works with CSS selectors or XPath queries to describe the data to be captured OR with built-in selectors for major websites (Amazon, Google Search™, Google Maps™, Walmart, YouTube, Instagram…)
✓ High volume - supports thousands of data points per spreadsheet
✓ Scalable - ready to be used hundreds of times per sheet 
✓ High compatibility - scrapes even JavaScript-rendered websites
✓ Powerful - uses proxy rotation to scrape the tough-to-scrape websites
✓ Customizable caching - stores results to prevent constant recalculations
✓ Localization - fetches results displayed in other countries via our built-in proxies
✓ Extras - compatible with regular expressions to extract/replace data
✓ Tries to automatically convert data as numbers and dates when possible 
✓ and much more to come!


📌 POPULAR USE CASES

With Import From Web you can easily :
✓ Amazon & Walmart: Extract prices and ratings for hundreds of products
✓ Market Analysis: Analyze niches and categories on any marketplaces or e-commerce
✓ Google Search™: Analyze SERPs for multiple keywords
✓ Google My Business™: Build prospect lists
✓ Social Media: Track trends and influencers on YouTube™, Instagram, TikTok
✓ Finance: Monitor stock values from Yahoo Finance, Bloomberg, Nasdaq
✓ Crypto: Aggregate data from Binance, Coinbase, CoinMarketCap.
✓ General: Gather data from Wikipedia
... and import any other public web data. The sky’s the limit!

Here are some websites our users love to import data from : Yahoo Finance, Bloomberg, Google Search™, Google Maps™, Amazon, Walmart, Target, Flipkart, Home Depot, Noon, Etsy, eBay, Instagram, Youtube™, LinkedIn, NSE India, Seeking Alpha, Market Watch, Zillow, Coin Market Cap…


📌 PRIVACY

ImportFromWeb is a Google Workspace add-on that has successfully passed Google’s security review. The add-on requires minimal permissions. Your data remains at all times your own property and ImportFromWeb will never transfer nor sell them to 3d parties. 
We will never save the content of your Google Sheets.


📌 PRICING

Try the add-on for free for 1 month with 200 credits. No credit card required!
Then, choose between our plans according to the number of URLs you need to scrape. No risk, we offer a 7-day money back guarantee !
https://nodatanobusiness.com/importfromweb-pricing/


📌 SUPPORT

✓ Have a look at our repository of resources and demos at https://nodatanobusiness.com/resources/importfromweb/
✓ Check out our ready-to-use templates for the most popular platforms at https://nodatanobusiness.com/platforms/
✓ Browse our tutorials on our Youtube channel 
✓ Contact us and we’ll help you to get the most of our add-on! support@nodatanobusiness.com


--------------

Many users of ImportJSON, Coefficient, Supermetrics, Mixed Analytics, KPI bees, DataConnector, SheetGo, Google Analytics, Autocrat and Power Tools already love our scraper.

ImportFromWeb, among the best add-ons for Google Sheets™!

Read more at https://nodatanobusiness.com/
추가정보
가격무료 체험
개인정보처리방침
ImportFromWeb | Web scraping in Google Sheets™에서 아래에 표시된 권한을 요청합니다. 자세히 알아보기
ImportFromWeb | Web scraping in Google Sheets™에서 Google 계정에 액세스해야 함
이렇게 하면 ImportFromWeb | Web scraping in Google Sheets™에서 다음 작업을 할 수 있습니다.
애플리케이션 설치 시 사용한 스프레드시트 조회 및 관리
Google 애플리케이션 내 메시지 및 사이드바에 외부 웹 콘텐츠를 표시하고 실행합니다.
외부 서비스에 연결
부재중에 이 애플리케이션을 실행하도록 허용
기본 Google 계정의 이메일 주소 확인
개인정보(공개로 설정한 개인정보 포함) 보기
리뷰
언어:
정렬 기준:
Google에서는 리뷰나 평점을 확인하지 않습니다. 리뷰에 대해 자세히 알아보기
Profile Picture
DG
2024년 9월 19일
This is one of the best services I've ever used.
이 리뷰가 도움이 되었나요?
아니요
Profile Picture
솟소한공간
2020년 7월 11일
This is very nice tool! only thing is that when parsing other language, the parsed data is broken like this �����ý��� I parsed Korean. Is there a way to use utf-8 method for this?
이 리뷰가 도움이 되었나요?
아니요
Profile Picture
ImportFromWeb | Web scraping in Google Sheets™ 사용자
2019년 5월 30일
arrayformula+importxml. wonderful!
이 리뷰가 도움이 되었나요?
아니요
1-3 / 3
검색
검색어 지우기
검색 닫기
Google 앱
기본 메뉴