ImportFromWeb extracts web data with Google Sheets™ using a simple function. It's like ImportXML but on steroids 💥
วันที่อัปเดตข้อมูล:20 กันยายน 2567
ใช้งานได้กับ
248K+
ภาพรวม
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
ดูข้อมูลส่วนตัว ซึ่งรวมถึงข้อมูลส่วนตัวใดๆ ที่คุณได้เผยแพร่ต่อสาธารณะด้วย
Loading
ค้นหา
ล้างการค้นหา
ปิดการค้นหา
แอป Google
เมนูหลัก