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.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.
Opening the AI assistant
- Chat panel — press
Cmd+\(Mac) orCtrl+\(Windows) - Command bar — press
Cmd+K(Mac) orCtrl+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
Chat with data
Ask questions about your data in plain English and get instant answers.
Command bar
Quick AI actions via Cmd+K without opening the full chat.
Data analysis
Uncover insights, trends, and patterns in your data.
Chart generator
Create 30+ chart types from natural language descriptions.
Formula generator
Generate complex formulas from plain English descriptions.
Data cleaning
Clean, deduplicate, and standardize messy data automatically.
Synthetic data
Generate realistic test datasets matching your requirements.
SQL generator
Convert natural language to SQL queries.
Automated reporting
Create live reports that update automatically when data changes.
Web research
Search the web and import data directly into your spreadsheet.
Workflows
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