# Microsoft Breaks 40-Year Rule: Excel Now Supports Multi-Value Cells > Discover how Excel multi-value cells allow Lists and Nested Arrays in a single box, and learn how to access the Beta update before it breaks your data pipelines. - Canonical URL: https://coreiten.com/en/article/microsoft-breaks-40-year-rule-excel-now-supports-multi-value-cells - Language: en - Section: Excel - Author: Sami - Published: 2026-09-26T08:01:43+03:00 - Modified: 2026-09-26T08:01:43+03:00 - Publisher: CoreITen (https://coreiten.com) - Keywords: Excel multi-value cells, Microsoft Excel Beta, Nested Arrays, openpyxl, pandas, PivotTables ## Summary Microsoft is fundamentally changing Excel by introducing multi-value cells, breaking a 40-year rule and allowing users to store multiple items in a single cell. - Microsoft introduces three new data structures directly into the grid: Lists, Arrays in Cells, and Nested Arrays, according to Senior Product Manager Jake Armstrong. - The new feature is currently restricted to the Microsoft Excel for Windows and Mac Beta Channels and requires users to actively opt in. - Python scripts using standard libraries like openpyxl, pandas, and calamine may crash when encountering nested arrays instead of standard floats. - Microsoft has not yet published how these multi-value cells will be represented in the underlying .xlsx XML schema, creating interoperability friction for external applications. **Why it matters:** This architectural shift turns Excel into a lightweight relational database, but it risks breaking legacy tools, third-party libraries, and data engineering pipelines until the broader ecosystem adapts. --- For 40 years, spreadsheet users have been forced to rely on clunky helper columns or comma-separated text strings just to fit multiple names or data points into a single row. That era is officially over as Microsoft introduces Excel multi-value cells, fundamentally rewriting the oldest rule of data entry: one cell, one value. Data analysts and project managers who regularly wrangle complex datasets can now keep related items grouped together without breaking their filtering or calculation workflows. The update introduces three distinct data structures directly into the spreadsheet grid: Lists, Arrays in Cells, and Nested Arrays. Traditionally, assigning multiple owners to a single project required packing text like "Carlos, Henrietta, Jacob" into a single box, rendering the data useless for individual sorting. With the new architecture, project owners stay connected to their specific row while remaining fully available for independent analysis. > One of the oldest rules of spreadsheets: one cell, one value. No longer! > > - Jake Armstrong, Senior Product Manager, Microsoft While the visual organization improves, the underlying architecture shift presents immediate challenges for existing spreadsheet features. Users will likely need to flatten these new lists and arrays to make them compatible with legacy tools like PivotTables, at least until Microsoft updates those features to natively understand the multi-tenant cell structure. ### How to Access Excel Multi-Value Cells Because this fundamental change alters how the software processes data, Microsoft is rolling it out cautiously. Users who want to test the new capabilities must meet specific availability requirements before deploying them in active workflows. - **Channel Requirement:** The feature is currently restricted to the Microsoft Excel for Windows and Mac Beta Channels. - **Opt-In Activation:** The multi-value capability is not enabled by default; users must actively opt in through the Beta settings. - **Production Warning:** Microsoft explicitly warns against using these preview features in important or production workbooks until general availability is announced. ### The Hidden Cost of Database-Style Spreadsheets While packing arrays into a single cell makes visual organization cleaner, it introduces a massive headache for data engineering pipelines. External software libraries that expect a cell to return a simple string, number, boolean, or date are entirely unprepared for this structural shift. Python scripts relying on industry-standard libraries like openpyxl, pandas, and calamine will likely crash when they encounter a nested array instead of a standard float. Furthermore, Microsoft has not yet published how these multi-value cells will be represented in the underlying.xlsx XML schema. This creates a dangerous blind spot for applications that import spreadsheet data, including CSV exports, Google Sheets, LibreOffice, and older Excel builds. Microsoft is effectively turning its flagship software into a lightweight relational database, but until the broader data ecosystem updates to handle multi-tenant cells, enterprise users should expect significant interoperability friction. ## Sources - [theregister.com](https://www.theregister.com/applications/2026/09/25/microsoft-cells-out-crams-multiple-values-into-excel-boxes/5299294) ## Related topics - [PivotTables](https://coreiten.com/en/topic/pivottables)