Microsoft Excel adds in-cell lists and arrays
Microsoft has released preview support for lists, arrays in cells, and nested arrays to Microsoft Excel for Windows and Mac Beta Channel users, breaking the software's historic constraint of one value per cell. Users can store multiple values in a single cell, keep array outputs contained within 1x1 cells, and evaluate nested arrays supported by new helper functions including FLATTEN, HAS, HASANY, and HASALL.
This is the most profound architectural change to Excel's calculation model since dynamic arrays, effectively turning the flat 2D spreadsheet grid into a semi-structured document model while guaranteeing a messy multi-year compatibility transition.
* **Semi-structured data in cells**: Storing arrays and lists in individual cells eliminates the sprawl of helper columns and volatile spill ranges, allowing spreadsheets to cleanly mirror nested API responses and hierarchical business data.
* **Functional programming parity**: The addition of `FLATTEN`, `HAS`, `HASANY`, and `HASALL` continues Excel's quiet evolution into a powerful functional programming environment, reducing the need for Python or VBA in mid-tier data transformations.
* **Ecosystem fragmentation**: Because core features like Power Query, PivotTables, Charts, and Data Validation cannot yet ingest array-valued cells, early adopters will face frustrating integration bottlenecks until the rest of the Microsoft 365 stack catches up.
* **Workbook compatibility friction**: Requiring "Compatibility Version 3" prevents legacy formula calculation breaks, but sharing these workbooks across organizations running older Excel builds or Excel Web will inevitably cause calculation mismatches.
DISCOVERED
1h ago
2026-09-26
PUBLISHED
5h ago
2026-09-25
RELEVANCE
AUTHOR
luispa