Skip to content

Spreadsheet editor · Browser + native

XLSX-grade, down to the last border.

A from-scratch formula engine, number-format engine, grid and chart renderer. Real workbooks round-trip through it (import, edit, export, re-import) and nothing gets silently dropped.

↓ This grid is live. Click a cell · type digits in a Qty cell · Enter

q3-sales.xlsx — Lattice
D7fx=SUM(D3:D5)
A
B
C
D
1
2
3
4
Ada
5
6
7
Revenue by product
A
B
C

The chart reads D3:D5 — edit a Qty and watch it recalculate.

Q3AssumptionsP & L+

The formula engine

The grid does the maths. Exactly.

A pure, deterministic evaluator with XLSX-exact semantics: left-associative ^, no cross-type coercion, and errors like #DIV/0! that propagate instead of collapsing. Cycles get caught before they are ever written.

FinancialLogicalTextDate & TimeLookupMaths & TrigStatistical

Formula auditing · Trace precedents

B3 · Qty45
C3 · Price$12.99
D3 · Total=B3*C3 → $584.55

Trace Precedents·Trace Dependents·Goal Seek·Scenario Manager

AI spreadsheet generationPro

The model writes GridMD. The grid renders it live.

Describe the workbook you need. The AI streams GridMD, one line per cell, and Lattice materialises each block as it arrives. Formulas land as formulas, not flattened values, and every generated cell is yours to edit.

MODEL STREAM · .gmd

# Budget@ A1 "FY26 Budget" {bold}```{table} Items at A3| dept   | q1  | q2  || Eng    | 120 | 135 || Design | 45  | 52  |@ C8 =SUM(C4:C5) :: 187

LIVE GRID

FY26 Budget

dept
q1
q2
Eng
120
135
Design
45
52

=SUM(C4:C5) — arrives as a formula

Conditional formatting · Data bars

West4,820
North3,590
East2,310
South1,270
columnbarlineareapiescatterwaterfalltreemapsunburstparetoboxstock+6 more

Formatting & charts

Eighteen chart types. One in-house renderer.

Data bars, colour scales and icon sets evaluate live in-cell. Charts render as SVG with genuine per-type geometry: squarified treemaps, OHLC candles, least-squares trendlines with R². No chart library underneath.

Round-trip fidelity

Import, edit, export, re-import. Nothing breaks.

Styles, borders, number formats and charts are written back via a custom OOXML layer. When an import islossy, it’s labelled honestly, and the original bytes are always kept for download.

CSVXLSXODS
XLSXODSPDF Pro

Daily driving

Built for hands that never leave the keys.

01

Freeze panes & split view

Pin headers, split the viewport, and keep your bearings while you scroll a hundred thousand rows.

02

The fill handle, faithful

Drag to extend a series, copy formulas with relative refs adjusting, double-click to fill down.

03

Validation dropdowns

List, range and custom-formula rules with in-cell pickers. Invalid entries get flagged, never lost.

04

Sort, filter, outline

Multi-key sorts, filter chips per column, and collapsible row groups with subtotals.

05

Keyboard parity

F2 to edit, Ctrl-arrows to jump data edges, Esc to cancel. The muscle memory you already have.

06Pro

Macros, sandboxed

Record actions into replayable JS macros; they run in a worker with no network and undo as one step.

PivotTable · Sum of Revenue

Fields
RegionProductQtyRevenue
Layout
RowsRegion
ColumnsProduct
ValuesΣ Revenue
Region
Widget A
Widget B
Total
West
$48,200
$31,500
$79,700
East
$22,750
$40,100
$62,850
North
$18,600
$27,300
$45,900
Grand Total
$89,550
$98,900
$188,450
PivotChart · by region
West
East
North
Widget AWidget B

Pivots

Reshape the data without touching it.

Drop a range into a pivot, then drag fields into rows, columns and values; the summary builds itself and the source stays exactly as it was. If you’d rather not start from a blank one, Recommended PivotTables proposes a layout from the shape of your data.

A PivotChart binds straight to the pivot, so re-pivoting the table redraws the chart. Note: the structured table underneath keeps a total row and grows on its own as you type new rows.

What-if analysis

Ask the sheet what it’d take.

Goal Seek solves it backwards: name the output you want and the cell that’s allowed to move, and it finds the input (secant, with a bisection fallback, over the real recalc engine).

Data tables sweep one or two inputs across a grid of outcomes, and Scenario Manager keeps your base, low and high cases a click apart. It’s modelling, not just recording what already happened.

What-if · Goal Seek

Set D6 to 1,000,000 by changing B2
B2Unitsinput10,00022,00024,50025,000
D6Revenue=B2*40$400,000$880,000$980,000$1,000,000
Solving — secantSolved — B2 = 25,000

Scenario Manager

B2 → 25,000D6 → $1,000,000

Pricing

Serious grid free. Serious workflows Pro.

CommunityFree forever

$0

  • The full grid + formula engine, live recalc
  • Number formats, cell styles, merges, freeze panes
  • Sort, filter, find & replace, data validation
  • Core charts: column, bar, line, pie
  • CSV import/export · XLSX values + formulas
  • GridMD as a native open format
ProPro

$15 per user / month

  • Full XLSX + ODS round-trip: styles, borders, charts
  • All 18 chart types, pivots, sparklines, slicers
  • Real-time collaboration: cursors, comments, @mentions
  • AI spreadsheet generation, streamed as GridMD
  • Hash-chained version history, one-click restore
  • PDF export · sandboxed JS macros & recorder

Going native

Swift-native on macOS, iOS and iPadOS.

The same engine, recompiled. No web view. Million-cell scrolling at display refresh, keyboard-first on desktop, pencil-friendly review on iPad.

macOSiOSiPadOS

Get in touch

Embedding Lattice in your product?

Licensing, fidelity requirements, or a workbook that won’t round-trip? Send it over.

Send message