Get started

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

Install this add-on for Free from the G Suite Marketplace

Also available in the Chrome Store

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])

Try

=IMPORTFROMWEB("https://www.imdb.com/chart/boxoffice?ref_=nv_ch_cht", "//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.