Large language models (LLMs) like ChatGPT are well known, but gaps in their capabilities become apparent as they are used. One of these is the inability to understand spreadsheets. Due to their unique nature, spreadsheets remain a mystery to LLMs, which prevents them from being used as a business tool.
In a new study, the Microsoft team has created a tool that converts a spreadsheet into a format that Master can understand. It is based on the concept of SheetCompressor, a software tool that allows artificial intelligence to process and analyze data in spreadsheets.
SheetCompressor performs three main functions: compression, translation, and aggregation of data formats. Compression is accomplished by adding “anchors,” special markers that help LLM understand the purpose of the table. Rows and columns are then converted into a structured table. Translation modules remove empty cells and duplicate values.
During processing, the table is converted to JSON format, which allows you to combine data in different formats. Additionally, modules are provided to handle special cases, such as cells with similar number formats.
Source: Ferra
I am a professional journalist and content creator with extensive experience writing for news websites. I currently work as an author at Gadget Onus, where I specialize in covering hot news topics. My written pieces have been published on some of the biggest media outlets around the world, including The Guardian and BBC News.
