Docs / Write and organise
Tables and spreadsheets
Worlds has two kinds of table: a full Spreadsheet with sheets and formulas, like Excel, and a simple Table inside a page for laying out text. This page explains both and lists every function the spreadsheet understands.
Which table do you need?
| Table in a page | Spreadsheet | |
|---|---|---|
| Creating | "/" then Table | New then Spreadsheet |
| Formulas | No | Yes, 92 functions |
| Several sheets | No | Yes |
| CSV and Excel | No | Import and export |
| Chart | A Chart block on the same page | No |
The spreadsheet
Create one with New, then Spreadsheet, or the New Spreadsheet command in the command palette. A new sheet starts with 60 rows and 26 columns and grows when you insert rows or columns.
At the top
- Templates: three ready-made spreadsheets: Financial Budget & Cashflow, KPI & OKR Tracker and Weighted Calculator & Matrix.
- Import .xlsx / .csv.
- Export: Export Excel (.xlsx) or Export CSV (.csv).
- Shortcuts: the spreadsheet shortcut list, also opened with F1.
Cell tools
- Undo and Redo.
- Number Format: General / Auto, Number (1,234.56), Integer (1,235), Currency (SAR 1,234.56), Currency ($1,234.56), Accounting ((1,234.56)), Percent (12.3%), Scientific (1.23E+03).
- Decrease Decimals and Increase Decimals.
- Text Color, Cell Background Fill, Wrap Text.
- AutoSum (Alt+=).
- Sort Column A → Z and Sort Column Z → A, and Toggle AutoFilter.
- Freeze Panes: Freeze Top Row, Freeze First Column, Unfreeze Panes.
- Insert Row Above, Insert Column Left, Delete Row, Delete Column, Auto-fit Column Width. A sheet always keeps at least 10 rows and 5 columns.
- Find & Replace (Ctrl+F).
- Insert Function: a list of common functions with a short explanation of each.
Sheets
Sheet tabs sit at the bottom, with Add Sheet, and Rename Sheet, Duplicate Sheet and Delete Sheet.
Cell references
| Type | Meaning |
|---|---|
A1 | Column A, row 1. |
A1:B5 | A range from A1 to B5. |
$A$1, A$1, $A1 | A fixed reference that does not change when copied: fully, row only, or column only. |
Sheet1!A1 | A cell on another sheet. |
'Sheet 1'!$A$1 | A sheet whose name has a space: put the name in single quotes. |
Sheet names can be in Arabic, and upper or lower case does not matter. While typing a formula, press F4 to cycle a reference through $A$1, A$1, $A1 and A1. In the Name Box, type A1 or A1:D10 and press Enter to jump there. The largest row a reference accepts is 100000.
Formulas
A formula starts with =, like =SUM(B2:B10). Separate arguments with a comma , or a semicolon ;. Text goes in double quotes, and TRUE and FALSE are logical values.
Operators
| Operation | Symbols |
|---|---|
| Arithmetic | + - * / ^ |
| Percent | % after a number |
| Join text | & |
| Compare | = <> != < <= > >= |
The functions that exist
These are all the functions the spreadsheet calculates. Any other name gives the #NAME? error.
| Group | Functions |
|---|---|
| Statistics | SUM AVERAGE AVG MIN MAX COUNT COUNTA COUNTBLANK PRODUCT SUMPRODUCT MEDIAN MODE STDEV STDEVP VAR VARP PERCENTILE LARGE SMALL RANK SUMIF COUNTIF AVERAGEIF |
| Logic | IF IFS IFERROR IFNA SWITCH CHOOSE AND OR XOR NOT ISBLANK ISNUMBER ISTEXT |
| Math | ABS SIGN SQRT POWER EXP LN LOG LOG10 MOD INT FLOOR CEILING TRUNC ROUND ROUNDUP ROUNDDOWN PI RAND RANDBETWEEN |
| Lookup | VLOOKUP HLOOKUP XLOOKUP INDEX MATCH ROW COLUMN ROWS COLUMNS |
| Finance | PMT FV PV NPV |
| Text | LEN TRIM UPPER LOWER PROPER CONCAT CONCATENATE TEXTJOIN LEFT RIGHT MID SUBSTITUTE REPT VALUE TEXT EXACT |
| Date | TODAY NOW DATE YEAR MONTH DAY DAYS DATEDIF |
The Insert Function list explains the most used of these; the rest work when you type them yourself.
Error messages
| Error | Cause |
|---|---|
#VALUE! | The wrong kind of value, such as text in a sum. |
#REF! | A reference to a cell or sheet that does not exist. |
#NAME? | An unknown function name. |
#DIV/0! | Division by zero. |
#NUM! | A number that does not work for the operation. |
#N/A | A value that was not found, for example by VLOOKUP. |
#CYCLE! | A circular reference: the formula depends on itself. |
#ERROR! | Any other formula error. |
Spreadsheet shortcuts
| Keys | What it does |
|---|---|
| Enter or F2 | Edit the active cell in place, or commit and move down. |
| Ctrl + Enter | Fill all selected cells with the current input or formula. |
| Alt + = | AutoSum of the adjacent numbers. |
| F4 (while editing a formula) | Cycle through fixed reference types. |
| Ctrl + D, Ctrl + R | Fill down, fill right. |
| Ctrl + ;, Ctrl + Shift + ; | Insert the current date, or time. |
| Ctrl + arrows | Jump to the edge of the data region. |
| Shift + arrows | Extend the cell selection. |
| Ctrl + C, X, V | Copy, cut, paste, in a format Excel understands. |
| Ctrl + Shift + V | Paste values only, without formulas. |
| Ctrl + B, I, U, 5 | Bold, italic, underline, strikethrough. |
| Ctrl + Z, Ctrl + Y | Undo, redo. |
| Ctrl + F | Find and replace in the sheet. |
| F1 | The shortcut list. |
Import and export (CSV and Excel)
Import
Press "Import .xlsx / .csv"
It accepts
.xlsx,.xls,.csvand.tsvfiles.Choose the file
All sheets are read, formulas stay formulas, and dates become
YYYY-MM-DD.
Importing replaces the whole spreadsheet with the file's content, all sheets included. To keep the current data, create a new spreadsheet and import into it.
Export
- Export CSV (.csv): exports the current sheet only, as calculated values rather than formulas, with commas between columns, in UTF-8 so Arabic is kept. The file is named after the spreadsheet title.
- Export Excel (.xlsx): exports all sheets and keeps the formulas. Sheet names are cut to 31 characters, the Excel limit.
Tables inside pages
Type "/" then Table for a 3 by 3 table with a header row. When you select cells, a bar appears with + Row, + Column, Delete row and Delete column. From the block handle: Add Row Below, Add Column Right, Toggle Header Row, Delete Table.
The Chart block draws a pie, bar or line chart from a table on the same page. The Collection, Board and Gallery blocks show subpages as a table with their properties. See Properties.
What works where
| Feature | Windows | Apple | Android |
|---|---|---|---|
| Formulas and functions | Yes | Yes, same engine | Yes, same engine |
| Editing cells and sheets | Yes | Partly: no autofill, styles, filters, undo or range copy and paste | Yes; merged cells and frozen rows are kept but not shown |
| CSV and Excel import and export | Yes | In progress | In progress |
The Apple and Android apps are still in progress. Details in Install.