Claude for Excel is Transformative for Basic Spreadsheet Modeling and Analysis
cs.SE
Submitted: 2026-10-30
Updated: 2026-10-30
Journal ref: Proceedings of the EuSpRIG 2026 conference 'Spreadsheets, AI Agents, Trust, and Governance' ISBN 9781-905404-61-2 Copyright 2026, European Spreadsheet Risks Interest Group and Authors
License: http://creativecommons.org/licenses/by/4.0/
The gist: We used the Claude Excel plug-in to build and analyze spreadsheet models for five semi structured problem statements (including a test-piece teaching case with data in multiple exhibits) and…
Terminology
Abstract
We used the Claude Excel plug-in to build and analyze spreadsheet models for five semi structured problem statements (including a test-piece teaching case with data in multiple exhibits) and evaluated performance on modeling (what is to be coded), spreadsheet engineering (quality of coding), analysis (algorithms applied to the spreadsheet), and insight generation. Claude's ability to create a high-quality spreadsheet model from a semi structured problem statement is astoundingly excellent. Given very simple prompts, Claude generates extensive, accurate sensitivity and scenario analyses and reasonable plain English insights. Claude is Solver-aware and builds optimization models without specific prompting. Analyst productivity gains will likely be high. Business school quant courses will have to change. The way we develop human expertise will have to change.
Sources
Related papers
- ArkEval: Benchmarking and Evaluating Automated CodeRepair for ArkTS
- TestPrism: Rethinking Test Evaluation Beyond a Single Reference
- Mining Workflow Graphs for Black-Box Boundary Testing of Conversational LLM Agents
- Falsification-Based Verification of LLM-Generated Optimization Models: Sound Test Batteries and Their Detection Limits
- GitSkills: A Dataset of Agent Skills on GitHub
- For Coding Agents, the Repository Matters