In the past few years, Microsoft Begin to add the concept of “data type” in Excel; that is, for example, geographic and real-time inventory data can be obtained from the cloud. Thanks to the cooperation with Wolfram, Excel now has more than 100 data types that can be streamed into spreadsheets. However, you will not be limited to these pre-built data types. Soon, Excel will also allow you to introduce your own data types.
This means you can have a “customer” data type, for example, it can import rich customer data from third-party services into Excel. The channel for this is Power BI (which now allows Excel to extract any data you previously posted here), or the Power Query feature in Microsoft Excel, which allows you to connect to various data sources, including SQL Server, MySQL Such as common databases and PostreSQL, and third-party services such as Teradata and Facebook.
Brian Jones, Microsoft’s product leader in charge of Excel, wrote in today’s announcement: “So far, the Excel grid is flat…two-dimensional.” Numbers, text, and formulas are arranged on the grid, and people have built amazing things with these functions. However, not all data is flat, so forcing data into a 2D structure has limitations. Using data types, we are A third dimension has been added to what can be built using Excel. Now any unit can contain a rich set of structured data in a unit.”
The promise here is that this will make Excel more flexible, and I’m sure many companies will adopt these features. These companies are unlikely to use Airtable or Excel-like tools in the short term, but because each company collects more data than it knows how to process, the demand for data analysis is increasing. This is also a feature currently not provided by Excel competitors, including Google Sheets.