Microsoft has created an AI that will make working with tables in Excel easier – it understands queries in natural language

Employees who can work well with Excel spreadsheets are highly valued. But Microsoft researchers have developed a solution that can at least partially replace them. SpreadsheetLLM is a large language model designed to manipulate spreadsheets using natural language commands.

Image source: Rubaitul Azad / unsplash.com

SpreadsheetLLM analyzes and interprets data in spreadsheets using AI, solving most of the problems associated with it – for this, data is serialized, that is, addresses, values ​​and cell formats are included in the stream. The tool contains a SheetCompressor component that compresses spreadsheets for transmission to the AI ​​model. It consists of three modules: the first analyzes the table structure and discards non-table contents; the second transforms the data into a more efficient representation; the third aggregates data.

SpreadsheetLLM has some limitations. It ignores cell colors, which may have meaning, and does not perform semantic compression on cell content expressed in natural language. But this is enough to reduce the consumption of tokens when requesting AI by 96%, which means saving computing resources. As a result, users without proper technical training can send requests to SpreadsheetLLM in natural language and achieve their goals. But the main goal of the project is not to replace a person, but to provide him with assistance in finance, accounting and other areas related to data processing.

The model includes the Chain of Spreadsheet (CoS) framework for analyzing the contents of multiple tables. SpreadsheetLLM can work with structured and unstructured spreadsheet data, an aspect the researchers indicate can reduce incidents of “hallucinations” in AI responses. The project is currently at the research stage and is not yet ready for release as a commercial product.

admin

Share
Published by
admin

Recent Posts

World’s Richest Lose $208 Billion in One Day Due to New US Tariffs

What kind of shocks the new US tariff policy will cause to the global economy…

4 hours ago

Cyclotech flies agile flying car with rotor ‘barrels’ instead of propellers for the first time

Austrian company Cyclotech has prepared a prototype of a flying car with unusual engines for…

4 hours ago

“I’m going to cry tears of happiness”: Apex Legends dataminers claim that Titanfall 3 is alive and will be released in 2026

Fans of Respawn Entertainment's sci-fi shooters Titanfall have already come to terms with the fact…

4 hours ago

SpaceX to Launch Starship for the First Time on Used Super Heavy Booster

On April 3, 2025, SpaceX conducted a static fire test of the Super Heavy booster,…

4 hours ago

Windows 11 Will Soon Get a Redesigned Start Menu That Can Be Customized

According to online sources, Microsoft is working on a major update to the Windows 11…

5 hours ago