Scraping a webpage table with a Google Drive spreadsheet:
- The address or URL in quotation marks.
- What you want to scrape – a table or list – in quotation marks.
- Which one you want to scrape.
=ImportHtml("URL","query",index)
A FIFA webpage that publishes information on football agents in Cyprus
Formula for the first table on the page:
=ImportHtml(“http://www.fifa.com/aboutfifa/organisation/footballgovernance/playeragents/association=cyp.html”,”table”,1)
=ImportHtml("goo.gl/F6iOMd","table",1)