AI-Powered Formula Generation & Data Analysis for JavaScript Spreadsheets

Empower your users to become [the goto] spreadsheet experts to create, explain, and analyze spreadsheet data using natural-language prompts. The SpreadJS AI-Assistant optional add-on integrates with OpenAI or any AI provider, including your own, that complies with OpenAI Schema to deliver intelligent formulas, dynamic PivotTables, and context-aware spreadsheet functions, all inside your web app.

Download Free SpreadJS Trial Online AI-Assistant Demos

Try the JavaScript AI-Assistant Formula Editor UI

Experience in action the AI-Assisted Formula Editor demo below. Instantly generate or explain formulas from plain text, then explore more AI-powered capabilities like PivotTable generation and intelligent AI spreadsheet functions.

Ultimate JavaScript AI Spreadsheet Tool

Simplify Complex Formulas with Natural Language Input using a JavaScript Spreadsheet AI-Assistant Add-On

Simplify Complex Formulas with Natural Language Input

Use natural language in the AI Formula Editor to instantly generate Excel-style formulas and get clear, step-by-step explanations of complex formulas—all in one streamlined experience.

Build JavaScript Pivot Table Reports Instantly from Plain-Language Prompts

Use AI-powered PivotTable tools in SpreadJS to instantly generate layouts and get intelligent data insights—all through simple natural language input.

Build JavaScript Pivot Table Reports Instantly from Plain-Language Prompts
Bring Natural Language Intelligence to Every Cell in JavaScript Spreadsheet Applications

Bring Natural Language Intelligence to Every Cell

AI functions in SpreadJS let you query data, translate content, and analyze sentiment directly in cells—bringing natural language intelligence to every part of your spreadsheet.

JavaScript Spreadsheet AI Developer Tool

Intuitive UI to create and refine Excel formulas with AI-powered guidance within enterprise web applications

Launch AI Formula Editor Panel

This JavaScript spreadsheet add-on offers an AI Formula Editor Panel to provide an intuitive way to create and refine formulas with AI-powered guidance within enterprise web applications. Users can simply click the AI button in the Formula Editor Panel, and open an intelligent assistant that helps generate, explain, and correct formulas in real time. This feature streamlines formula creation, reduces errors, and enhances productivity—especially for complex or unfamiliar functions.

Allows app users to create complex Excel formulas effortlessly using AI natural language input

Generate Excel Formulas

The AI Formula Editor offered in this JS spreadsheet add-on allows users to create complex Excel formulas effortlessly using natural language input. Simply type what you want to calculate—such as “sum of amount” or “average of sales”—and the AI assistant automatically generates a properly formatted formula. Users can review and edit the AI-generated formula directly in the Formula Editor Panel, then click Apply to insert it into the active cell. This feature streamlines formula creation, reduces manual errors, and helps users of all skill levels work faster and smarter.

JavaScript spreadsheet AI Formula Editor | Allow users to select and query AI to breakdown complex formulas

Explain Complex Formulas

With Explain Complex Formulas, the AI Formula Editor in SpreadJS breaks down any formula users enter or select into the panel. Click Query to receive a readable summary of the formula’s purpose, a step-by-step breakdown of its logic, and explanations of the functions and their arguments—optionally enriched with sheet context. If the first pass isn’t quite right, use the Refresh action to regenerate a clearer explanation. This helps users debug faster, learn unfamiliar functions, and confidently maintain sophisticated spreadsheets.

JavaScript Spreadsheet Pivot Table AI generation and analysis in Web Apps

AI Pivot Table Generation Panel

Quickly generate PivotTable layouts using natural language—just describe what you need, and the AI Pivot Table Panel builds it for you automatically.

AI Pivot Table Generation UI for JS Enterprise Applications

Submit Pivot Table Request

Easily create PivotTables by typing your layout request in natural language—submit it, and the AI instantly builds the table for you.

Add AI Pivot Table Suggestions to Excel-Like Web Applications

AI Pivot Table Suggestions

Easily identify collaborators in shared workbooks with personalized colors and user initials displayed on their active selections.

JavaScript Pivot Table AI Analysis | Developer Solutions

AI Analysis Panel

Open the AI Analysis Panel to ask natural language questions about your PivotTable data and receive instant, intelligent insights.

JavaScript Spreadsheet Pivot Table AI generation and analysis in Web Apps

AI Pivot Table Generation Panel

Our JavaScript spreadsheet control’s AI-Assistant add-on offers an AI Pivot Table Generation Panel that uses artificial intelligence to simplify pivot table creation. Instead of manually configuring fields and layouts, users can type a plain-language request—such as “Show sales by cars and quarters”—and the AI automatically generates a matching PivotTable layout. Accessible directly within the PivotTable Panel, this feature accelerates data exploration and reporting by turning everyday language into precise, data-driven visual summaries.

AI Pivot Table Generation UI for JS Enterprise Applications

Submit Pivot Table Request

