Which formulas and functions does it support?

Arithmetic with +, -, *, / and ^, a percent sign (50% is 0.5), & to join text, and the comparisons =, <>, and >=, which give TRUE or FALSE. References can be relative (B2), fixed with $ ($B$2 or B$2), a range (A1:C9) or on another sheet (Sheet2!A1, or 'Q3 figures'!A1 when the name has a space). The functions are SUM, AVERAGE, MIN, MAX, COUNT and IF, in any letter case. Inside a range, SUM, AVERAGE, MIN and MAX use the numbers and skip text, TRUE/FALSE and empty cells, and COUNT counts the numbers and skips errors as well. Any other function name shows #NAME? and is never run, and there are no macros, named ranges or links to other files. A minus sign binds before ^ and ^ works left to right, so -2^2 is 4 and 2^3^2 is 64.

What happens with a circular reference?

Every cell in the loop shows #CYCLE!, and the inspector names the path, for example Circular reference: A1 → B1 → A1. A cell that reads a looping cell shows #CYCLE! too, with a note saying which cell the error comes from. Nothing is iterated or guessed, so changing any cell on the path recalculates the rest. IF only follows the branch its test picks, so =IF(B1>0, A1, 7) typed into A1 is a loop only while B1 is above zero; otherwise A1 shows 7.

How does sorting treat formulas and the header row?

Sort A to Z and Sort Z to A in the Data menu move whole rows by the column of the selected cell: every cell in a row moves together with its format. If you select two or more rows, just those rows are sorted; otherwise every row down to the last filled one is, and row 1 stays in place while Row 1 is a header is ticked. In A to Z order numbers come before text, then TRUE and FALSE, then errors, and Z to A reverses that; empty cells stay at the bottom either way, text ignores letter case and ties keep their order. A moved formula behaves like a copied one: its relative references shift by the rows it moved, so =B2*10 still reads its own row, while $ references stay put. Formulas outside the sorted rows are not rewritten.

What does the CSV download do with text that looks like a formula?

Text that starts with =, +, -, @, a tab or a line break, or with spaces and then one of =, +, - or @, is written with a leading apostrophe, so a spreadsheet program treats it as text instead of running it. Numbers, negative ones included, are written as numbers. The file holds the sheet you are on, as calculated values from A1 to its last filled cell: numbers to 15 significant digits, TRUE and FALSE, and errors as their code, such as #DIV/0!. Fields with commas, quotes or line breaks are quoted by the CSV rules, and CSV and TSV downloads begin with a UTF-8 byte order mark so accented letters open correctly. To keep the formulas themselves, download the project instead.

Can I paste from Excel or Google Sheets?

Yes. Select a cell and press Ctrl+V or Cmd+V: tab-separated rows land from that cell down and to the right, and a copied cell with line breaks inside quotes stays whole. Pasted text is always a value, never a formula, and leading zeros such as 007 or numbers with more than 15 significant digits stay text so no digit is lost. File, Paste rows as text takes comma- or semicolon-separated rows as well. Ctrl+C or Cmd+C copies the selected cells as tab-separated values, with formula-like text given an apostrophe the same way as in the CSV.

How big can a workbook be, and can it open Excel files?

Up to ten sheets and 10,000 filled or formatted cells in total, on a grid that runs from A1 to ZZ100000. A file, paste or edit that would go past a limit is refused with the reason, and nothing is cut off or half imported. It opens CSV and TSV files and projects saved from this page. An .xlsx workbook is recognised and refused, so save it as CSV first, for example with the spreadsheet converter. Semicolon-separated files are detected, and a file that is not UTF-8 is read as Windows-1252 and the page says so. Files are read in the background and a read can be cancelled; one that takes longer than 2 minutes is stopped.

Where is my work saved?

In this browser's local storage, a moment after each change, along with the sheet you were on. Nothing is uploaded: files are read by a background worker on this page. If the browser blocks or fills its storage, the page says so and the workbook stays open until you close the tab, so download the project to keep it. Start over, above the tool, clears the saved copy, and Undo and Redo reach back 50 steps.

Spreadsheet Editor

A new spreadsheet opens on the first screen: a grid with Sheet1, a formula bar, File, Edit, Insert and Data menus, and an inspector that shows the selected cell's formula, its value or error, the cells it uses and the formulas that use it. Formulas are read by this page's own parser, which knows arithmetic (+, -, *, /, ^, % and & for joining text), comparisons, references such as B2, $B$2, Sheet2!A1 or 'Q3 figures'!A1:C9, and exactly six functions: SUM, AVERAGE, MIN, MAX, COUNT and IF. Any other function shows #NAME? and is never run. Every edit recalculates the whole workbook, and the formulas whose values changed are listed in the inspector. A circular reference shows #CYCLE! in each cell of the loop, with the path, and IF only follows the branch its test picks. Sorting moves whole rows, formats and formulas included. Open a CSV, a TSV or a project saved here, or paste tab-separated rows: text from a CSV, a TSV or a paste is always kept as a value, never read as a formula, and CSV and TSV downloads put an apostrophe before text that a spreadsheet program would run as a formula. A workbook holds up to ten sheets and 10,000 filled or formatted cells, and a change past those limits is refused rather than cut short. The workbook is kept in this browser's storage and is never uploaded.

Number format

Go to a cell or rangeContents of A1

	A	B	C	D	E	F	G	H	I	J
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

Cells used: 0 of 10,000

Formulas: 0

Errors: 0

Sheets: 1 of 10

New spreadsheet: Sheet1 is empty. Select a cell and type a number, some text or a formula such as =SUM(A1:A3).

