Skip to content

Spreadsheets ​

The spreadsheet editor opens Excel (.xlsx), OpenDocument Spreadsheet (.ods) and CSV/TSV files.

Entering data ​

Select a cell and start typing, or type in the formula bar (fx).

InputResult
42, -1.5, 1e3number
12.5%0.125 shown as a percentage
2026-10-01date (shown yyyy-mm-dd)
TRUE / FALSEboolean
=A1*2formula
'007text (a leading apostrophe forces text)

Keyboard ​

KeyAction
Arrows, Page Up/Downmove (with Shift: extend the selection)
Enter / Shift+Enterdown / up (commits an edit)
Tab / Shift+Tabright / left
F2 or double-clickedit the cell
Esccancel the edit
Deleteclear the selection
Ctrl+C / X / Vcopy / cut / paste (tab-separated text, compatible with other spreadsheets)
Ctrl+Z / Yundo / redo
Ctrl+Homego to A1
Ctrl+D / Rfill down / right: the first row (column) of the selection copied over the rest

The status bar shows the count, sum and average of the selected cells.

Filling a series ​

The small square at the bottom right of the selection is the fill handle. Drag it down, up, right or left: the cells it covers continue the selection.

SelectionFilled with
1, 35, 7, 9… (the step of the selection; a trend when the steps differ)
7 alone7, 7… (a single number is copied)
2026-01-30 alonethe next days
Item 1, Week 08Item 2, Week 09…
Monday, Jan, janvier, Q1the next days, months or quarters, round again after the last
=A1*$C$1the formula, its relative references moved (=A2*$C$1…)
anything elserepeated

Each column (filling down) or row (filling right) goes on by itself, and the formatting of the cells comes along. Double-click the handle to fill down as far as the column beside goes. The command palette also has Fill a series into the empty cells of the selection: select the start of the series and the empty cells after it.

Conditional formatting ​

🎨 Conditional formatting… formats the selected cells by their values, and again each time they change:

Format the cells whose value isFor example
compared with a valueless than 10, between 1 and 5, equal to done
a text containing…late (upper or lower case alike)
a duplicate, uniquethe same name twice
above, below the average
among the highest, the lowestthe 3 highest, the lowest 10 %
on a colour scalered for the lowest, green for the highest (two or three colours)
shown as a bara bar as long as the value

Choose the look among the usual ones (light red fill with dark red text, yellow, green, bold, red text) or a custom fill, text colour, bold and italic. Several formats may cover the same cells: the newest wins where two change the same thing. The dialog lists the formats of the selected cells, to delete them. The formats follow inserted and deleted rows and columns, are printed, and are kept in XLSX (conditionalFormatting) and ODS files (as LibreOffice writes them).

Data validation ​

☑ Data validation… sets what the selected cells may hold:

AllowFor example
A value from a listyes / no, written one per line, or the cells holding them ($E$1:$E$9)
A whole number, a numberbetween 1 and 10, greater than 0…
A dateafter 2026-01-01, chosen in a date picker
A text of some lengthat most 20 characters
  • A cell with a list shows ▾: click it, or press Alt+↓, to pick a value (arrows and Enter in the list).
  • Message when the cell is selected: a hint shown under the cell.
  • When the value is wrong: refuse it (the cell keeps what it held), ask whether to keep it, or keep it and tell. The message says what the cell expects, unless you write your own.
  • A value the validation does not accept — kept anyway, pasted, or there before the rule — has a red corner; hover it to read why.
  • Any value in Allow, or Remove the validation, takes it away.

The rules are kept in XLSX (dataValidations) and ODS (table:content-validations) files, so other spreadsheets check the same values. Pasting and filling do not check the values, as in other spreadsheets: look for the red corners.

Formulas ​

Formulas use the usual A1 syntax: =A1+B2, =SUM(A1:A10), =$A$1*B2, =Sheet2!A1, ='My sheet'!B3, whole columns =SUM(A:A).

Operators: + - * / ^, %, & (text concatenation), comparisons = <> < > <= >=.

