Microsoft is working on SpreadsheetLLM, an AI model explicitly made for spreadsheets

The AI model would make data analysis accessible to regular users.

3 min. read

Published onJuly 16, 2024

published onJuly 16, 2024

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Data rule today’s world, and Microsoft has made a big move forward with its new invention, SpreadsheetLLM. This is an AI model made especially for spreadsheets, and it’s not just any kind of progress; it changes everything for users of Excel, Google Sheets, or similar programs.

Picture talking to your sheets using normal language inputs, making data analysis and handling as simple as chatting back and forth. That’s the future Microsoft is envisioning with SpreadsheetLLM.

SpreadsheetLLM is unique because it’s made to understand the specific layouts, formatting, and cell addresses familiar to people using spreadsheet programs. This is significant because, let’s be honest, spreadsheets can become tangled up.

They don’t simply deal with numbers; they depict connections among those numbers via an intricate web of cells, formulas, and formats.

At this point, traditional AI models often have difficulty understanding and handling spreadsheets due to their complexity. Take Copilot in Excel, an AI model that is constantly updatedto keep up with current technologies. However, SpreadsheetLLM is designed to handle this without any problems.

Yet, in essence, how does it function? The core of SpreadsheetLLM is what we term SheetCompressor. As the title implies, it compresses spreadsheets. It’s not only about making file sizes smaller—it’s the process of turning spreadsheets into data that AI can understand and analyze.

The researchers have found an intelligent method for keeping the important parts of the spreadsheet while greatly lessening the computational load needed to process it.

SpreadsheetLLM can be used in many ways. It can automate data analysis, carry out routine tasks, and produce reports with insights from spreadsheet information. It vows to make spreadsheet data friendlier for more people. Think about asking queries to your data in normal English, not needing to be a master of intricate formulas or coding languages. SpreadsheetLLM is striving towards this user-oriented future.

However, it’s worth mentioning that SpreadsheetLLM has difficulties in understanding specific spreadsheet functions such as background colors and borders. Still, the researchers behind the project are working on finding solutions for it.

Ultimately, SpreadsheetLLM might become a game-changer when working with data. It starts shifting towards making data analysis available for all, not just those with technical skills—a concept known as “democratization of insights.”

Although the project is not entirely functional, it has many advantages, and the team behind it believes it might be the lifejacket we require to comprehend data in a world immersed in data.

The full paper for the project can be readhere.

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low#

Copilot in Outlook will generate personalized themes for you to customize the app#

Microsoft will raise the price of its 365 Suite to include AI capabilities#

Death Stranding Director’s Cut is now Xbox X|S at a huge discount#

Outlook will let users create custom account icons so they can tell their accounts apart easier#

Microsoft is working on SpreadsheetLLM, an AI model explicitly made for spreadsheets#

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

Microsoft is working on SpreadsheetLLM, an AI model explicitly made for spreadsheets