Excel cells can now hold lists and nested arrays
Microsoft has introduced preview features that let Excel cells contain multiple values, including lists, arrays in cells, and nested arrays. The capability is opt-in and currently limited to Windows and Mac Beta Channels. Commenters raised concerns about potential breakage and reduced auditability, while external libraries may need updates to handle the new data types.
Microsoft's preview lets Excel cells hold several values, including lists, in-cell arrays, and nested arrays. The feature is optional and limited to Windows and Mac Beta Channels. Product manager Jake Armstrong announced it on LinkedIn, noting spreadsheets have long assumed one value per cell. A stated use case keeps multiple project owners in one cell while allowing filtering, calculations, and analysis.
Armstrong cautions against using the preview in critical workbooks before general release. Commenters worry about breakage and weaker audit trails. Libraries such as openpyxl, pandas, and calamine may need changes because the .xlsx XML representation is not yet documented. CSV export, Google Sheets, LibreOffice, and older Excel versions lack multi-value support, and PivotTables may require flattening until updated.
Excel is widely used in finance, administration, research, and data work. Multi-value cells could make some models more compact and expressive, but may also complicate auditing, validation, and migration between tools. Analysts, auditors, spreadsheet developers, and downstream software users may need new practices or updates. Because the feature is opt-in and preview-only, broad disruption is unlikely soon, though organizations may want to track interoperability and training needs.