What you need to know
- Microsoft announced that Excel will soon support custom live data types.
- The functionality allows you to import your own data as custom data types.
- These new data types allow you to place structured data within a single cell.
Microsoft announced a major update to Excel that brings the option to create your own data types. These data types can include live information that can greatly expand the functionality and relevance of data within spreadsheets. Excel can also work with Power BI and richly structured data within spreadsheets.
Microsoft shares context about data types in a new post (opens in new tab). Previously, data was "two dimensional," meaning that people could place numbers, text, and formulas within a grid. These types of data can create complex spreadsheets, but they do have limits. Now, Microsoft has added a third dimension to Excel, allowing any cell to include a rich set of structured data. In other words, single cells can now include structured data that can be referenced by other parts of the spreadsheet.
In this context, "rich" means that a single cell can have references to other data types, images, intelligent actions, and a collection of hierarchical data. Microsoft explains the value of this new functionality:
Microsoft shares an example of a spreadsheet that relies on population data for the city of Seattle. You could import a data type for the population of Seattle and then have formulas that utilize that information.
Excel can also work with business data powered by Power BI. You can connect Power BI data in Excel as data types.
People can also have data within Excel transformed into a data type with Power Query. This feature allows you to add information from websites, databases, and files.
Microsoft also announced a partnership with Wolfram, which allows hundreds of new data types to be used within Excel, though this is in preview at the moment.
Power BI data types are available in Excel for Windows for Microsoft 365/Office 365 subscribers that have a Power BI Pro service plan. Power Query data types will roll out over the coming weeks for Microsoft 365/Office 365 subscribers. The Wolfram Alpha data type functionality is available in preview for Office Insiders.
Windows Central Newsletter
Get the best of Windows Central in in your inbox, every day!
Sean Endicott brings nearly a decade of experience covering Microsoft and Windows news to Windows Central. He joined our team in 2017 as an app reviewer and now heads up our day-to-day news coverage. If you have a news tip or an app to review, hit him up at firstname.lastname@example.org (opens in new tab).
Thank you for signing up to Windows Central. You will receive a verification email shortly.
There was a problem. Please refresh the page and try again.