AI Sheets

What is AI Sheets?

AI Sheets is Genspark's autonomous AI spreadsheet agent that turns data analysis into natural conversation. Simply describe what you need — AI handles data collection, analysis, and visualization automatically.

• Multi-Source Data — Web scraping, file uploads, or database connections in one prompt
• Autonomous Analysis — Clean messy records, compare performance, forecast trends, discover patterns, calculate metrics, etc
• Native Excel Compatible — Full support for .xlsx format with seamless import/export and generation of standard Excel formulas
• Smart Visualization & Styling — Transform raw spreadsheets into polished, presentation-ready tables with formatting and design, generate professional charts based on your needs
• Actionable Insights — Extract key findings and strategic recommendations for decision-making

Quick Start

Get started in three simple steps:

1. Go to AI Sheets:

   Click "AI Sheets" at the bottom of Genspark homepage, or select it from the "+"(New) button in the sidebar

2. Describe your needs:

   Tell AI what you want to analyze. Sample prompts:

   Compile NVIDIA's financial statements from FY2021 to FY2025.

   Try this

   Analyze sales trends from the uploaded Excel and visualize performance by region.

   Try this

3. Get results:

   Based on your needs, AI automatically selects and executes the right analysis steps — cleaning messy data, writing SQL queries for databases, running Jupyter for statistical analysis, generating Excel formulas, or creating visualizations. All code and logic are transparent.

   Edit directly in the sheet, refine with follow-up prompts, or export as .xlsx for further use.

Feature Guide

Data Collection

AI Sheets automatically collects structured data from authoritative sources:

Professional Databases: Genspark integrates specialized databases across different domains:

• Financial Data - SEC (public company filings, 10-K/10-Q, etc.), Yahoo Finance (stock prices, etc.)
• Academic Data - Google Scholar (papers, citations, research trends, etc.)
• Product Data - Amazon (product information, pricing, reviews, etc.)

General Web Data: For non-database data, AI retrieves high-quality information from public web sources based on your needs, with cross-validation of critical data from multiple sources to ensure accuracy.

Data Extraction

AI Sheets supports data extraction and analysis from multiple sources:

Upload Files via Chat: Upload local files directly (Excel, PDF, Word, images, etc.), and AI will automatically extract and analyze the data.

Connect Data Sources via MCP: On the Genspark homepage or within AI Sheets, click the "Tools" button in the chat box, open the MCP page, select the tool you want to connect, and follow the instructions to complete the setup. Once connected, you can use prompts to have AI directly query the data source and perform analysis. Currently supported:

• Google Drive - Access cloud files, extract documents and spreadsheet data
• Supabase - Connect to your database, execute SQL queries and data analysis
• Custom MCP - Other MCP tools that meet AI Sheets query requirements, which can connect to enterprise databases

Sheet Operations

AI Sheets features a built-in web-based spreadsheet editor that supports both manual editing and AI-assisted editing:

Manual Editing: You can operate the spreadsheet just like Excel:

• Copy, paste, cut, delete data
• Use common Excel formulas for data processing and analysis
• Create and adjust charts, including: Area charts, Bar charts, Column charts, Line charts, Pie charts, Doughnut charts, Scatter charts, Funnel charts, Radar charts, Treemap charts, Waterfall charts
• Format settings and style adjustments
• Add and delete worksheets

Click the "Full Screen" button in the upper right corner to enter full-screen editing mode for more workspace.

AI Editing: You can also direct AI to perform spreadsheet operations using natural language:

• Generate Formulas - Describe calculation logic in natural language, and AI automatically generates the corresponding Excel formula

Show what percentage each product contributes to overall revenue

Calculate the compound annual growth rate (CAGR) from 2020 to 2024

Add a column that shows "High" if sales > 10000, "Medium" if between 5000-10000, otherwise "Low"

• Generate Charts - Describe visualization needs, and AI auto-selects the appropriate chart type and generates it

Visualize the market share comparison between competitors using a pie chart

Generate a bar chart comparing sales performance across different regions

Show customer satisfaction performance by department using a radar chart