The AI-assistant add-on offered with the JavaScript spreadsheet control, SpreadJS, enables users to generate PivotTable layouts through simple natural language input. Users click the “A” button to display the AI generation panel. Users can then describe their desired structure—for example, “Show sales by cars and quarters”—then click Send or press Enter to submit. The AI automatically interprets the request and builds a corresponding PivotTable layout. This intuitive feature removes the complexity of manual configuration, allowing anyone to create insightful, data-driven summaries with just a few words.

Add AI Pivot Table Suggestions to Excel-Like Web Applications

AI Pivot Table Suggestions

The AI Pivot Table Suggestions feature offered by our JavaScript spreadsheet add-on helps users explore data more efficiently by automatically generating intelligent PivotTable layout options. By clicking the “AI Suggestions” button, users receive three recommended layouts based on their dataset. Each suggestion can be applied instantly with a single click, or users can refresh to view new options. This feature streamlines analysis by providing inspiration and ready-to-use layouts, reducing the time spent designing PivotTables manually.

JavaScript Pivot Table AI Analysis | Developer Solutions

AI Analysis Panel

The SpreadJS AI-Assistant's AI Analysis Panel adds powerful, context-aware data interpretation to JavaScript PivotTables. By clicking the “I” button, users can access an AI-driven analysis interface where they can ask questions like “Who had the highest sales in the third quarter?” The AI examines the underlying PivotTable data and delivers clear, detailed answers—highlighting trends, comparisons, and key insights. This feature transforms static summaries into dynamic, conversational analytics, making data exploration faster and more intuitive.

Enable users to interact directly with an AI model from within JavaScript web applications

SJS.AI.QUERY

Use the SJS.AI.QUERY function to send spreadsheet data to an AI model and instantly get intelligent, context-aware insights or transformations.

Perform fast, AI-driven translations, directly within in JavaScript spreadsheet apps

SJS.AI.TRANSLATE

The SJS.AI.TRANSLATE function instantly translates text or cell ranges into your chosen language using AI-powered translation, enabling seamless multilingual data handling.

Provided AI-powered sentiment analysis directly to enterprise spreadsheet web apps

SJS.AI.TEXTSENTIMENT

The SJS.AI.TEXTSENTIMENT function analyzes text within cells to determine whether the sentiment is Positive, Negative, or Neutral, making sentiment analysis effortless in spreadsheets.

Enable users to interact directly with an AI model from within JavaScript web applications

SJS.AI.QUERY

The SJS.AI.QUERY function in SpreadJS enables users to interact directly with an AI model from within their spreadsheets. By passing cell values or ranges as input, developers can generate intelligent responses, perform complex data transformations, or derive insights based on existing data. This function simplifies AI-driven analysis without leaving the spreadsheet environment, making it ideal for automating reporting, summarization, and contextual interpretation tasks.

Perform fast, AI-driven translations, directly within in JavaScript spreadsheet apps

SJS.AI.TRANSLATE

SJS.AI.TRANSLATE allows SpreadJS users to perform fast, AI-driven translations directly within their spreadsheets. By specifying a target language, this function can translate single values or entire arrays with high accuracy and natural language fluency. It’s ideal for global reporting, international data analysis, and multilingual collaboration—helping users convert content effortlessly without leaving the spreadsheet environment.

Provided AI-powered sentiment analysis directly to enterprise spreadsheet web apps

SJS.AI.TEXTSENTIMENT

SJS.AI.TEXTSENTIMENT brings AI-powered sentiment analysis directly to spreadsheet web apps, allowing users to evaluate the tone of text data instantly. By applying this function to cell content, developers can classify input as Positive, Negative, or Neutral, helping uncover insights from reviews, feedback, or social media data. It’s an ideal tool for automating customer sentiment tracking, product evaluation, and large-scale text analysis—directly within the spreadsheet environment.

Build Your Own AI-Assisted JavaScript Spreadsheet

Quick Start Guide
1. Install needed packages using npm.

Install NPM Packages: @mescius/spread-sheets, @mescius/spread-sheets-ai-addon

npm install @mescius/spread-sheets @mescius/spread-sheets-ai-addon
2. Create server-side proxy service.

In order to protect your credentials, you should host a proxy service instead of calling AI services directly from client. 

Below is a snippet, but follow detailed instructions in our AI documentation

import express from "express";
import { OpenAI } from "openai";
import dotenv from "dotenv";

dotenv.config();

const app = express();
const port = process.env.PORT || 3000;

app.use(express.json());
app.use(express.static("public"));

const openai = new OpenAI({
	apiKey: process.env.AI_API_KEY,
	baseURL: process.env.AI_SERVER_URL,
});
app.post("/api/queryAI", async (req, res) => {
	// call and handle openai.chat.completions.create(req.body)
    ...
});
app.listen(port, () => {
	console.log(`Server is running on port ${port}`);
});
3. Create an HTML container as the JS spreadsheet host element. 
<!doctype html>
<meta charset="utf-8">
<div id="ss" style="width:100vw;height:95vh"></div>
<script defer src="/client.bundle.js">
</script>
4. Initialize the Client JavaScript Spreadsheet Workbook and Inject AI (via proxy) 
import * as GC from "@mescius/spread-sheets";
import '@mescius/spread-sheets-ai-addon';

