Microsoft has altered a foundational principle of Excel by permitting multiple values to reside within a single cell. The company announced new features — Lists, Arrays in Cells, and Nested Arrays — that allow one cell to contain several distinct data points without requiring separate columns or concatenated text.

Jake Armstrong, senior product manager for Excel, stated in a LinkedIn post that the change departs from the longstanding rule of "one cell, one value." He described the update as enabling project teams to maintain multiple owners within a single cell while still supporting individual item processing for filtering, calculations, and analysis.

The functionality is currently accessible only through Excel for Windows and Mac in Beta Channels and requires explicit user activation. Microsoft has designated the feature as a preview and advises against its use in critical workbooks until a full release.

Commenters on Armstrong’s post raised concerns about potential disruptions to auditability and data processing workflows. Applications relying on predictable cell data types — such as openpyxl, pandas, and calamine — may require updates to interpret the new multi-value structures. Similarly, tools that process Excel exports, including CSV generators, Google Sheets, LibreOffice, and legacy Excel versions, might encounter compatibility issues.

Users may need to adjust existing features like PivotTables to accommodate the revised cell format, at least temporarily. Microsoft has not yet detailed how the new data structures will be encoded in the .xlsx XML standard, leaving some integration challenges unresolved.