Type in a cell or the formula bar, then Enter. Shift+Enter adds a line break, Escape cancels, Delete clears, Ctrl or Cmd with Z undoes, and Ctrl or Cmd with C, X or V copies, cuts or pastes tab-separated rows.

A total that follows its inputsA1 2, A2 3, A3 =SUM(A1:A2)
A3 shows 5; change A1 to 4 and it shows 7.
A circular referenceA1 =B1, B1 =A1, C1 =A1+1
A1 and B1 show #CYCLE!, and so does C1, which reads A1. Circular reference: A1 → B1 → A1. Change one of these cells to break the loop.
IF runs one branchA1 0, B1 =IF(A1=0, "none", 10/A1)
B1 shows none: 10/A1 is never worked out, so there is no #DIV/0!.
A reference to another sheetPrices!B2 4.5, Sheet1!A1 =Prices!B2*2
Sheet1!A1 shows 9, twice the price on the Prices sheet.
Formula-like text in a CSVA1 the text =1+1, A2 the number -5, A3 the text @SUM(A1)
The CSV holds '=1+1, -5, '@SUM(A1): text that starts with = or @ gets an apostrophe, the number -5 does not.

Common questions

Which formulas and functions does it support?: Arithmetic with +, -, *, / and ^, a percent sign (50% is 0.5), & to join text, and the comparisons =, <>, <, <=, > and >=, which give TRUE or FALSE. References can be relative (B2), fixed with $ ($B$2 or B$2), a range (A1:C9) or on another sheet (Sheet2!A1, or 'Q3 figures'!A1 when the name has a space). The functions are SUM, AVERAGE, MIN, MAX, COUNT and IF, in any letter case. Inside a range, SUM, AVERAGE, MIN and MAX use the numbers and skip text, TRUE/FALSE and empty cells, and COUNT counts the numbers and skips errors as well. Any other function name shows #NAME? and is never run, and there are no macros, named ranges or links to other files. A minus sign binds before ^ and ^ works left to right, so -2^2 is 4 and 2^3^2 is 64.
What happens with a circular reference?: Every cell in the loop shows #CYCLE!, and the inspector names the path, for example Circular reference: A1 → B1 → A1. A cell that reads a looping cell shows #CYCLE! too, with a note saying which cell the error comes from. Nothing is iterated or guessed, so changing any cell on the path recalculates the rest. IF only follows the branch its test picks, so =IF(B1>0, A1, 7) typed into A1 is a loop only while B1 is above zero; otherwise A1 shows 7.
How does sorting treat formulas and the header row?: Sort A to Z and Sort Z to A in the Data menu move whole rows by the column of the selected cell: every cell in a row moves together with its format. If you select two or more rows, just those rows are sorted; otherwise every row down to the last filled one is, and row 1 stays in place while Row 1 is a header is ticked. In A to Z order numbers come before text, then TRUE and FALSE, then errors, and Z to A reverses that; empty cells stay at the bottom either way, text ignores letter case and ties keep their order. A moved formula behaves like a copied one: its relative references shift by the rows it moved, so =B2*10 still reads its own row, while $ references stay put. Formulas outside the sorted rows are not rewritten.
What does the CSV download do with text that looks like a formula?: Text that starts with =, +, -, @, a tab or a line break, or with spaces and then one of =, +, - or @, is written with a leading apostrophe, so a spreadsheet program treats it as text instead of running it. Numbers, negative ones included, are written as numbers. The file holds the sheet you are on, as calculated values from A1 to its last filled cell: numbers to 15 significant digits, TRUE and FALSE, and errors as their code, such as #DIV/0!. Fields with commas, quotes or line breaks are quoted by the CSV rules, and CSV and TSV downloads begin with a UTF-8 byte order mark so accented letters open correctly. To keep the formulas themselves, download the project instead.
Can I paste from Excel or Google Sheets?: Yes. Select a cell and press Ctrl+V or Cmd+V: tab-separated rows land from that cell down and to the right, and a copied cell with line breaks inside quotes stays whole. Pasted text is always a value, never a formula, and leading zeros such as 007 or numbers with more than 15 significant digits stay text so no digit is lost. File, Paste rows as text takes comma- or semicolon-separated rows as well. Ctrl+C or Cmd+C copies the selected cells as tab-separated values, with formula-like text given an apostrophe the same way as in the CSV.
How big can a workbook be, and can it open Excel files?: Up to ten sheets and 10,000 filled or formatted cells in total, on a grid that runs from A1 to ZZ100000. A file, paste or edit that would go past a limit is refused with the reason, and nothing is cut off or half imported. It opens CSV and TSV files and projects saved from this page. An .xlsx workbook is recognised and refused, so save it as CSV first, for example with the spreadsheet converter. Semicolon-separated files are detected, and a file that is not UTF-8 is read as Windows-1252 and the page says so. Files are read in the background and a read can be cancelled; one that takes longer than 2 minutes is stopped.
Where is my work saved?: In this browser's local storage, a moment after each change, along with the sheet you were on. Nothing is uploaded: files are read by a background worker on this page. If the browser blocks or fills its storage, the page says so and the workbook stays open until you close the tab, so download the project to keep it. Start over, above the tool, clears the saved copy, and Undo and Redo reach back 50 steps.

An original editor with its own formula parser: arithmetic, cell and sheet references, ranges and SUM, AVERAGE, MIN, MAX, COUNT and IF only. It is not Excel-compatible, so any other function shows #NAME? and is never run, and there are no macros or external links. Numbers are 64-bit floating point, shown to at most 15 significant digits.