Excel now supports multiple values in a single cell

Microsoft has ushered in a new era for Excel cells, allowing them to hold multiple values simultaneously. This marks a break from the longstanding rule that each cell can only contain a single value, according to Jake Armstrong, a senior product manager for Excel who shared the news on LinkedIn. The company has introduced several new features designed to facilitate this change: Lists, Arrays in Cells, and Nested Arrays in Excel.

These capabilities are currently limited to the Microsoft Excel for Windows and Mac Beta Channels and require opt-in.

Armstrong explained that the new lists in cells feature allows each Excel project to have multiple owners. Previously, users would have to resort to using separate columns, helper tables, or concatenating names like "Carlos, Henrietta, Jacob" into a single cell. Lists enable these values to coexist within one cell while maintaining the ability to work with each item individually.

This capability preserves project ownership while allowing for filtering, calculations, and analysis. Nested arrays take this a step further, expanding the types of information Excel spreadsheets can represent.

While Armstrong is enthusiastic about the potential of multi-value cells, he reminds users that this is a preview feature and should not be employed in crucial workbooks until it achieves general availability. Some users have expressed concerns that this change could disrupt existing systems and hinder auditability by obscuring business logic.

Additionally, external software libraries that anticipate cell.value returning only a string, number, boolean, or date may need updates to accommodate the new data type, which Microsoft has yet to specify. Libraries such as openpyxl, pandas, and calamine, as well as applications like CSV export, Google Sheets, LibreOffice, and older Excel versions, are also affected.

Users of Excel may need to flatten lists and arrays to ensure compatibility with existing features such as PivotTables. This may be necessary until Microsoft adjusts these features to accommodate the new cell structure.