When you think of data types you might be thinking about text, numbers, dates or Boolean values, but these new data types are quite different. We now have multiple data fields inside one cell!

With Excel’s new rich data type feature, this is no longer the case. Or type other field names like Last Trade Time, Previous Close, and Exchange.Since the start of Excel, one cell could only contain one piece of data. For example, type Change in the header row for stocks, and the change in price column will appear. If you're using a table, here's a tip: Type a field name in the header row. For example, for stocks you might pick Price.Ĭlick the Add Column button again to add more fields. Click that button, and then click a field name to extract more information. Select one or more cells with the data type, and the Add Column button will appear. You'll know they're converted if they have this icon for stocks. If Excel finds a match between the text in the cells, and our online sources, it will convert your text to the Stocks data type. With the cells still selected, go to the Data tab, and then click Stocks. Later on, this will make extracting online information easier. For example, type a ticker symbol, company name, or fund name into each cell.Īlthough it's not required, we recommend creating an Excel table. You must also have the English, French, German, Italian, Spanish, or Portuguese editing language added to Office Language Preferences. Note: The Stocks data type is only available to Microsoft 365 accounts or those with a free Microsoft Account.

Download stock quotes into excel