Spreadsheets
Smart data and formulas at your fingertips
A full-featured spreadsheet engine with 50+ formula functions, pivot tables, charts, and AI-powered cells. Write formulas in plain English, auto-generate charts, and connect your data to every other app in your workspace. Your numbers are never siloed again.
Data & Formulas
A serious formula engine with everything from SUM to advanced array calculations.
50+ built-in functions
Math, statistics, text, date, lookup, and logical functions. Full autocomplete with signature documentation as you type.
AI cells
Describe a calculation in plain English — "average revenue per customer last quarter" — and the agent writes the formula for you. See a live streaming preview while it processes.
Named ranges
Assign names to cell ranges for more readable formulas. "=SUM(revenue)" instead of "=SUM(B2:B150)".
Array formulas with spill
Formulas that return multiple values automatically spill into adjacent cells. No Ctrl+Shift+Enter needed.
Cross-sheet references
Reference cells in other sheets within the same workbook. Build complex models with clean separation of concerns.
Formula dependency tracking
See which cells depend on the current cell. Trace formula chains visually to debug complex calculations.
Visualization
Turn your data into charts, pivot tables, and visual insights — with or without the agent.
Charts
Bar, line, pie, scatter, and area charts. Auto-detection suggests the best chart type for your data selection.
Pivot tables
Configure row, column, value, and filter fields. Drag-and-drop pivoting for fast data exploration.
Data structure detection
The agent analyzes your data and recommends the best way to visualize it — before you even ask.
Interactive chart editing
Click into any chart to adjust axes, labels, colors, and data ranges. Charts update live as data changes.
Formatting & Tools
Pixel-perfect formatting and the productivity tools you expect from a professional spreadsheet.
Number formats
Currency, percentage, date, time, scientific, and custom number formats. Locale-aware formatting.
Cell styling
Font family, size, weight, color, alignment, borders, and background colors. Style cells, ranges, or entire sheets.
Find and replace
Search across cells and sheets. Replace values individually or in bulk with preview.
Merge cells, freeze panes, auto-fit
Merge cells for headers, freeze rows and columns for navigation, and auto-fit column widths to content.
AI-Powered
The agent makes spreadsheets smarter
Every feature in Spreadsheets is enhanced by the Prophet Agent. Ask it to help, and it uses context from your entire workspace.
Natural language formulas
Type what you want to calculate in plain English. The agent writes the formula, handles edge cases, and explains what it did. No formula syntax required.
Streaming AI preview
While the agent processes your request, you see a live streaming preview with animated text — so you know exactly what's happening before the result lands.
Auto-generate charts
Select a data range and ask the agent to visualize it. It picks the best chart type, configures axes, and generates a presentation-ready chart in seconds.
Data analysis on demand
Ask the agent to find trends, outliers, correlations, or summaries in your data. Get answers in natural language with supporting formulas.
Connected
Spreadsheets connects to everything
Spreadsheets isn't a standalone tool — it's part of the Prophet platform. Data, context, and actions flow freely between all your apps.
Embed live spreadsheet data in documents. Tables and charts update automatically when the underlying data changes.
The agent can build chart slides directly from spreadsheet data. Revenue chart? Sales breakdown? One prompt.
Generate sprint velocity reports, burndown charts, or resource allocation spreadsheets from your project data.
@mention a spreadsheet in chat to share data in context. The agent can summarize key metrics for the team.
Try Spreadsheets — and everything else
Spreadsheets is one of many professional-grade apps built fresh for the age of AI. Add the agent, Builder, and real-time collaboration — all free to start.