python code execution in spreadsheet cells
Execute Python code directly within spreadsheet cells, treating cells as executable code blocks that can reference other cells and produce computed results. Supports libraries like pandas, numpy, and scikit-learn for data manipulation and analysis.
sql query execution against spreadsheet data
Write and execute SQL queries directly in cells to query, filter, and aggregate data stored in the spreadsheet. Enables complex joins and transformations using familiar SQL syntax without exporting data.
formula and code syntax validation
Validate Python code, SQL queries, and spreadsheet formulas in real-time, providing error detection and suggestions before execution. Prevents runtime errors and improves code quality.
shareable executable spreadsheet publishing
Publish spreadsheets as shareable, executable documents that others can view, interact with, and run without needing a Quadratic account. Preserves code and computation while enabling read-only or limited-edit sharing.
computational notebook-style cell execution
Execute cells in sequence or independently, with output displayed inline and state preserved across cell executions. Provides Jupyter-like notebook experience within spreadsheet interface.
type inference and schema detection
Automatically detect data types and infer schema from imported or entered data, reducing manual type specification. Applies type information to enable better code completion and error detection.
ai-assisted formula and code generation
Generate spreadsheet formulas and Python/SQL code snippets using natural language prompts powered by AI. Reduces boilerplate code and accelerates formula creation for common data operations.
real-time collaborative spreadsheet editing
Enable multiple users to edit the same spreadsheet simultaneously with live updates, cursor tracking, and conflict resolution. Changes propagate instantly across all connected clients.
+6 more capabilities