Google Sheets and Data

This video looks at the basic =inserthtml formula to link to a web site and look for a table or list and import it into your spreadsheet

This little video is an excellent overview of using some of the built in tools within Google Sheets to sort and analyse columns of data. Its marketing oriented, but the tools apply to all sorts of data and use

So how do your take this a little further and make new bespoke formula, this short video will help

This very excellent video looks at scraping very specific data from a web table and linking it into a google spreadsheet

A very similar video the the basic =inserthtml video , but this time go to about 6mins 30n secs into the video and watch the bit on Tabula to scrape data from pdf docs, it seems to create a separate page and links to it via tabula