IMPORTFROMWEB is the easiest way to start scraping data from any website. Find out how you can start filling your new blank sheet
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
Importing data is as easy as typing
=IMPORTFROMWEB([the url you want to search], [an XPath to describe the content you want to import])
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.