IMPORTFROMWEB is the easiest way to start scraping data from any website. Find out how you can start filling your new blank sheet

Check that the add-on is enabled in your current spreadsheet

In your spreadsheet, go to Add-ons > Manage add-ons

  • If ImportFromWeb is displayed in the list, check that it has been added to your document by pushing Manage > Use in this document
  • If ImportFromWeb is not in the list, go to the menu Add-ons > Get add-ons and search for ImportFromWeb

Create your first function

Importing data is as easy as typing

=IMPORTFROMWEB([the url you want to search], [an XPath to describe the content you want to import])


=IMPORTFROMWEB("", "//td[@class='ratingColumn']")
None GIF

Open the ImportFromWeb sidebar

In the Google Sheets menu, go to
Add-ons ▶︎ ImportFromWeb | Easy Web Scraping ▶︎ 🛠 Open sidebar.

It will load a sidebar on the right side giving you a lot of support to create your function and discover all the capabilities.