A Benchmark and Framework for Evaluating Next Action Predictions in Spreadsheets
Abstract
A benchmark for predicting spreadsheet user actions is introduced, addressing challenges in edit history availability and complex action spaces through manual curation and online evaluation methodology.
Predictive code completion greatly accelerates how quickly developers work. In spreadsheets, despite being much more common, such auto-completion features are virtually non-existent. To address this gap, we introduce a benchmark for systems that observe a sequence of user actions in a spreadsheet and predict future actions. Two challenges are (1) the absence of edit histories in public spreadsheet corpora and (2) the complex space of spreadsheet actions (spatial, temporal, composite). To address (1), we manually curate 52 sequences of 12K actions that recreate spreadsheets from public corpora, seeded by parametrized heuristics and LLM refinement. To address (2), we propose an online evaluation that expects a prediction after each user action, accepts or rejects that prediction, updates the future actions upon acceptance, and repeats this until the target spreadsheet is obtained. We use multiple baseline predictors (including zero-shot LLMs, fine-tuned SLMs, and classical models) and analyze different properties that our benchmark teaches us, including but not limited to: properties of saved actions and false positives, efficiency, effect of user profiles, effect of triggers, and effect of context.
Community
Accepted at ICML 2026.
Spreadsheets are everywhere โ budgets, schedules, reports, dashboards โ yet building even a simple one takes hundreds of small clicks: typing values, picking colors, drawing borders, copying styles. Programmers get powerful autocomplete (like GitHub Copilot) that quietly suggests the next few lines as they type, but spreadsheet users get nothing similar. Why? Because there's no good way to test such a system: nobody has recorded what real users do, step by step, while building a spreadsheet, and the actions span colors, layouts, and formulas all at once โ so it's hard to even define what "the right next suggestion" means.
We tackle both problems. First, we built a benchmark of 52 spreadsheets with the full step-by-step recipe a person would follow to make each one โ 12,000 actions total, hand-checked. Second, we built a testing framework that mimics a real user: at every step the system makes a suggestion, the simulated user accepts or rejects it, and the remaining work is updated to reflect what was just done (or undone).
Using this, we tested several frontier LLMs, small fine-tuned models, and simple statistical methods. Today's best AI can already save a user roughly one in three clicks, and even tiny models can match it after a little training. The benchmark and tools we release let researchers measure exactly where these assistants help, where they hurt, and what would make them genuinely useful in everyday spreadsheet work.
๐ arXiv: https://arxiv.org/abs/2606.13802 ยท ๐ป Code & benchmark: https://github.com/Tej-55/NAPE
Neat paper. Spreadsheets are used everywhere, yet we are still stuck manually typing out repetitive formulas and data entry, so it is surprising that there is not more work on predictive completion in this space.
I am curious about the online evaluation framework. Since you allow for model acceptance or rejection of predictions, how does the system handle cases where a rejected prediction might have put the spreadsheet in a slightly different but still valid state?
I made a podcast on it with ResearchPod, it makes it easy to get the key concepts on the go:
https://researchpod.app/episode/8ffe25c7-859a-4e7b-9642-bd616fa9d0a8
Get this paper in your agent:
hf papers read 2606.13802 Don't have the latest CLI?
curl -LsSf https://hf.co/cli/install.sh | bash Models citing this paper 0
No model linking this paper
Datasets citing this paper 0
No dataset linking this paper
Spaces citing this paper 0
No Space linking this paper
Collections including this paper 0
No Collection including this paper