Is spreadsheet syntax better than numeric indexing for cell selection?

Philip Heltweg, Dirk Riehle, Georg-Daniel Schwarz · 2025

Read Is spreadsheet syntax better than numeric indexing for cell selection? by Philip Heltweg, Dirk Riehle, Georg-Daniel Schwarz (2025) in the Tower of Babel, a free online library of public-domain works preserved in clean, searchable text. No sign-up. The full text is served as a plain-text file at a predictable URL, where text is present: https://antarctic-labs.com/tower-of-babel/arxiv-2505-23296.txt.

Introduction

Philip Heltweg, Dirk Riehle, and Georg-Daniel Schwarz compare cell references in twenty twenty-five. Selecting cells is routine in data engineering, for cleaning errors or extracting table parts. Two syntaxes compete: numeric indexing, as in programming languages, and spreadsheet-style references like A1. Which one leads to fewer mistakes was an open empirical question.

The authors ran a large controlled experiment with students as stand-ins for data practitioners. Participants read and wrote code in both styles. When reading, spreadsheet syntax produced fewer errors. When writing, participants were both faster and more accurate with spreadsheet syntax. A domain-specific language adopting that syntax is the suggested consequence. Readers in software engineering get rare experimental evidence on a notation choice usually settled by habit.

Catalog record

CREATORPhilip Heltweg, Dirk Riehle, Georg-Daniel Schwarz
YEAR2025
COLLECTIONPAPERS
FORMATTXT
FILE SIZE49 KB
VERSION1.0
LICENSEhttp://creativecommons.org/licenses/by/4.0/
RIGHTSCC BY
SOURCEarXiv

Source: https://arxiv.org/abs/2505-23296

Browse the full library · About the Tower of Babel

Full text

The opening of the work, from the library's hosted text:

