UPDATED 17:15 EDT / OCTOBER 29 2020

BIG DATA

Microsoft adds ‘third dimension’ to Excel with custom data types

Microsoft Corp. today introduced new data management features for Excel that will make it easier to work with spreadsheets containing complex, regularly updated information.

For most of its history, Excel only allowed users to fill spreadsheets with text, numbers and formulas. Microsoft last year took an initial step toward changing that by adding support for two additional data types. It’s now taking the idea further by introducing the ability for users to import any piece of data into their spreadsheets, however complicated, and define custom data types to manage this information.

The biggest benefit for users will be increased convenience. Previously, if a business analyst sought to import a customer’s shopping history and product reviews into Excel, they would have had to place the individual data points in separate spreadsheet cells. Now, they can compress all of this information into just a single cell by defining a “customer” data type. Clicking the cell brings up the full details in a pop-up panel.

The feature will simplify data projects by removing the need to reformat complex records into Excel’s previous two-dimensional spreadsheet structure. Storing data across fewer cells should also reduce copy and paste errors, resulting in better information accuracy. 

“Up to this point, the Excel grid has been flat: it’s two dimensional,” Brian Jones, the group program manager for Excel, wrote in a blog post today. “You can lay out numbers, text, and formulas across the flexible grid, and people have built amazing things with those capabilities. Not all data is flat though, and forcing data into that 2D structure has its limits. With Data Types we’ve added a third dimension to what you can build with Excel.”

Another key feature of the custom data types is that they refresh when a newer version of a record is available. Using Excel’s Power Query feature, workers can sync a cell containing a custom data type to an external source such as a database or customer relationship management system. There’s also an integration with Microsoft’s Power BI that makes it possible to pull information from the business intelligence tool. 

“A single cell value can have a live connected set of information you can quickly pull into your decision-making process, without needing to constantly go back to the original source to find more information,” Microsoft’s Brian Jones detailed.

The extra versatility the update brings to Excel could help Microsoft up the ante against the startups that have emerged in recent years to challenge its spreadsheet dominance. Airtable Inc., one of the highest-profile contenders, recently raised a $185 million round at a nearly $2.6 billion valuation. One of Airtable’s core features is that it allows users to place not only numbers and text in spreadsheet fields but also other types of information, a feature Excel can now more directly match. 

Image: Microsoft

A message from John Furrier, co-founder of SiliconANGLE:

Support our open free content by sharing and engaging with our content and community.

Join theCUBE Alumni Trust Network

Where Technology Leaders Connect, Share Intelligence & Create Opportunities

11.4k+  
CUBE Alumni Network
C-level and Technical
Domain Experts
15M+ 
theCUBE
Viewers
Connect with 11,413+ industry leaders from our network of tech and business leaders forming a unique trusted network effect.

SiliconANGLE Media is a recognized leader in digital media innovation serving innovative audiences and brands, bringing together cutting-edge technology, influential content, strategic insights and real-time audience engagement. As the parent company of SiliconANGLE, theCUBE Network, theCUBE Research, CUBE365, theCUBE AI and theCUBE SuperStudios — such as those established in Silicon Valley and the New York Stock Exchange (NYSE) — SiliconANGLE Media operates at the intersection of media, technology, and AI. .

Founded by tech visionaries John Furrier and Dave Vellante, SiliconANGLE Media has built a powerful ecosystem of industry-leading digital media brands, with a reach of 15+ million elite tech professionals. The company’s new, proprietary theCUBE AI Video cloud is breaking ground in audience interaction, leveraging theCUBEai.com neural network to help technology companies make data-driven decisions and stay at the forefront of industry conversations.