Microsoft has ended a 40-year-old spreadsheet convention by allowing multiple values to live in a single Excel cell. The new capabilities, announced by senior product manager Jake Armstrong, include Lists, Arrays in Cells, and Nested Arrays. For now the features are opt-in and limited to the Beta Channel on Windows and Mac, and Microsoft advises against using them in important workbooks until general availability.
Armstrong argues the change reduces the need for separate columns, helper tables, or comma-separated text when a project has multiple owners. Instead, values like "Carlos, Henrietta, Jacob" can stay together in one cell while each item remains individually accessible for filtering and calculations. He also points to arrays and nested arrays as a way to represent richer information in a spreadsheet.
Not everyone is convinced. Commenters on Armstrong's post raised concerns about breakage and auditability, noting that business logic could become less visible when multiple values are packed into one cell. External libraries that expect cell.value to return a simple string, number, boolean, or date may need updates, but Microsoft has not yet published how the new data types will be represented in .xlsx XML. Tools like openpyxl, pandas, and calamine, as well as CSV export, Google Sheets, LibreOffice, and older Excel builds, could all be affected. Until existing features are adjusted, users may also need to flatten lists and arrays to make multi-value cells work with PivotTables.