> ## Documentation Index
> Fetch the complete documentation index at: https://sourcetable.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# AI features overview

> Sourcetable's AI assistant helps you analyze data, generate formulas, create charts, and automate tasks using natural language.

Sourcetable has a native AI assistant built into the spreadsheet. You interact with it through natural language — describe what you want, and it does it. No code required, though it uses Python, SQL, and advanced data science libraries under the hood.

## Opening the AI assistant

* **Chat panel** — press `Cmd+\` (Mac) or `Ctrl+\` (Windows)
* **Command bar** — press `Cmd+K` (Mac) or `Ctrl+K` (Windows) for quick actions

## AI modes

The chat panel includes specialized modes you can select from the mode dropdown:

| Mode | What it does |
| - | - |
| **Calculate** | Perform quantitative calculations and analysis |
| **Formula** | Write, explain, or fix spreadsheet formulas |
| **Chart** | Create charts and visualizations |
| **Query** | Run SQL queries against your data |
| **Modify** | Transform, clean, or restructure data |
| **Generate** | Create sample or synthetic data |
| **Analyze** | Perform qualitative analysis and insights |
| **EDA** | Run exploratory data analysis |
| **Autopilot** | Automate multi-step spreadsheet tasks |
| **Template** | Generate formatted table templates |
| **Public Dataset** | Find and import public datasets |
| **Predict** | Machine learning predictions (TabPFN) |
| **Classify** | Machine learning classification (TabPFN) |

## What the AI can do

> [card] [Chat with data](https://sourcetable.com/docs/ai/chat.md)
>
> Ask questions about your data in plain English and get instant answers.

> [card] [Command bar](https://sourcetable.com/docs/ai/command-bar.md)
>
> Quick AI actions via Cmd+K without opening the full chat.

> [card] [Data analysis](https://sourcetable.com/docs/ai/data-analysis.md)
>
> Uncover insights, trends, and patterns in your data.

> [card] [Chart generator](https://sourcetable.com/docs/ai/chart-generator.md)
>
> Create 30+ chart types from natural language descriptions.

> [card] [Formula generator](https://sourcetable.com/docs/ai/formula-generator.md)
>
> Generate complex formulas from plain English descriptions.

> [card] [Data cleaning](https://sourcetable.com/docs/ai/data-cleaning.md)
>
> Clean, deduplicate, and standardize messy data automatically.

> [card] [Synthetic data](https://sourcetable.com/docs/ai/synthetic-data.md)
>
> Generate realistic test datasets matching your requirements.

> [card] [SQL generator](https://sourcetable.com/docs/ai/sql-generator.md)
>
> Convert natural language to SQL queries.

> [card] [Automated reporting](https://sourcetable.com/docs/ai/automated-reporting.md)
>
> Create live reports that update automatically when data changes.

> [card] [Web research](https://sourcetable.com/docs/ai/web-research.md)
>
> Search the web and import data directly into your spreadsheet.

> [card] [Workflows](https://sourcetable.com/docs/ai/workflows.md)
>
> Save and reuse multi-step AI workflows.

## Scope control

You can control what data the AI assistant has access to when answering your questions. Click the scope selector in the chat panel to choose:

* **Current sheet** — AI sees only the active sheet
* **Specific range** — AI sees only the cells you select
* **Connected data** — AI can query your connected databases and integrations
* **Uploaded files** — attach files directly in the chat

## AI models

Sourcetable uses multiple AI models including OpenAI, Claude, Llama, and Hugging Face models. Pro and Max plan users can select their preferred model. See [AI models reference](https://sourcetable.com/docs/reference/ai-models.md) for details.

## Voice input

Click the microphone button in the chat panel to speak your request. Sourcetable uses Whisper speech recognition to transcribe your voice into text.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.