Skip to main content
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:

​
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

​
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 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.