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

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.