Excel now supports multiple values in a single cell
Excel’s new ability to store lists and arrays as values in a single cell is seen as a major shift from its traditional “one value per cell” model, effectively adding a new dimension to spreadsheets. Enthusiasts welcome the feature as a powerful way to model richer data structures—akin to JSON in databases—and simplify tasks like filtering or broadcasting computations over many values. Critics worry it will worsen already fragile, opaque workbooks, violate clean data modeling principles, and create more opportunities for hard-to-debug errors in business-critical spreadsheets.
Feature & Novelty
- Excel now lets a single cell hold lists/arrays (including nested), instead of just one scalar value.
- Some commenters assumed this already existed; others clarify older “array formulas” spilled across ranges, not inside one cell.
- A few see this as effectively adding a third dimension / “z‑axis” to spreadsheets.
Perceived Benefits & Use Cases
- Helps with columns that naturally contain multiple values per row (e.g., a list of apps per user), which were previously stored as awkward comma‑separated strings.
- Expected to simplify parsing, filtering, and indexing into multi‑value fields.
- Some think the implementation looks “sane” and fixes pain points of traditional array formulas.
Design, Semantics & 1NF Concerns
- Several worry this breaks the intuitive 2D mental model of spreadsheets and makes reasoning about data harder.
- People draw parallels to violating First Normal Form (non‑scalar fields) in databases and to JSON-in-database columns.
- Critics call it “type‑soft” and fear it will encourage unreadable, fragile “spaghetti” spreadsheets with nested lists, lambdas, and recursion.
Reliability, Tech Debt & Backwards Compatibility
- Concern that new features will break long‑standing VBA and formula pipelines that quietly run businesses.
- At the same time, Excel still preserves old quirks (e.g., 1900 leap‑year bug) for compatibility, which some find ironic.
- Some plan to stress‑test the feature and the Python integration by pushing complex nested structures.
Comparisons & Alternatives
- Mention of prior tools with similar ideas: Treesheets, Lotus Improv, Pick OS multi‑value fields, CAS tools (Mathematica), R lists/vectors, probabilistic tools like Guesstimate and @Risk.
- Some argue advanced probabilistic or tensor‑like data should live in specialized systems, not Excel.
Excel’s Role & Culture
- Strong defense of Excel as an extremely flexible, general‑purpose business tool, especially where IT blocks custom software.
- Others say Excel’s flexibility hides poor processes and props up organizations that should have more robust systems.
- Debate over whether most users only need “calculator‑level” features versus advanced modeling, and whether innovations like this are worth the added complexity.