How to Set Up Sourcetable for AI Data Analysis

What Sourcetable Does and Why It Matters

Sourcetable is a browser-based spreadsheet that adds AI analysis, 900+ live data connectors, and server-side processing on top of the familiar rows-and-columns interface. Unlike traditional spreadsheets, it handles files up to 10 GB and over one million rows without crashing your browser. The processing runs server-side using Apache Arrow and DuckDB, so your laptop does not become the bottleneck.

For analysts, ops managers, and founders who spend hours copying data between tools, the pitch is simple: connect your data source once, ask questions in plain English, and get charts, summaries, or cleaned tables back in seconds. Companies including McKinsey, JPMorgan, and Amazon already use the platform for internal analysis workflows.

Step 1: Create Your Account

Go to sourcetable.com and click the sign-up button. You can register with an email address or use Google SSO. No credit card is required. The free plan gives you basic spreadsheet functionality, file uploads, charts, and collaboration. A 7-day trial of the Pro plan ($20/month when paid monthly) unlocks AI features, unlimited connectors, and advanced analysis.

Students and educators with a .edu email get 50% off Pro and Max plans. Nonprofits qualify for the same discount.

Once registered, you land on a dashboard showing your workbooks. This is your home base for creating new sheets, connecting data sources, and managing shared workbooks.

Step 2: Upload Your First Dataset

Click "New Workbook" and choose how to bring data in. Sourcetable supports direct file uploads in Excel (.xlsx, .xls), CSV, TSV, JSON, and PDF formats. Drag a file into the upload area or browse your local drive.

For a quick test, upload a CSV export from any tool you already use. Sales data from your CRM, transaction logs from Stripe, or survey responses from Google Forms all work. The platform auto-detects column types and structures the data into a clean table.

If your file has formatting issues or merged cells from a legacy Excel export, the AI cleaning tools handle most of those automatically. You will see a preview before the data lands in your workbook.

Step 3: Connect a Live Data Source

Sourcetable's real power shows up when you connect live data instead of static files. Go to the connectors panel and browse the 900+ available integrations. Popular options include PostgreSQL, MySQL, MongoDB, BigQuery, Stripe, Google Analytics (GA4), Facebook Ads, Notion, Airtable, and Supabase.

To connect a database, enter your host, port, database name, and credentials. For SaaS connectors like Stripe or GA4, you authenticate via OAuth in a few clicks. Once connected, Sourcetable syncs the data and keeps it current, so your analysis always reflects the latest numbers.

This matters because it eliminates the manual export-import cycle that eats hours every week. Instead of downloading a CSV from Stripe, uploading it to Google Sheets, and building formulas by hand, you get a live connection that updates itself.

Step 4: Analyze Data with the AI Assistant

With your data loaded, click the AI assistant button in the toolbar. A chat panel opens on the right side of the screen. Type a question in plain English, and the AI responds with analysis, charts, or transformed data directly in your spreadsheet.

Example prompts that work well:

• "Show me monthly revenue trends for the last 12 months"
• "Which product category has the highest return rate?"
• "Clean up the address column and split it into city, state, and zip"
• "Create a pivot table of sales by region and quarter"
• "Flag any rows where the total does not match the sum of line items"

The AI uses multiple LLMs under the hood, including Claude and GPT models, and routes to whichever handles your specific task best. It can generate Python code, write SQL queries, or build formulas depending on what the analysis requires. You do not need to know which approach is being used.

For heavier analysis, the platform supports Python libraries including Pandas, NumPy, SciPy, Scikit-learn, and Matplotlib. The AI can write and execute Python scripts on your behalf when the task calls for statistical modeling or machine learning.

Step 5: Build Charts and Visualizations

After running analysis, ask the AI to visualize the results. Type something like "Create a bar chart of revenue by month" or "Show a scatter plot of price vs. units sold." The Chart Generator creates interactive charts directly in your workbook. You can resize, reposition, and style them manually, or let the AI handle the formatting.

Sourcetable supports bar charts, line charts, scatter plots, pie charts, area charts, and combination charts. Each chart stays linked to the underlying data, so when the source updates, the visualization updates too.

For dashboards, arrange multiple charts on a single sheet. This gives you a live reporting view that refreshes automatically when connected to a live data source.

Step 6: Create AI Workflows for Repeatable Tasks

Sourcetable's AI Workflows feature turns a one-time AI chat session into a reusable automation. After completing an analysis you want to repeat, save the conversation as a workflow with one click. The workflow becomes a text-based instruction set that tells the AI what to do, and you can run it on any workbook across your organization.

Practical examples:

• A weekly sales report that pulls data from your CRM connector, calculates KPIs, and generates a formatted summary table
• A data cleaning pipeline that standardizes addresses, removes duplicates, and flags anomalies in uploaded CSV files
• A monthly financial dashboard that connects to your accounting database and produces charts for revenue, expenses, and margins

Workflows are fully editable and require no code. Think of them as macros powered by AI: flexible enough to handle variations in the data while following a consistent process. They run across the team, so one analyst can build a workflow and share it with the entire department.

Step 7: Collaborate and Share Results

Sourcetable supports real-time collaboration similar to Google Sheets. Invite team members with three permission levels: Owner, Editor, or Viewer. Multiple users can edit the same workbook simultaneously with live cursor tracking and cell-level commenting.

For external sharing, generate a shareable link with customizable expiration dates and guest access. Export finished work as CSV, Excel, or PDF. Version history tracks every change with user attribution and timestamps, so you can roll back to any previous state.

All collaboration features are available on the free plan. The platform also logs an audit trail of changes with timestamps and IP addresses for compliance-sensitive environments.

What Sourcetable Costs

The free plan covers basic spreadsheet functions, file uploads, charts, and collaboration at no cost. The Pro plan at $20/month (or $566/year with annual billing, a 20% discount) adds AI features, unlimited data connectors, and advanced analysis tools. A 7-day free trial of Pro requires no credit card.

Enterprise plans include dedicated support, custom integrations, and enhanced security controls at custom pricing. Professional services for implementation start at $2,500.

For teams already paying for separate BI tools, ETL connectors, and spreadsheet licenses, Sourcetable can consolidate several line items into one. Whether that trade-off works depends on how heavily your team relies on specialized BI features that Sourcetable does not yet replicate.

If you want to skip the connector setup and jump straight to asking questions about your data, VSLZ handles the entire pipeline from file upload to insight in a single prompt with no configuration needed.

Practical Summary

Sign up, connect your data, and start asking questions. The free tier is enough to test whether the AI analysis fits your workflow. If you run recurring reports or clean the same type of data every week, the Workflows feature alone can save significant time. Start with one dataset you already know well so you can verify the AI output against your own expectations before expanding to more complex use cases.