Your Microsoft Excel spreadsheets could soon have a lot more AI power

New tool could help bridge the gap between AI and Excel

When you purchase through links on our site, we may earn an affiliate commission.Here’s how it works.

Microsoftresearchers have unveiled a large language model with the ability to enhance the interaction with and understanding ofspreadsheetshas been introduced, marking a significant leap forward for AI’s ability to handle Excel files.

Outlined in apaper, entitled ‘SpeadsheetLLM: Encoding Spreadsheets for Large Language Models,’ the team looks to explore the complexities and challenges of applying AI to structured, logical and formulaic datasets.

SpreadsheetLLM promises the ability to combine these datasets with the already proven capabilities of large language models.

SpreadsheetLLM could make AI more efficient in your Excel sheet

SpreadsheetLLM could make AI more efficient in your Excel sheet

According to the researchers, “SpreadsheetLLM is an approach for encoding spreadsheet contents into a format that can be used with large language models (LLMs) and allows these models to reason over spreadsheet contents.”

The research notes the widespread use of spreadsheets in various business operations, from simple data entry to complex financial modelling. However, despite the importance of these numerical files, existing LLMs have struggled to structure the data and formulas. By encoding the data in a package that LLMs can comprehend, Microsoft’s researchers hope to unlock the processing power of current generative AI tools that use existing LLMs within the Excel environment.

By unlocking the full potential of spreadsheet data, businesses using generative AI tools could improve their data-based decision-making and improve the efficiency of other administrative tasks.

Although SpreadsheetLLM is currently little more than a research project, the work to improve compatibility between Excel files and existingAI toolsdoes at least signify the continually evolving power of AI.

Are you a pro? Subscribe to our newsletter

Are you a pro? Subscribe to our newsletter

Sign up to the TechRadar Pro newsletter to get all the top news, opinion, features and guidance your business needs to succeed!

Moreover, while the company has not yet committed to building such a tool on a wider scale, Microsoft’s multibillion-dollar investment inChatGPTmakerOpenAIand its subsequent rollout of generative AI functionalities across itsoffice appsimplies that the tech giant is committed to making AI more accessible.

More from TechRadar Pro

With several years’ experience freelancing in tech and automotive circles, Craig’s specific interests lie in technology that is designed to better our lives, including AI and ML, productivity aids, and smart fitness. He is also passionate about cars and the decarbonisation of personal transportation. As an avid bargain-hunter, you can be sure that any deal Craig finds is top value!

Samsung plans record-breaking 400-layer NAND chip that could be key to breaking 200TB barrier for ultra large capacity AI hyperscaler SSDs

Adobe’s decision to eliminate perpetual licensing for its Elements software has stirred controversy among consumers

Your next smartwatch could be battery-free – and powered by your skin