// Initialize SpreadJS workbook
const workbook = new GC.Spread.Sheets.Workbook('ss');
const serverCallback = async (requestBody) => {
    requestBody.model = 'your model name';
    let response = await fetch('/api/queryAI', {
        method: 'POST',
        headers: { 'Content-Type': 'application/json' },
        body: JSON.stringify(requestBody)
    });
    return response;
}
//Inject AI using proxy service
workbook.injectAI(serverCallback);

Learn more with our interactive online demos or tutorial documentation.

Supercharge Your JavaScript Spreadsheets with an AI Assistant

Check out the recording of our AI-Assistant Code Clinic.

FAQs about the SpreadJS AI Assistant

A: No. SpreadJS was developed solely by human effort. It does not involve the use of any artificial intelligence technology in its code creation.

A: Yes, using a separate add-on. SpreadJS has an optional paid AI Add-on that integrates it directly with 3rd-party AI services. This optional set of features adds “smart tools” to your spreadsheets.

SpreadJS does not require the use of AI for any of its core functionality and features. AI integration is purely optional using a separate add-on.

MESCIUS does not offer AI services. Some MESCIUS products like SpreadJS integrate directly with 3rd-party AI services to add specialized AI features.

MESCIUS does not see, save or store any of the information used in the SpreadJS AI add-on. SpreadJS passes the data directly to the 3rd-party AI service that you have chosen and configured. No data is ever sent to MESCIUS servers.

A: No. SpreadJS does not see, save, or store any data processed by the SpreadJS AI add-on. All information is sent directly to the third-party AI service you configure, and no data is ever transmitted to MESCIUS servers.

No. SpreadJS does not provide any AI services, but instead we support integration with the LLM of your choosing. You can use any AI service provider that complies with the Open AI schema. All you need to do is point the SpreadJS AI Assistant to your endpoint and tell it which model to use! 

Easy Licensing & Distribution

After Purchasing, Users Generate AI Add-On Enabled SpreadJS Distribution Keys for Applications Through Their MESCIUS Account.

Licensing & FAQs

The AI-Assistant add-on is enabled through a SpreadJS distribution key. SpreadJS is licensed per developer and deployed hostname, with deployment licenses varying by commercial or non-commercial use.

Learn More About Optional Add-On Licensing

Request a AI-Assistant Add-On Enabled Trial Key

Our sales team can provide a 30-day AI-Assistant enabled trial key upon request, allowing you to deploy SpreadJS and this optional add-on during your trial period.

Contact Our Sales Team

Have Questions? We're Here to Help

Email us.sales@mescius.com to schedule a call with our product specialists or request a personalized demo through support to discuss your project needs.

Contact Support

SpreadJS Media and Content

Blogs

SpreadJS v19 Released!

New AI Features in JavaScript Spreadsheets: Natural Language and Smart Analysis

New SpreadJS Addons: ReportSheet and GanttSheet

Introducing Real-Time Collaboration in JavaScript Spreadsheets

How to Add a JavaScript Spreadsheet Ribbon Component in Your Web App

View All Blogs

Videos

New AI Add-On Features in JavaScript Spreadsheets

New Real-Time Spreadsheet Collaboration in JavaScript Web Apps

SpreadJS Overview

Add a JavaScript Spreadsheet to Your Web App in 60 Seconds

Elevate JavaScript Spreadsheets with Designer Ribbon, PivotTable, GanttSheet & ReportSheet

Exploring the JavaScript Pivot Table Add-On

View All Videos
Webinars

Supercharge Your JavaScript Spreadsheets with an AI Assistant

What's New in SpreadJS v17

What's New in SpreadJS v16

What's New in SpreadJS v15

View All Webinars

Award-Winning Products and First-Class Support

Five Star Rating

"I have been using a various form of Spread back to the COM days. Spread is the most reliable spreadsheet that retrieves and stores data, whether interacting with a database or simply an Excel file. Try it out, and you will not go back to any other control"

TRUSTED CUSTOMER

Five Star Rating

"Great support through evaluation process, Spread is my favorite development add-in, adds great, high value capabilities to applications!"

TRUSTED CUSTOMER

Five Star Rating

"Excellent Products. I have been using their products for around 15 years. Always there to help."

TRUSTED CUSTOMER

ComponentSource Award 2024 Top 50 Product Top 50 Product (#31) - Component Source 2025

Customer reviews provided by Feefo

Trusted by the World's Leading Companies

MESCIUS Customers

"Thanks for providing the best [JavaScript] spreadsheet widget in the world, we're very happy customers. Your product has saved us a TON of time relative to other solutions we used in the past."

Jan Domanski, Labstep

"We have been using Spread in our desk and web products (PerpetualBudget) for over a decade. Not only are the Spread grids great controls but the support at GrapeCity [now known as MESCIUS] is the best. When you need them, they're there!"

Jim Spicer, Spicer-Baer Associates

"I haven't come across such a feature-rich solid Spread before. Thanks for giving such a nice component."

Adavesh Managaon, MVP, Visual C#

"Spread benefits my company because our clients can now see the immediate benefit the websites we create for them provide."

Michael Stark, Owner, StarkNetwork.com