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 Builder

In Google Sheets menu, go to Add-ons > IMPORTFROMWEB >Build function.

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