Microsoft cells out, crams multiple values into Excel boxes

Microsoft has extended the capabilities of Excel cells beyond the conventional single-value limit, allowing multiple values to coexist within a single cell. Senior product manager Jake Armstrong announced this feature update on LinkedIn, highlighting new functionalities like Lists, Arrays in Cells, and Nested Arrays in Excel. Currently, this feature is exclusive to the Windows and Mac Beta Channels of Microsoft Excel and is opt-in.

The introduction of lists in cells aims to streamline the handling of datasets with multiple owners. Traditionally, this required separate columns or helper tables, but lists enable users to maintain values together in one cell while still allowing individual item manipulation. This feature preserves project ownership while enhancing data accessibility for filtering, calculations, and analysis.

Armstrong noted that nested arrays in cells could expand the range of information representable in Excel spreadsheets. However, this preview feature should not be used in critical workbooks until general availability. Critics argue that multi-value cells may disrupt auditability and complicate business logic visibility. External software libraries, such as openpyxl, pandas, and calamine, may necessitate updates to accommodate the new data type, as they typically expect cell.value to return a string, number, boolean, or date.

Additionally, applications like CSV export, Google Sheets, LibreOffice, and older Excel versions lack built-in support for multi-value cells, requiring users to flatten lists and arrays to maintain compatibility with existing features like PivotTables.