Pages

Thursday, July 10, 2014

Import Data from a Web Site Into Your Spreadsheet and Filter the Results

Quite often people will paste data from a site into their spreadsheet (think of game standings, lottery numbers, etc). The importHTML function in Google Sheets can automatically get the latest data from a page and insert it into your spreadsheet, where you can treat it as if it was text you pasted in

Once your content is in your spreadsheet, you can treat it as if it was text you pasted in. You can use it in formulas, sort it, and filter it.