Leveraging ChatGPT for Excel: How large language models are changing spreadsheet practices

Martin Broadhurst
Additional contact information
Martin Broadhurst: Broadhurst Digital, UK

Journal of AI, Robotics & Workplace Automation, 2024, vol. 3, issue 3, 220-233

Abstract: The integration of large language models (LLMs) with spreadsheet software has the potential to revolutionise data analysis and task automation in the workplace. This paper explores four key approaches to leveraging LLMs within spreadsheets: 1) LLM as a spreadsheet mentor, providing on-demand assistance and guidance to users; 2) LLM as an analyst with file ingestion, enabling direct data manipulation and in-chat analysis; 3) integrated LLM tools within office productivity suites, offering native LLM capabilities; and 4) LLM-powered add-ons, extending spreadsheet functionality through custom functions and formulas. By examining the strengths and weaknesses of each approach, this paper highlights the potential benefits, such as increased accessibility to advanced features, streamlined workflows and enhanced data insights. Challenges related to hallucinations, limited functionality and user adaptation are also discussed. As LLM technology continues to advance, more sophisticated integrations are expected to emerge, further transforming the way businesses and individuals work with data. The future of LLM spreadsheet integration holds immense promise for improving productivity, automating tasks and unlocking valuable insights from data.

Keywords: large language models (LLMs); spreadsheet analytics; ChatGPT; Excel automation; marketing data analysis; AI-assisted spreadsheets; data visualisation; productivity tools (search for similar items in EconPapers)
JEL-codes: G2 M15 (search for similar items in EconPapers)
Date: 2024
References: Add references at CitEc
Citations:

Downloads: (external link)
https://hstalks.com/article/8992/download/ (application/pdf)
https://hstalks.com/article/8992/ (text/html)
Requires a paid subscription for full access.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:aza:airwa0:y:2024:v:3:i:3:p:220-233

Access Statistics for this article

More articles in Journal of AI, Robotics & Workplace Automation from Henry Stewart Publications
Bibliographic data for series maintained by Henry Stewart Talks ().