• Focused Area Editing (Send to Chat) - After selecting a cell range, click the "Send to Chat" button to send the selected area to the chat box. You can direct AI to perform content corrections, in-depth analysis, or chart generation for that specific area

Analyze the selected data and identify the top 3 anomalies or outliers

Highlight duplicate values in the selected customer ID column

Standardize all phone numbers in the selected range to (XXX) XXX-XXXX format

Analysis & Insight

You can ask questions about spreadsheet content, and AI will provide answers with cell references. You can also have AI deeply explore the data and generate insights, with the agent creating beautiful visualization dashboards using HTML tools.

Share & Export

• Share: Click "Share" in the top right corner, adjust permission settings, and share your project link for viewing or collaborative editing
• Export: Click "Export" in the upper left corner of the editor to export as XLSX format with formatting, formulas, and calculations fully preserved — compatible with any Excel software

Pro Tips

Break Down Complex Tasks into Steps

• For multi-step analysis tasks, have AI complete data collection and cleaning first, then proceed with in-depth analysis
• Split complex tasks into multiple instructions, verify results after each step before telling AI to proceed to the next step to avoid errors that could impact the final results
• Sample: Financial Analysis on NVIDIA

Collect NVIDIA's revenue, net income, and operating margin data from FY2020 to FY2024.

Calculate year-over-year growth rates for revenue and net income, and visualize the trends.

Analyze what drove the revenue growth in FY2024, compare with industry benchmarks, and provide strategic insights.

• Sample: ROI Analysis of Marketing Campaign

Use my marketing campaign data and calculate total spend, conversions, and revenue generated by each campaign.

Based on the results, calculate ROI and cost per conversion for each campaign, then rank them by performance.

For the top 3 campaigns, analyze which channels and audience segments performed best, and recommend budget allocation for next quarter.

Multi-Sheet Collaborative Analysis

When working with complex data that spans multiple dimensions, leverage AI Sheets' multi-tab capabilities to understand existing workbook structures and perform cross-sheet relational analysis automatically.

• Upload existing multi-tab spreadsheets and ask AI to explain complex formulas and model structures
• Create multiple sheets within a single project for organized data management
• Use natural language to direct cross-sheet analysis

Link sales data from Sheet1 with inventory data from Sheet2 to generate a restocking recommendation table

Reduce Conversation Rounds per Project

• When there are too many conversation rounds, AI may lose performance due to context compression
• Whenever the context becomes too long, create a new Sheets agent project

FAQ

Q: Can AI Sheets be used on mobile devices? What features are supported on mobile?

AI Sheets currently only supports viewing results on mobile devices. We recommend using a desktop computer for full functionality.

Q: Can AI Sheets use specific statistical methods (such as regression analysis, hypothesis testing) for analysis?

AI Sheets supports most data analysis that can be accomplished through Excel formulas, including statistical analysis.

Q: What is the data limit that AI Sheets can support?

Theoretically supports operations on up to one million cells (depending on your computer's hardware performance, as AI performs spreadsheet operations in the browser, so ensure sufficient machine resources are available to avoid lag and memory overload).

Q: What should I do if AI Sheets makes an error?

Clearly indicate to AI what the error is and how it should be corrected, promptly export and backup results locally, and break complex tasks into a series of simpler tasks. For tasks requiring high accuracy, be sure to review all changes before finalizing the output.

Need further assistance? If you cannot resolve the issue or have specific feature requests, please contact us via email.

Q: What security considerations should I be aware of when using AI Sheets?

We prioritize data security. Your data is private and is never used for other purposes.

User Best Practices:

• Source Validation: Be cautious with files from untrusted sources, as hidden content could mislead the AI.
• Access Control: Please ensure project sharing permissions are set correctly to prevent unauthorized access.

Q: What Excel features are incompatible with AI Sheets?

The following are currently not supported:

• Macros & VBA Execution: You cannot execute VBA scripts natively within AI Sheets. However, AI can generate VBA code for you to copy and run in desktop Excel.
• Excel Native Data Connections: Legacy connections (ODBC, OLEDB, External Links) are not supported
• Complex/Legacy Charts: Such as 3D charts or specific specialized diagrams.
• User-Defined Functions (UDFs)
• Power Query, Power Pivot