Glonce

Microsoft Excel breaks the one-cell-one-value rule with Lists and Arrays

productsThe Glonce editorsThe Register🔥66Glonce rating66Impact65Novelty78Relevance58Surprise58Players72Credibility87
Microsoft Excel breaks the one-cell-one-value rule with Lists and Arrays

Microsoft has introduced new Excel features called Lists, Arrays in Cells and Nested Arrays that let a single cell hold more than one value, something Excel has never allowed in its roughly 40-year history. The features were announced by Jake Armstrong, senior product manager for Excel, in a LinkedIn post and an accompanying blog post. "One of the oldest rules of spreadsheets: one cell, one value," Armstrong wrote. "No longer!" He explained the change using the example of a project with multiple owners: previously, users needed separate columns, helper tables, or a single cell packed with text like "Carlos, Henrietta, Jacob" to represent that. With Lists, those values can stay together in one cell while each item remains individually usable for filtering, calculations, and analysis, keeping project owners linked to their project. Armstrong also described further uses for arrays in cells and nested arrays to expand what a spreadsheet can represent. The capability is currently available only as an opt-in preview in the Windows and Mac Beta Channels, and Armstrong cautioned that it is a preview feature that should not be used in important workbooks until it reaches general availability. Commenters on his LinkedIn post raised concerns that the change could break things and make business logic harder to audit because it becomes less visible. The Register also notes practical complications: external software libraries such as openpyxl, pandas, and calamine expect a cell's value to be a single string, number, boolean, or date, and may need updates to handle the new data type, though Microsoft has not yet published how Lists, Arrays in Cells, and Nested Arrays will be represented in .xlsx XML. Applications that import Excel data without any concept of multi-value cells, including CSV export, Google Sheets, LibreOffice, and older Excel builds, face the same issue. Excel users themselves may need to flatten lists and arrays to keep them working with existing features like PivotTables until those features are updated to handle the new cell structure.

Key facts

  • Microsoft is previewing Lists, Arrays in Cells and Nested Arrays, letting one Excel cell hold multiple values for the first time in the spreadsheet's roughly 40-year history
  • Jake Armstrong, senior product manager for Excel, announced the features on LinkedIn and in a blog post, illustrating them with a project-owners example
  • The capability is opt-in and available only in the Windows and Mac Beta Channels; Armstrong says it should not be used in important workbooks before general availability
  • LinkedIn commenters warned the change could break things and hinder auditability by making business logic less visible
  • Libraries like openpyxl, pandas and calamine, plus tools such as CSV export, Google Sheets, LibreOffice and older Excel builds, may need updates since Microsoft has not published how the new cell types map to .xlsx XML

Why it matters

Excel has enforced a strict one-cell-one-value rule since its creation, and workarounds like helper columns or comma-packed text cells have shaped how spreadsheets are built for decades. Letting a cell hold a list or an array natively is a structural change to that model, not just a new formula or ribbon button.

Who it affects

Excel users on Windows and Mac who opt into the Beta Channel can try the features now. More broadly, it affects anyone who builds tools around Excel files: developers of libraries such as openpyxl, pandas and calamine, and applications that import Excel data, including CSV export, Google Sheets, LibreOffice and older Excel builds, none of which currently have a concept of multi-value cells.

How to use it

Lists, Arrays in Cells and Nested Arrays are available only as an opt-in preview in the Windows and Mac Beta Channels. Jake Armstrong's example shows Lists used to keep multiple project owners in one cell while each name stays individually available for filtering, calculations and analysis. Armstrong himself cautions that this is preview software and should not be used in important workbooks until it reaches general availability.

How solid is it

The account rests on Armstrong's own LinkedIn post and blog post announcing the features, plus reactions from commenters on that post, so the description of what the feature does and Microsoft's own caveats are well sourced. What is not yet known, because Microsoft has not published it, is how these new cell types will be represented in .xlsx file format, which leaves open how smoothly other tools will adapt.

Risks and caveats

Several LinkedIn commenters flagged that multi-value cells could break existing workflows and make business logic less visible, hurting auditability. External libraries that assume a cell's value is a single string, number, boolean or date may need updates to handle the new data type once Microsoft documents the underlying representation. Tools and formats without any concept of multi-value cells, such as CSV export, Google Sheets, LibreOffice, and older Excel builds, are affected the same way, and features like PivotTables may require lists and arrays to be flattened until they are adjusted to the new cell structure.

“One of the oldest rules of spreadsheets: one cell, one value. No longer!”

— Jake Armstrong, senior product manager for Excel