For decades, it’s been possible to import data into spreadsheets from elsewhere. Excel supports many data sources, from basic stuff like CSV, ODBC and OLE DB, to more specific and advanced knowledge of particular data sources and types.
A recent tweet from @msexcel showed a simple video on how to grab data from a website – highlighting a capability that’s been in Excel for years but has been refreshed and made a lot easier to use.
If you want to revert to using the old data import methods, you can either enable the Legacy import wizards in Options (File > Options > Data > Show legacy data import wizards), or just type Legacy into the Search / Tell Me box in Excel, and see the available actions from there.
Another cool Office 365 data feature is to use Data Types. Enter your data in a column, select it and choose the appropriate Data Type – let’s use Stocks as an example.
Once you’ve tagged the source data, clicking on the icon to the left of the data point will show a pop up with the background detail, or you can reference the fields within formulae to display or manipulate the data values.
Each data source presents a number of fields that can be discovered and selected through autocomplete in a formula, and the values can be refreshed easily.
See more detail on using the Stock quotes functionality, here.