{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,13]],"date-time":"2026-04-13T21:19:22Z","timestamp":1776115162265,"version":"3.50.1"},"publisher-location":"New York, NY, USA","reference-count":52,"publisher":"ACM","license":[{"start":{"date-parts":[[2025,4,25]],"date-time":"2025-04-25T00:00:00Z","timestamp":1745539200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"funder":[{"name":"National Key R&D Program of China","award":["2022YFE0137800"],"award-info":[{"award-number":["2022YFE0137800"]}]}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2025,4,26]]},"DOI":"10.1145\/3706598.3714321","type":"proceedings-article","created":{"date-parts":[[2025,4,24]],"date-time":"2025-04-24T04:40:09Z","timestamp":1745469609000},"page":"1-20","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":2,"title":["TableCanoniser: Interactive Grammar-Powered Transformation of Messy, Non-Relational Tables to Canonical Tables"],"prefix":"10.1145","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-8203-9667","authenticated-orcid":false,"given":"Kai","family":"Xiong","sequence":"first","affiliation":[{"name":"State Key Lab of CAD&CG, Zhejiang University, Hangzhou, Zhejiang, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-9218-987X","authenticated-orcid":false,"given":"Cynthia A","family":"Huang","sequence":"additional","affiliation":[{"name":"Department of Econometrics and Business Statistics, Monash University, Melbourne, Victoria, Australia"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-5536-7780","authenticated-orcid":false,"given":"Michael","family":"Wybrow","sequence":"additional","affiliation":[{"name":"Department of Human-Centred Computing, Monash University, Melbourne, Victoria, Australia"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-1119-3237","authenticated-orcid":false,"given":"Yingcai","family":"Wu","sequence":"additional","affiliation":[{"name":"State Key Lab of CAD&CG, Zhejiang University, Hangzhou, Zhejiang, China"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2025,4,25]]},"reference":[{"key":"e_1_3_3_3_2_2","doi-asserted-by":"publisher","DOI":"10.1145\/2737924.2737952"},{"key":"e_1_3_3_3_3_2","doi-asserted-by":"crossref","unstructured":"Lyn Bartram Michael Correll and Melanie Tory. 2021. Untidy data: The unreasonable effectiveness of tables. IEEE Transactions on Visualization and Computer Graphics 28 1 (2021) 686\u2013696.","DOI":"10.1109\/TVCG.2021.3114830"},{"key":"e_1_3_3_3_4_2","doi-asserted-by":"publisher","unstructured":"Sara Bonfitto Elena Casiraghi and Marco Mesiti. 2021. Table Understanding Approaches for Extracting Knowledge from Heterogeneous Tables. WIREs Data Mining and Knowledge Discovery 11 4 (July 2021) e1407. 10.1002\/widm.1407","DOI":"10.1002\/widm.1407"},{"key":"e_1_3_3_3_5_2","doi-asserted-by":"publisher","unstructured":"Christian Bors Theresia Gschwandtner and Silvia Miksch. 2019. Capturing and Visualizing Provenance From Data Wrangling. IEEE Computer Graphics and Applications 39 6 (Nov. 2019) 61\u201375. 10.1109\/MCG.2019.2941856","DOI":"10.1109\/MCG.2019.2941856"},{"key":"e_1_3_3_3_6_2","doi-asserted-by":"publisher","unstructured":"Michael Bostock Vadim Ogievetsky and Jeffrey Heer. 2011. D3 Data-Driven Documents. IEEE Transactions on Visualization and Computer Graphics 17 12 (2011) 2301\u20132309. 10.1109\/TVCG.2011.185","DOI":"10.1109\/TVCG.2011.185"},{"key":"e_1_3_3_3_7_2","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142574"},{"key":"e_1_3_3_3_8_2","doi-asserted-by":"publisher","unstructured":"Ran Chen Di Weng Yanwei Huang Xinhuan Shu Jiayi Zhou Guodao Sun and Yingcai Wu. 2023. Rigel: Transforming Tabular Data by Declarative Mapping. IEEE Transactions on Visualization and Computer Graphics 29 1 (2023) 128\u2013138. 10.1109\/TVCG.2022.3209385","DOI":"10.1109\/TVCG.2022.3209385"},{"key":"e_1_3_3_3_9_2","volume-title":"emphatic: Exploratory Analysis of Tabular Data using Colour Highlighting","author":"Cheng Mike","year":"2024","unstructured":"Mike Cheng. 2024. emphatic: Exploratory Analysis of Tabular Data using Colour Highlighting. https:\/\/coolbutuseless.github.io\/package\/emphatic\/, https:\/\/github.com\/coolbutuseless\/emphatic."},{"key":"e_1_3_3_3_10_2","volume-title":"The Relational Model for Database Management: Version 2 (reprinted with corr ed.)","author":"Codd Edgar\u00a0F.","year":"1991","unstructured":"Edgar\u00a0F. Codd. 1991. The Relational Model for Database Management: Version 2 (reprinted with corr ed.). Addison-Wesley, Reading, Mass."},{"key":"e_1_3_3_3_11_2","doi-asserted-by":"publisher","unstructured":"Upol Ehsan and Mark\u00a0O. Riedl. 2024. Explainability Pitfalls: Beyond Dark Patterns in Explainable AI. Patterns 5 6 (June 2024) 100971. 10.1016\/j.patter.2024.100971","DOI":"10.1016\/j.patter.2024.100971"},{"key":"e_1_3_3_3_12_2","volume-title":"Tidyxl: Read Untidy Excel Files","author":"Garmonsway Duncan","year":"2023","unstructured":"Duncan Garmonsway. 2023. Tidyxl: Read Untidy Excel Files."},{"key":"e_1_3_3_3_13_2","doi-asserted-by":"publisher","DOI":"10.1145\/3613904.3642497"},{"key":"e_1_3_3_3_14_2","doi-asserted-by":"publisher","unstructured":"Sumit Gulwani William\u00a0R. Harris and Rishabh Singh. 2012. Spreadsheet Data Manipulation Using Examples. Commun. ACM 55 8 (Aug. 2012) 97\u2013105. 10.1145\/2240236.2240260","DOI":"10.1145\/2240236.2240260"},{"key":"e_1_3_3_3_15_2","unstructured":"Handsontable. 2024. Handsontable is a JavaScript data grid that looks and feels like a spreadsheet. https:\/\/handsontable.com\/. Accessed: August 2024."},{"key":"e_1_3_3_3_16_2","unstructured":"Cynthia\u00a0A. Huang. 2023. Visualising category recoding and numeric redistributions. arxiv:https:\/\/arXiv.org\/abs\/2308.06535\u00a0[cs.HC] https:\/\/arxiv.org\/abs\/2308.06535"},{"key":"e_1_3_3_3_17_2","doi-asserted-by":"publisher","DOI":"10.1145\/3613904.3642415"},{"key":"e_1_3_3_3_18_2","doi-asserted-by":"publisher","DOI":"10.1145\/2063576.2063829"},{"key":"e_1_3_3_3_19_2","doi-asserted-by":"publisher","unstructured":"Edwin\u00a0L. Hutchins James\u00a0D. Hollan and Donald\u00a0A. Norman. 1985. Direct Manipulation Interfaces. Human\u2013Computer Interaction 1 4 (Dec. 1985) 311\u2013338. 10.1207\/s15327051hci01042","DOI":"10.1207\/s15327051hci01042"},{"key":"e_1_3_3_3_20_2","unstructured":"David Huynh. [n. d.]. OpenRefine. https:\/\/openrefine.org. Accessed: August 2024."},{"key":"e_1_3_3_3_21_2","volume-title":"gt: Easily Create Presentation-Ready Display Tables","author":"Iannone Richard","year":"2023","unstructured":"Richard Iannone, Joe Cheng, Barret Schloerke, Ellis Hughes, Alexandra Lauer, and JooYoung Seo. 2023. gt: Easily Create Presentation-Ready Display Tables. https:\/\/CRAN.R-project.org\/package=gt R package version 0.9.0."},{"key":"e_1_3_3_3_22_2","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3064034"},{"key":"e_1_3_3_3_23_2","doi-asserted-by":"publisher","unstructured":"Sean Kandel Jeffrey Heer Catherine Plaisant Jessie Kennedy Frank van Ham Nathalie\u00a0Henry Riche Chris Weaver Bongshin Lee Dominique Brodbeck and Paolo Buono. 2011. Research Directions in Data Wrangling: Visualizations and Transformations for Usable and Credible Data. Information Visualization 10 4 (Oct. 2011) 271\u2013288. 10.1177\/1473871611415994","DOI":"10.1177\/1473871611415994"},{"key":"e_1_3_3_3_24_2","doi-asserted-by":"publisher","DOI":"10.1145\/1978942.1979444"},{"key":"e_1_3_3_3_25_2","doi-asserted-by":"publisher","DOI":"10.1145\/3544548.3581001"},{"key":"e_1_3_3_3_26_2","doi-asserted-by":"publisher","DOI":"10.23919\/MIPRO55190.2022.9803520"},{"key":"e_1_3_3_3_27_2","doi-asserted-by":"publisher","unstructured":"Guozheng Li Runfei Li Zicheng Wang Chi\u00a0Harold Liu Min Lu and Guoren Wang. 2023. HiTailor: Interactive Transformation and Visualization for Hierarchical Tabular Data. IEEE Transactions on Visualization and Computer Graphics 29 1 (2023) 139\u2013148. 10.1109\/TVCG.2022.3209354","DOI":"10.1109\/TVCG.2022.3209354"},{"key":"e_1_3_3_3_28_2","doi-asserted-by":"publisher","unstructured":"Peng Li Yeye He Cong Yan Yue Wang and Surajit Chaudhuri. 2023. Auto-Tables: Synthesizing Multi-Step Transformations to Relationalize Tables without Using Examples. Proceedings of the VLDB Endowment 16 11 (July 2023) 3391\u20133403. 10.14778\/3611479.3611534","DOI":"10.14778\/3611479.3611534"},{"key":"e_1_3_3_3_29_2","doi-asserted-by":"publisher","DOI":"10.1145\/3531146.3533175"},{"key":"e_1_3_3_3_30_2","unstructured":"Microsoft. 2024. Monaco Editor. https:\/\/microsoft.github.io\/monaco-editor\/. Accessed: August 2024."},{"key":"e_1_3_3_3_31_2","doi-asserted-by":"publisher","unstructured":"Brad Myers Scott\u00a0E. Hudson and Randy Pausch. 2000. Past Present and Future of User Interface Software Tools. ACM Transactions on Computer-Human Interaction 7 1 (March 2000) 3\u201328. 10.1145\/344949.344959","DOI":"10.1145\/344949.344959"},{"key":"e_1_3_3_3_32_2","doi-asserted-by":"publisher","unstructured":"Christina Niederer Holger Stitz Reem Hourieh Florian Grassinger Wolfgang Aigner and Marc Streit. 2018. TACO: Visualizing Changes in Tables Over Time. IEEE Transactions on Visualization and Computer Graphics 24 1 (Jan. 2018) 677\u2013686. 10.1109\/TVCG.2017.2745298","DOI":"10.1109\/TVCG.2017.2745298"},{"key":"e_1_3_3_3_33_2","doi-asserted-by":"publisher","unstructured":"pandas dev. 2024. pandas - Python Data Analysis Library. https:\/\/pandas.pydata.org\/. 10.5281\/zenodo.7741580","DOI":"10.5281\/zenodo.7741580"},{"key":"e_1_3_3_3_34_2","doi-asserted-by":"publisher","DOI":"10.5555\/894083"},{"key":"e_1_3_3_3_35_2","doi-asserted-by":"publisher","unstructured":"Arvind Satyanarayan Bongshin Lee Donghao Ren Jeffrey Heer John Stasko John Thompson Matthew Brehmer and Zhicheng Liu. 2020. Critical Reflections on Visualization Authoring Systems. IEEE Transactions on Visualization and Computer Graphics (2020) 1\u20131. 10.1109\/TVCG.2019.2934281","DOI":"10.1109\/TVCG.2019.2934281"},{"key":"e_1_3_3_3_36_2","doi-asserted-by":"publisher","unstructured":"Alexey Shigarov. 2023. Table Understanding: Problem Overview. WIREs Data Mining and Knowledge Discovery 13 1 (Jan. 2023) e1482. 10.1002\/widm.1482","DOI":"10.1002\/widm.1482"},{"key":"e_1_3_3_3_37_2","doi-asserted-by":"publisher","unstructured":"A. Shigarov V. Khristyuk and A. Mikhailov. 2019. TabbyXL: Software Platform for Rule-Based Spreadsheet Data Extraction and Transformation. SoftwareX 10 (July 2019) 100270. 10.1016\/j.softx.2019.100270","DOI":"10.1016\/j.softx.2019.100270"},{"key":"e_1_3_3_3_38_2","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-46254-77"},{"key":"e_1_3_3_3_39_2","doi-asserted-by":"publisher","DOI":"10.1109\/ICCV.2017.630"},{"key":"e_1_3_3_3_40_2","doi-asserted-by":"publisher","unstructured":"Sara Steegen Francis Tuerlinckx Andrew Gelman and Wolf Vanpaemel. 2016. Increasing Transparency Through a Multiverse Analysis. Perspectives on Psychological Science 11 5 (Sept. 2016) 702\u2013712. 10.1177\/1745691616658637","DOI":"10.1177\/1745691616658637"},{"key":"e_1_3_3_3_41_2","unstructured":"Tableau. 2024. Tableau Prep Builder | Combine shape and clean your data faster. https:\/\/www.tableau.com\/products\/prep. Accessed: August 2024."},{"key":"e_1_3_3_3_42_2","unstructured":"Trifacta. [n. d.]. Data Wrangling Software and Tools - Trifacta. https:\/\/www.trifacta.com\/. Accessed: August 2024."},{"key":"e_1_3_3_3_43_2","unstructured":"Vue. 2024. Vue.js - The Progressive JavaScript Framework. https:\/\/vuejs.org\/. Accessed: August 2024."},{"key":"e_1_3_3_3_44_2","doi-asserted-by":"publisher","DOI":"10.1145\/3491102.3502123"},{"key":"e_1_3_3_3_45_2","volume-title":"Xtable : a tabular editor and formatter","author":"Wang Xinxin","year":"1996","unstructured":"Xinxin Wang and Derick Wood. 1996. Xtable : a tabular editor and formatter. Technical Report. HKUST. https:\/\/api.semanticscholar.org\/CorpusID:2239168"},{"key":"e_1_3_3_3_46_2","doi-asserted-by":"publisher","unstructured":"Hadley Wickham. 2007. Reshaping Data with the Reshape Package. Journal of Statistical Software 21 12 (2007) 1\u201320. 10.18637\/jss.v021.i12","DOI":"10.18637\/jss.v021.i12"},{"key":"e_1_3_3_3_47_2","doi-asserted-by":"publisher","unstructured":"Hadley Wickham. 2014. Tidy Data. Journal of Statistical Software 59 10 (2014) 1\u201323. 10.18637\/jss.v059.i10","DOI":"10.18637\/jss.v059.i10"},{"key":"e_1_3_3_3_48_2","doi-asserted-by":"publisher","unstructured":"Hadley Wickham Mara Averick Jennifer Bryan Winston Chang Lucy McGowan Romain Fran\u00e7ois Garrett Grolemund Alex Hayes Lionel Henry Jim Hester Max Kuhn Thomas Pedersen Evan Miller Stephan Bache Kirill M\u00fcller Jeroen Ooms David Robinson Dana Seidel Vitalie Spinu Kohske Takahashi Davis Vaughan Claus Wilke Kara Woo and Hiroaki Yutani. 2019. Welcome to the Tidyverse. Journal of Open Source Software 4 43 (Nov. 2019) 1686. 10.21105\/joss.01686","DOI":"10.21105\/joss.01686"},{"key":"e_1_3_3_3_49_2","volume-title":"Tidyr: Tidy Messy Data","author":"Wickham Hadley","year":"2023","unstructured":"Hadley Wickham, Davis Vaughan, and Maximilian Girlich. 2023. Tidyr: Tidy Messy Data."},{"key":"e_1_3_3_3_50_2","doi-asserted-by":"publisher","unstructured":"Kai Xiong Siwei Fu Guoming Ding Zhongsu Luo Rong Yu Wei Chen Hujun Bao and Yingcai Wu. 2023. Visualizing the Scripts of Data Wrangling with SOMNUS. IEEE Transactions on Visualization and Computer Graphics 29 6 (June 2023) 2950\u20132964. 10.1109\/TVCG.2022.3144975","DOI":"10.1109\/TVCG.2022.3144975"},{"key":"e_1_3_3_3_51_2","doi-asserted-by":"publisher","unstructured":"Kai Xiong Zhongsu Luo Siwei Fu Yongheng Wang Mingliang Xu and Yingcai Wu. 2023. Revealing the Semantics of Data Wrangling Scripts With COMANTICS. IEEE Transactions on Visualization and Computer Graphics 29 1 (2023) 117\u2013127. 10.1109\/TVCG.2022.3209470","DOI":"10.1109\/TVCG.2022.3209470"},{"key":"e_1_3_3_3_52_2","doi-asserted-by":"publisher","unstructured":"Kai Xu Alvitta Ottley Conny Walchshofer Marc Streit Remco Chang and John Wenskovitch. 2020. Survey on the Analysis of User Interactions and Visualization Provenance. Computer Graphics Forum 39 3 (June 2020) 757\u2013783. 10.1111\/cgf.14035","DOI":"10.1111\/cgf.14035"},{"key":"e_1_3_3_3_53_2","doi-asserted-by":"publisher","unstructured":"Bin Yu and Karl Kumbier. 2020. Veridical Data Science. Proceedings of the National Academy of Sciences 117 8 (Feb. 2020) 3920\u20133929. 10.1073\/pnas.1901326117","DOI":"10.1073\/pnas.1901326117"}],"event":{"name":"CHI 2025: CHI Conference on Human Factors in Computing Systems","location":"Yokohama Japan","acronym":"CHI '25","sponsor":["SIGCHI ACM Special Interest Group on Computer-Human Interaction"]},"container-title":["Proceedings of the 2025 CHI Conference on Human Factors in Computing Systems"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3706598.3714321","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3706598.3714321","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,7,4]],"date-time":"2025-07-04T05:35:59Z","timestamp":1751607359000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3706598.3714321"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,4,25]]},"references-count":52,"alternative-id":["10.1145\/3706598.3714321","10.1145\/3706598"],"URL":"https:\/\/doi.org\/10.1145\/3706598.3714321","relation":{},"subject":[],"published":{"date-parts":[[2025,4,25]]},"assertion":[{"value":"2025-04-25","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}