UnitSheet
The spreadsheet with units
Work with units, not just numbers.
A unit-aware spreadsheet for scientists, engineers, educators, and students. Cells hold value and unit together, so formulas stay dimensionally correct and conversions happen automatically. Ordinary spreadsheets treat units as comments — a mislabeled cell or mixed dimension can silently produce a meaningless value — or worse, a catastrophic failure.
- 320 units
- 64 dimensions
- 113 functions
Try the live workbook — no account needed
#UNIT in the grid — not in a
comment.Try the quantity engine
The same arithmetic as a workbook, in the browser.
No account needed.
Pick an example expression to calculate, or write your own.
Open the full calculator with expressions and the unit and currency catalog →
The problem with ordinary spreadsheets
Silent failures
Wrong units can produce plausible numbers. Nothing flags that your result is meaningless.
Manual conversion
You maintain lookup tables, sanity checks, and unit-checking formulas by hand.
No dimensional guardrails
Adding meters to seconds is allowed. The sheet has no idea the answer is nonsense.
How UnitSheet is different
Units are data
Dimensions travel with values through every formula.
=25mi / 35min → mph → 42.86mph
Automatic conversion
Same-dimension arithmetic converts in place — results follow the first term's unit.
=5m + 3ft → 5.9144m
Errors, not lies
Incompatible dimensions surface as errors, not quiet wrong answers.
=5m + 3s → #UNIT
A full workbook, not just a unit converter
Signed-in users get a live spreadsheet that evaluates in the browser with that same engine.
Fill a column, import a lab CSV, keep multiple sheets, name a lab unit
(1 slab = 1 in), and scan for #UNIT errors.
qty × price is money; ISO dates and instants are types.
Share a workbook with a lab partner — view or edit.
Try it in the live workbook — no account needed
->, symbols autocomplete with their
dimension — no CONVERT strings.Open the catalog in the live workbook
The same 320 units the calculator and autocomplete use, grouped by dimension, plus currencies.
Live grid
Formula bar, multiple sheets, fill down/right, and Go To. Arrow keys, fill handle, and A1 references work the way a spreadsheet should.
CSV in and out
Import a measurement file. A header like length (m) turns bare numbers into quantities,
Amount ($) into money, and Price ($/lb) into a price.
Export cell contents, not stripped values.
Your units
Name a symbol as a scale of an existing unit (1 slab = 1 in). Then
10slab and =A1 → slab work like built-ins.
Tools → Custom units.
Share a workbook
File → Share invites a UnitSheet account to view or edit. Viewers can open, export, and print. Editors change cells, sheets, and units. Partners see updates within about a second.
Money and price
$12.50 and $3.50/kg are types, not formats.
=2.5 kg * $3.50/kg is money; same-currency arithmetic just works.
Dates and times
ISO dates, times of day, and UTC instants are cell types.
=2026-09-20 + 10 d and =NOW() stay on a time axis, not text.
Built for technical work
For anyone who thinks in meters, newtons, kelvin, or ampere-hours — analysis, teaching, and verification, not general office use.
Create a free account. Quantity arithmetic, live workbooks, custom units, CSV, sharing, and the public calculator are in place.
Ready to work with real quantities?
Create your free account and open your first workbook in a minute.
Already have one? Log in