CategoryFunctions
MathSUM, PRODUCT, SUMSQ, AVERAGE, MEDIAN, MIN, MAX, ROUND, ROUNDUP, ROUNDDOWN, INT, ABS, SIGN, SQRT, POWER, MOD, PI, EXP, LN, LOG, LOG10, TRUNC, CEILING, FLOOR, MROUND, EVEN, ODD, FACT, COMBIN, PERMUT, GCD, LCM, QUOTIENT, RAND, RANDBETWEEN, SUMPRODUCT
TrigonometrySIN, COS, TAN, ASIN, ACOS, ATAN, ATAN2 (x, y), SINH, COSH, TANH, DEGREES, RADIANS (angles in radians)
StatisticsVAR, VARP, STDEV, STDEVP, SLOPE, INTERCEPT, RSQ, CORREL (SLOPE(known_y, known_x)), LARGE, SMALL, RANK / RANK.EQ, MODE, PERCENTILE, QUARTILE, GEOMEAN, AVERAGEA
CountingCOUNT, COUNTA, COUNTBLANK, COUNTIF, SUMIF, AVERAGEIF, and with several criteria COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS
LogicIF, IFERROR, AND, OR, NOT, ISBLANK, ISNUMBER, ISTEXT, IFS, SWITCH, XOR, IFNA, ISERROR, ISERR, ISNA, NA, ISLOGICAL, ISNONTEXT, ISEVEN, ISODD, TRUE, FALSE
TextCONCAT, CONCATENATE, LEN, UPPER, LOWER, TRIM, LEFT, RIGHT, MID, TEXTJOIN, SUBSTITUTE, REPLACE, FIND, SEARCH (wildcards), REPT, PROPER, EXACT, VALUE, TEXT (number format), CHAR, CODE, CLEAN
LookupVLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP, CHOOSE
DatesTODAY, NOW, DATE, YEAR, MONTH, DAY, WEEKDAY, EDATE, EOMONTH, DAYS, DATEDIF, NETWORKDAYS, TIME, HOUR, MINUTE, SECOND

Errors are shown in the cell: #DIV/0!, #VALUE!, #NAME? (unknown function), #REF! (deleted or unknown reference), #N/A, #ERROR! (syntax error) and #CYCLE! (circular reference).

Physical quantities and units ​

A cell can hold a quantity: a number and its unit. Type them together: 12 mm, 3.5 kN, 9.81 m/s², 230 V, 50 km/h, 2.5 kWh. The cell shows 12 mm, the formula bar too, and formulas compute with the units — dimensional analysis, as in physics:

FormulaResultWhy
=A1+A2 with 12 mm and 3 m3012 mmlengths add up, in the unit of the first
=A2+A13.012 m
=A1*A1144 mm²units multiply
=B1*B2 with 2 kN and 0.5 m1 kN·m
=C1/C2 with 100 km and 2 h50 km/h
=D1*D2 with 3 kg and 2 m/s²6 Nseveral units of a named dimension: the named unit
=A1/A20.004same dimension: a pure number
=SQRT(A1*A1)12 mm
=A1+E1 with 12 mm and 2 s#UNIT!a length and a time cannot be added
=A1+1#UNIT!a length and a pure number neither
=SIN(A1)#UNIT!functions of numbers need a dimensionless value

What understands units:

  • + and - (same dimension), *, /, ^ (dimensions combined), comparisons (=, <, >… between the same dimension);
  • SUM, AVERAGE, MIN, MAX, MEDIAN of quantities of one dimension — a column in m, cm and mm adds up correctly; PRODUCT, ABS, ROUND/ROUNDUP/ROUNDDOWN (in the unit shown), SQRT, POWER, COUNT;
  • CONVERT(number; "from"; "to"), as in Excel and LibreOffice (=CONVERT(100;"C";"F") → 212, =CONVERT(1;"in";"mm") → 25.4); given a quantity, it converts it from its own unit: =CONVERT(A3;"km";"mi");
  • QTY(number; "unit") makes a quantity in a formula (=QTY(9.81;"m/s²")*A1), and UNIT(cell) gives the unit of a quantity as text.

Number format › Unit… shows the selected cells in another unit: a quantity is converted (12 mm → 1.2 cm), a plain number gets the unit, a formula is shown in it (=B1*B2 in N·m → 1000 N·m); cells of another dimension are left as they were, and a formula whose result is not of the dimension of its unit shows #UNIT!.

Units known ​

  • SI base units and their prefixes from quecto (q) to quetta (Q): m, g, s, A, K, mol, cd — mm, km, µs (or us), kg, mA…
  • named SI units: N, J, W, Pa, Hz, C, V, Ω (or ohm), F, H, T, Wb, S, lm, lx, Bq, Gy, Sv, kat, rad, sr;
  • others: L (or l), t, eV, Wh, Ah, bar, cal, min, h, d, yr, ha, Å, in, ft, yd, mi, nmi, lb, oz, lbf, gal, atm, psi, mmHg, Torr, hp, °C, °F;
  • combined with · (or *, ., a space) and /, with powers as ², ^2, ^-1 or m2: kN·m, km/h, m/s², kg·m^-3, 1/(mol·L).

