Microsoft tests new Excel feature allowing multiple data types in a single cell, signalling a shift towards structured data handling

Microsoft is experimenting with a major update to Excel that enables cells to contain multiple values and complex arrays, moving away from traditional text-based data storage and paving the way for more resilient, formula-aware spreadsheets.

Microsoft is testing a substantial change to Excel that moves the programme closer to handling richer, more structured data inside a single cell. Instead of treating every entry as plain text, the new approach allows one cell to hold multiple values as a List or as an array, with each item still available for filtering, editing and calculation. That marks a notable shift from the long-standing pattern of packing data together as text and later splitting it back out again. Microsoft Support’s existing guidance on combining and distributing cell contents shows how much of Excel’s current workflow still depends on splitting and joining text, which the new feature is designed to reduce.

The update goes further by letting Excel store arrays of almost any size or shape directly in a cell, including nested arrays. In practical terms, that means a single formula can return a more complex structure without forcing the result to spill awkwardly across the sheet or fail with a calculation error. Microsoft’s own support material on data tables, aggregation and basic calculation features shows how central formula-driven analysis already is in Excel, and the new array support appears intended to make those workflows more resilient when results are more complicated than a simple list or number.

To support the new data model, Microsoft is adding four functions: FLATTEN, HAS, HASANY and HASALL. FLATTEN removes layers of nesting, while the other three check whether specific values are present within an array. That fits with Excel’s broader function set, including existing IS functions that return TRUE or FALSE and established tools such as AGGREGATE that operate over lists or databases. The direction is clear: Excel is beginning to treat cells less as flat containers and more as lightweight data structures.

There are, however, important limits. Nested array calculations generally require Compatibility Version 3, which means some existing formula behaviour may change. Microsoft also says that several familiar features still have limited or no support for these new cell types, including PivotTables, Power Query, charts, data validation, conditional formatting and Find & Replace. The rollout is being staged for Microsoft 365 Insider Beta users on recent Windows and Mac builds, so wider availability is not yet in place. For now, the feature looks like a controlled preview of how Microsoft wants future Excel workbooks to behave: more structured, more formula-aware and less dependent on converting data back and forth between text and cells.