App Icon
NoDataNoBusiness
•  33,013
Overview
ImportFromWeb imports data from any website into your spreadsheet using a simple function. It's like ImportXML but on steroids 💥
Write =IMPORTFROMWEB( url, path_to_content ) and retrieve all the data in a clean table
...

✓ Use the function hundreds of times per spreadsheet
✓ Supports JavaScript-rendered pages
✓ Uses a smart, customizable cache system to store results and prevent updating on every change
✓ Modify the returned results using regular expressions
✓ Stack results of multiple search pages into a single list

Fed up with ImportXML limitations? Try ImportFromWeb!

Overview
A simple function that imports content from any website directly into your Google Sheet in real time. It’s web scraping directly in Google Sheets… no coding knowledge required!

▶︎ INSTALL IT to start your FREE trial with 500 requests to use in 2 weeks ◀
(No payment information needed)

Want more? Check out our plans: https://nodatanobusiness.com/importfromweb/pricing/

ImportFromWeb helps you to:
✓ Scrape search results in Amazon, Google, YouTube, Reddit, and more
✓ Analyze website links for SEO
✓ Gather data from Wikipedia pages
✓ Follow stock market trends
✓ Extract lists of homes in Zillow
✓ Display free photos in bulk from Unsplash

... and import any other public web data. The sky’s the limit!

Features:
✓ High volume - use the function hundreds of times per sheet
✓ High compatibility - supports JavaScript-rendered sites
✓ Flexible - use CSS selectors or XPath queries to define data captures
✓ Native caching - stores results to prevent constant recalculations
✓ Localization - fetch results displayed in other countries via our built-in proxies
✓ Extras - stack results, use regular expressions to extract/replace data, and more!

How does ImportFromWeb compare to ImportXML, ImportHTML, ImportFeed, and ImportData?
✓ The three native functions only work under certain conditions. For example, they cannot load Javascript-powered websites, and have usage limitations. 
✓  ImportFromWeb offers more features and flexibility compared to its native counterparts. ImportFromWeb can scale up with larger web scraping projects, and supports most websites with ease.

Many users of importJSON, Supermetrics, SheetGo, Google Analytics, Autocrat and Power Tools already love our scraper!



Read more at https://nodatanobusiness.com/importfromweb/

--------------
Import From Web, among the best add-ons for Google Sheets
Reviews
Language:
Sort by:
Profile Picture
Shiva A
April 6, 2021
It's ok for very basic usage. It only overcomes some errors occur using ImportXML. There is no proper documentation explaining whats included in free vs paid versions. Free version does not seem to cache the data.
Is this review helpful?
Yes
No
Profile Picture
Matthieu PINAULDT
March 15, 2021
ImportFromWeb founder here! After an important fire at our server provider's premises, I am happy to let you know that our add-on is working again. Thank you for your patience
Is this review helpful?
Yes
No
Profile Pciture
Charles Valkyrie
March 26, 2021
I still only get "Loading" error on mine.
Profile Picture
James Jara
March 7, 2021
u need to pay if you really want to use it "well"
Is this review helpful?
Yes
No
Profile Picture
Michael Nace
March 4, 2021
This add-on is helpful if you're running into the problem of exceeding the maximum size of a URL that you're trying to IMPORTXML from. From my experience, it allows you to get around that issue, which in my case was huge. Yes, it's a paid service, but if the feed you're trying to import is too big for Google Sheets to accept, this might be the only option.
Is this review helpful?
Yes
No
Profile Picture
Thomas
February 24, 2021
I don't quite understand this addon. It's the same as ImportXML but won't work after a few days if you don't pay a (very) expensive monthly subscription! Just uninstalled. I'll stick to the standard importXML, it sucks and works randomly but at least it's free.
Is this review helpful?
Yes
No
Profile Pciture
Matthieu PINAULDT
February 25, 2021
Hi Thomas, importXML fails with many websites and when it works, its use can be very frustrating. ImportFromWeb uses advanced technologies to perform better in most situations. For instance, it works with websites that load Javascript. Not to mention the numerous options that you may need (load page from a certain country, update data automatically, extract several pages of search results, ...)
Profile Picture
Chee Vue
February 16, 2021
LOL
Is this review helpful?
Yes
No
Profile Picture
ROBIN HOOD COACHING ACADEMY
February 8, 2021
Hi, I'm brand new to this add on, and the opposite end to a geek. I'm struggling to get a list of emails and contacts etc from websites to Google sheets, for example a full list of welsh gp,s from the NHS site to Google sheets. Please help point me in the right way. Many thanks Mark.
Is this review helpful?
Yes
No
Profile Picture
sharbin1181
January 24, 2021
I've only used the free version but it's amazing. Super fast and easy to use. Scraping websites has never been easier!
Is this review helpful?
Yes
No
Profile Picture
Michael Mountain
December 30, 2020
Using the free version right now to help import data for my Investments. Wonderful will be upgrading soon to a paid version for more imports. Absolutely "MUST HAVE ADD ON"!!!
Is this review helpful?
Yes
No
Profile Picture
Max Brawer
December 28, 2020
Just amazing what this can pull off! Scrapes sites that others say are unscrapable
Is this review helpful?
Yes
No
1-10 of 52
Additional information
NoDataNoBusiness
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu