What is Sigma’s Spreadsheet UI?

Sigma’s Spreadsheet UI is a spreadsheet-style way to work on warehouse data. The data stays in your warehouse, so you don’t need exports or extracts.

How are Sigma workbooks and sheets organized?

Workbooks are like spreadsheet files. Pages are like sheets (tabs), and a page can include tables, pivots, charts, filters, and text.

How do calculations work in Sigma?

Sigma is mostly column-based, not cell-by-cell. You define a calculation once and apply it across the dataset, with work pushed to the warehouse.

What are Input Tables, and what does “writeback” mean?

Input Tables let people add rows and edit values in Sigma. Those changes can be written back to a warehouse table so downstream work can use them.

When should I use an Input Table vs. modeling upstream?

Use an Input Table when the source of truth is human input like forecasts, assignments, approvals, or notes. Model upstream when values should be derived from systems or business logic.

How do Pivot Tables work in Sigma?

Pivot Tables summarize data across dimensions using live warehouse queries. You can group fields, add measures, show totals, and drill into details.

No exports. Excel on the cloud.

It looks like a spreadsheet, but it scales to billions of rows and updates your warehouse in real-time. Stop exporting to CSV.

Request a Demo

About Spreadsheets in Sigma

Teams don’t want to give up Excel. They want to fix it. Sigma keeps the grid, formulas, and pivots people rely on, but runs them on live warehouse data. With Sigma there is no need for exports, version chaos, or row limits. Just governed flexibility at enterprise scale.

Trusted by finance and corporate strategy teams at leading global enterprises

Familiar to everyone

Skip the training curve. Sigma's spreadsheet interface lets teams work with formulas, pivots, and filters—just like Excel—but connected to live warehouse data.

Writeback for planning

Capture human inputs alongside live data. Input tables let you type budgets, goals, and scenarios directly into Sigma, then compare them to actuals in real time.

Every change tracked

Built-in audit trail shows who changed what, when—no more emailing files or wondering which version is correct.

Work the way you know

The only platform where you can analyze data, input new values, and trigger warehouse actions in a single, governed loop, all from a familiar interface

Plan and write back with Input Tables

Input Tables are built for the moments when humans need to add or change values, not just analyze them.

Type budgets, targets, and scenarios alongside live actuals
Edit cells or paste rows into Input Tables
Write updates back to a warehouse table
Keep a full audit trail of changes

AN INTRODUCTION TO INPUT TABLES

Use familiar formulas

Work with 200+ functions on billions of rows of live data in your warehouse. No proprietary coding required.

Logical & Text: Clean and manipulate strings at scale.
Window & Rank: Perform advanced analytics across partitions.
Date & Time: Handle complex time-series logic easily.

SEE THE 200+ SPREADSHEET FORMULAS

AI in spreadsheet columns

Use AI Query to generate new values from your data and bring the result back into the spreadsheet. Once it’s in a column, you can filter, pivot, and chart it like anything else.

Create AI-derived fields as columns you can analyze
Use AI Query functions to call a warehouse function and return results to the sheet
Keep your workflow in one governed workbook, on live warehouse data

LEARN HOW AI QUERY WORKS