"Spreadsheet AI" aims to be an AI-assisted software solution suite for a wide range of spreadsheet tasks. Currently, it mainly offers: 1) A chat copilot to whom you can ask any spreadsheet-related questions and receive answers. 2) 17 AI functions that can be directly used in Excel formulas. They construct prompts from spreadsheet cells and ranges, send them to AI models, and seamlessly retrieve results. 3) A converter that transforms certain AI formulas into built-in formulas.

The chat copilot is inherently aware of your workbook content:

This enables you to initiate data or formula analysis with a simple command. Ask questions like "Why is there an error in B5?", "Complete the table A1:D100 with accurate data and formulas", or "How many different items are in the Products table?" and receive immediate, helpful responses.

The chat copilot offers many examples of common spreadsheet tasks it can perform:

To help you explore the tool's power and apply it to your spreadsheet work, we categorized the common tasks the tool can perform. These include data-related tasks such as enrichment, transformation, and aggregation, as well as formula-related tasks like generation, explanation, debugging, and optimization. For each task, we provide sample data and example prompts for you to try.

The chat copilot provides traditional tasks UIs:

We've created task UIs for those who prefer a more traditional and structured software experience. These UIs allow you to initiate tasks directly rather than writing prompts, much like using any other software tool. Additionally, you can interact with the copilot to refine the results, making the software experience organized, interactive, and engaging.

The all-powerful AI function - SAI.ASK:

With SAI.ASK, you no longer need Excel's built-in functions, pivot tables, or laborious manual work. Whether you're looking to generate, merge, or manipulate lists and tables, simply articulate your requirements in natural language, and SAI.ASK does it with one simple command.

Specialized AI functions to classify, extract, format, genearte, etc.:

We also provide specialized AI functions to cater to various specific operational needs. For instance, for data manipulation, SAI.EXTRACT, SAI.EDIT, and SAI.FORMAT allow users to respectively extract, edit, and format data; SAI.CLASSIFY, SAI.TAG, and SAI.SUMMARIZE enable users to classify, tag, and summarize content.

Apply AI functions to a large volume of rows:

You can apply a prompt to many cells by simply copy-pasting or dragging a formula. We also provide AI "array" functions, such as SAI.EDITARRAY and SAI.FORMATARRAY. These AI array functions work similarly to Excel's built-in array functions, allowing you to apply them to an entire list or table and return an array. For spreadsheets with extensive arrays, leveraging these array functions is indispensable for maintaining a streamlined and effective calculation chain.

AI formula to built-in formula converter:

When handling large datasets, AI functions (whether provided by us or by other tools) can be slow and consume a large number of AI tokens. Additionally, their results may vary from one evaluation to another. To address this, we've introduced a new feature that converts AI formulas into Excel's built-in formulas with just one click, as long as the AI formula doesn't require external knowledge beyond your workbook. The converted formula produces the same result as the original AI formula but no longer relies on AI. This makes it efficient, cost-free, and stable. Currently, this feature is available only in the Pro Plan of Spreadsheet AI.

Pricing for virtual IQ Points required to use Spreadsheet AI:

Welcome bonus IQ: every user will be automatically granted free welcome bonus IQ points to get started.

Monthly free IQ: every user will automatically receive free IQ points each month.[#/LI] [#LI]Purchase IQ: users can buy packs of 800 IQ points for continued use or subscribe to the Pro Plan for cheaper IQ points and additional benefits.

Excel version requirement:

The add-in is built with Excel JavaScript API 1.2 and web libraries that have certain requirements on the version of Excel and operating system; some functionalities can be disabled if the embedded browser of your Excel is Internet Explorer; in this case, you can always use the add-in in Excel Online in a non-IE browser.

The chat copilot provides an interactive way to use AI in Excel, and AI functions directly integrate AI into Excel formulas. Together, these two main features of "Spreadsheet AI" complement each other, providing a comprehensive, powerful, and user-friendly AI experience in spreadsheets. More details can be found in www.10studio.tech. Give the add-in a try, and enjoy AI in Excel!

Spreadsheet AI

by SAS Matrix Lead