There's all kinds of goodness in this post, and in the This is DaveJ website generally. This post shows how you can use Google Sheets to extract data from web pages and organize it in a spreadsheet. The secret is the =IMPORTHTML and =IMPORTXML function in Sheets. It makes me think of what it will be like when all applications have something like that. There are also ways to import JSON into Sheets. This is just the tip of the iceberg. Dave Johnson has written a ton of really useful leading-edge tutorials. If you like messing around with this stuff, don't miss this site.
Today: 2 Total: 15 [Direct link] [Share]