Is spreadsheet syntax better than numeric indexing for cell selection? Philip Heltweg, Dirk Riehle, Georg-Daniel Schwarz Abstract Selecting a subset of cells is a common task in data engineering, for example, to remove errors or select only specific parts of a table. Multiple approaches to express this selection exist. One option is numeric indexing, commonly found in general programming languages, where a tuple of numbers identifies the cell. Alternatively, the separate dimensions can be referred to using different enumeration schemes like "A1" for the first cell, commonly found in software such as spreadsheet systems. In a large-scale controlled experiment with student participants as proxy for data practitioners, we compare the two options with respect to speed and correctness of reading and writing code. The results show that, when reading code, participants make less mistakes using spreadsheet-style syntax. Additionally, when writing code, they make fewer mistakes and are faster when using spreadsheet syntax compared to numeric syntax. From this, a domain-specific syntax, such as spreadsheet syntax for data engineering, appears to be a promising alternative to explore in future tools to support practitioners without a software engineering background. Keywords domain-specific languages, data engineering, programming syntax, controlled experiment, empirical study 1 Introduction A common challenge in data engineering is working with unstructured, two-dimensional data as it can be found in CSV files or spreadsheet software. Especially data sets based on exports from spreadsheets made for human readers have to be wrangled without the easy-to-use format that would allow for the selection of cells by column names or other structured tools. In these cases, data is organized for human readers to consume rather than machines. Often, values are distributed in a 2D data structure to place them in a 2D space when displayed as part of a sheet. While these data sets are technically machine-readable, they have to undergo extensive data engineering work before they are available in a format that is easily importable into, e.g., a Pandas dataframe. General-purpose programming languages (GPLs) can be used to manipulate this data, e.g., to select a subsection of it or remove errors. However, the syntax used in most GPLs has its origin in the numeric and often zero-indexed access of array structures. To select cells using this syntax, programmers refer to columns and rows by numbers or numeric ranges with the distinction between both being mostly by position. For example, Pandas/Python cell selection is performed by the axis of the underlying dataframe so that df . iloc [0, 1] selects the cell in the first row (on index 0) and second column (on index 1). While this syntax is familiar to professional software engineers, practitioners from adjacent fields that also work with two-dimensional (2D) data often use spreadsheet software to manipulate cells visually. Popular tools such as Microsoft Excel or Google Sheets show numbers as the reference to rows and characters to refer to columns, thereby syntactically separating the indexing dimensions. Therefore, the equivalent reference string to the Python/Pandas example above would be B1 . In this syntax, columns are expressed as characters ( B for the second column) while references to rows stay numeric, but their index starts more naturally at one instead of zero. With these different syntactical approaches, data practitioners with a background in using spreadsheet software to manipulate and clean their datasets can struggle when reading or writing code using numeric indexing. Mistakenly switching the order of row and column references or forgetting about zero-indexing can lead to crashes or subtle errors in the resulting datasets. As an alternative, domain-specific languages (DSLs) have been shown to be a potential middle ground between GPLs and visual tools, enabling domain experts to efficiently contribute in a wide range of domains outside of data engineering ( Kosar2018-ck ; Johanson2017-sb ) , as well as when building data pipelines Heltweg2025-uc . They do so by re-using concepts and conventions from the domain they cover. It stands to reason that addressing cells in unstructured 2D data sets could be easier for data practitioners using spreadsheet syntax rather than numeric indexing. In this study, we conduct a controlled experiment to test this hypothesis and provide a basis for further research. Based on quantitative data from a large group of student participants, we compare the use of spreadsheet-style syntax in a DSL for data engineering with the numeric syntax of Pandas, an industry-standard data engineering library for Python. Our goal is to answer the following research questions: Research Question 1: Does spreadsheet-style syntax have an effect on bottom-up program comprehension of cell selection in unstructured 2D data by data practitioners compared to numeric syntax… a: regarding speed? b: regarding correctness? Research Question 2: Does spreadsheet-style syntax have an effect on code creation for cell selection in unstructured 2D data by data practitioners compared to numeric syntax… a: regarding speed? b: regarding correctness? With this study, we contribute: 1. The results of hypothesis tests in a controlled experiment on the effects of using spreadsheet-style syntax instead of numeric syntax for cell selection, providing a foundation for future studies towards the ideal syntax for DSLs in data engineering. 2. A detailed description and accompanying code release of an experiment instrument to run controlled experiments for cell selection that enables reproduction and re-execution of the experiment with data professionals. This article is organized as follows: First, we provide a short overview of related studies in section 2 , then we present the research design in section 3 , followed by the results in section 4 . We provide additional context and insights in the discussion in section 5 . Limitations to the results are presented in section 6 before a summary of the insights and future work in section 7 . 2 Related Work Empirical studies of programming language design, such as different syntax, with users are generally rare, even though they can lead to a deeper understanding that can not otherwise be achieved Buse2011-ra . The relatively low amount of controlled experiments is a challenge in the wider field of software engineering research as well Ko2015-ti ; Vegas2016-dr . The benefits of using domain concepts with DSLs have been investigated in a series of controlled experiments and replication studies by Kosar et al. They compare DSLs with GPLs and domain-appropriate libraries in a variety of domains from GUI programming to feature diagrams Kosar2010-cp ; Kosar2012-ap ; Kosar2018-ck . The domain-specific concepts allow participants to work more accurate and efficient, both with and without IDE support. However, based on their experience they point out that the evaluation of DSLs and their features is domain-specific and should be done for each domain. To the best of our knowledge, our study is the first contribution to this effort for cell selection in data engineering. Hoisl et al. Hoisl2014-jy compare notation for scenario-based testing (two text-based and one diagrammatic) and find the more natural-language based one to outperform others, including a structured language. Their work is an indication that task outcomes can be improved by syntax that is more familiar to the participants that we test in a separate domain. How deeply domain concepts should be part of a DSL was previously studied by Häser et al. Haser2016-at for behavior driven development who compared

Read the complete text