°C and °F count as temperature differences in calculations (1 °C = 1 K): to convert a temperature reading, use CONVERT (=CONVERT(20;"C";"K") → 293.15).

In files ​

A quantity is saved as a number in its unit with the unit in its number format (General" mm"), in XLSX and ODS: Excel and LibreOffice show 12 mm and compute with the number (without checking the units); opened again here, the cells are quantities again. A formula giving a quantity is saved with its result in the unit shown. In CSV, quantities are written as 12 mm and read back as quantities. QTY and UNIT are functions of this application: other spreadsheets show #NAME? for them.

Sheets, rows and columns ​

  • + adds a sheet; double-click a tab, or ✎ Rename the sheet…, to rename it; 🗑 deletes the current sheet. References to a renamed sheet are updated.
  • +Row / −Row / +Col / −Col insert or delete rows and columns; formulas referring to moved cells are updated, references to deleted cells become #REF!.
  • The width of a column: drag the right edge of its header (the columns selected all take it), double-click that edge to fit the content, or ↔ Column width… to type it in pixels (auto: fitted). The widths are kept in XLSX and ODS files.
  • Σ inserts a SUM of the numbers above the selected cell.
  • The format list applies a number format (decimals, thousands separator, percent, dates, currency) to the selection; Other format… takes any format code (0.000, # ##0 "kg", dd/mm/yyyy hh:mm…). A cell whose format is not in the list (from a file or a template) shows its code there.

Formatting cells ​

The toolbar formats the selected cells: B I U (also Ctrl+B / I / U), the text colour (A) and the fill colour (▧), borders around each cell (▦), and the alignment (⇤ ↔ ⇥). ⌫ (or Ctrl+Space) removes the formatting and keeps the values and number formats. The buttons show the formatting of the active cell. Formatting is kept in Excel and OpenDocument files and printed.

Freezing rows and columns ​

❄ (Freeze panes) keeps the rows above and the columns left of the active cell in view while the rest scrolls; from A1, it freezes the first row. A thicker line marks the edge. Press it again to unfreeze. Frozen panes are kept in Excel and OpenDocument files.

Sorting ​

⇅ (Sort…) sorts the rows of the selection, or, when a single cell is selected, of the block of filled cells around it. Choose the column to sort by and the order. When the first row looks like a header (text above numbers), it is ticked as one and stays in place; untick it otherwise.

  • Rows move as a whole within the sorted range; cells outside it do not move.
  • Numbers come before text, text is sorted without regard to case or accents, and empty cells always go last.
  • Values are compared as computed: a formula cell sorts by its result, and its relative references follow its row, as when copying.
  • One Ctrl+Z undoes the sort.

Filtering ​

Put the active cell in a table whose first row holds the headings and click ⊻ Filter: each heading gets a ▾ button. Click it to check the values to show in that column (a search field narrows the list; (Empty) stands for empty cells); the other rows of the table are hidden. Filters of several columns combine: a row is shown when it matches all of them. A filtered column's button is highlighted (▼). Show all clears the column's filter; ⊻ Filter again removes the filter.

The arrow keys skip the hidden rows. Values are compared as they are shown (with their number format). The filter and the rows it hides are kept in Excel and OpenDocument files.

Charts ​

  1. Select the data — or just click inside a block of data: the whole block is proposed.
  2. Click 📊 (Insert chart). Choose the type — columns, bars, lines, pie or scatter (X, Y) — and a title; the preview updates as you go.
  3. Click Insert.

The first column gives the categories (the X values for a scatter chart), each other column is a series; tick First row contains series names when the range starts with headers (detected automatically). Charts update as soon as the data changes, and follow inserted or deleted rows and columns.

Drag a chart to move it, drag its corner to resize it. Its buttons (shown on hover or focus): ✎ edit, ⧉ copy as an image — then paste it into a text document or a slide — and 🗑 delete (or Delete when the chart has the focus; Enter edits it). The AI assistant can also add charts.

Charts are saved as real charts in XLSX and ODS files, so Excel and LibreOffice show them (and Progressive Web Office reads them back); CSV files keep only the data. Charts are printed with their sheet.

Formats ​

FeatureXLSXODSCSV
Several sheets✅✅current sheet only
Formulas✅✅ (OpenFormula)computed values
Number formats✅✅dates as yyyy-mm-dd
Column widths✅✅—
Charts✅✅—

CSV import detects the delimiter (, ; tab |), accepts UTF-8 and Windows-1252 files and never turns cells starting with = into formulas (protection against CSV injection). Fonts, colours, borders, merged cells and pivot tables are not preserved; chart styling made in other applications (colours, 3-D, secondary axes) is replaced by Progressive Web Office's.