"It’s Freedom to Put Things Where My Mind Wants": understanding and improving the user experience of structuring data in spreadsheets

Conference item

Despite efforts to augment or replace the 2-dimensional spreadsheet grid with formal data structures such as arrays and tables to ease formula authoring and reduce errors, the flexible grid remains overwhelmingly successful. Why? We interviewed a diverse sample of 21 spreadsheet users about their use of structure in spreadsheets. It emerges that data structuring is subject to a complex network of incentives and constraints, including factors extrinsic to spreadsheets such as the user’s expertise, auxiliary tools, and collaborator needs. Moreover, we find that table columns are an important abstraction, and that operations such as conditional formatting, data validation, and formula authoring can be implemented on table columns, rather than cell ranges. To probe this, we designed 4 click-through prototypes for a follow-up study with 20 participants. We found that although column operations improved the value proposition of structured tables, they are unlikely to supplant the advantages of the flexible grid.

Authors: Chalhoub, G; Sarkar, A

• Publication status: Published
• Peer review status: Peer reviewed
• Publisher: Association for Computing Machinery
• Host title: Proceedings of the Conference on Human Factors in Computing Systems (CHI 2022)
• Article number: 585
• Publication date: 2022-04-29
• Acceptance date: 2022-02-03
• Event title: Conference on Human Factors in Computing Systems (CHI 2022)
• Event location: New Orleans, LA, USA
• Event website: https://chi2022.acm.org/
• Event start date: 2022-04-30
• Event end date: 2022-05-05
• DOI: 10.1145/3491102.3501833
• Language: 58English
• Keywords: FFR