imbue
Docs pages

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 pageSpreadsheet
Creating"/" then TableNew then Spreadsheet
FormulasNoYes, 92 functions
Several sheetsNoYes
CSV and ExcelNoImport and export
ChartA Chart block on the same pageNo

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

Cell tools

Sheets

Sheet tabs sit at the bottom, with Add Sheet, and Rename Sheet, Duplicate Sheet and Delete Sheet.

Cell references

TypeMeaning
A1Column A, row 1.
A1:B5A range from A1 to B5.
$A$1, A$1, $A1A fixed reference that does not change when copied: fully, row only, or column only.
Sheet1!A1A cell on another sheet.
'Sheet 1'!$A$1A 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

OperationSymbols
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.

GroupFunctions
StatisticsSUM AVERAGE AVG MIN MAX COUNT COUNTA COUNTBLANK PRODUCT SUMPRODUCT MEDIAN MODE STDEV STDEVP VAR VARP PERCENTILE LARGE SMALL RANK SUMIF COUNTIF AVERAGEIF
LogicIF IFS IFERROR IFNA SWITCH CHOOSE AND OR XOR NOT ISBLANK ISNUMBER ISTEXT
MathABS SIGN SQRT POWER EXP LN LOG LOG10 MOD INT FLOOR CEILING TRUNC ROUND ROUNDUP ROUNDDOWN PI RAND RANDBETWEEN
LookupVLOOKUP HLOOKUP XLOOKUP INDEX MATCH ROW COLUMN ROWS COLUMNS
FinancePMT FV PV NPV
TextLEN TRIM UPPER LOWER PROPER CONCAT CONCATENATE TEXTJOIN LEFT RIGHT MID SUBSTITUTE REPT VALUE TEXT EXACT
DateTODAY 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

ErrorCause
#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/AA 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

KeysWhat it does
Enter or F2Edit the active cell in place, or commit and move down.
Ctrl + EnterFill 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 + RFill down, fill right.
Ctrl + ;, Ctrl + Shift + ;Insert the current date, or time.
Ctrl + arrowsJump to the edge of the data region.
Shift + arrowsExtend the cell selection.
Ctrl + C, X, VCopy, cut, paste, in a format Excel understands.
Ctrl + Shift + VPaste values only, without formulas.
Ctrl + B, I, U, 5Bold, italic, underline, strikethrough.
Ctrl + Z, Ctrl + YUndo, redo.
Ctrl + FFind and replace in the sheet.
F1The shortcut list.

Import and export (CSV and Excel)

Import

  1. Press "Import .xlsx / .csv"

    It accepts .xlsx, .xls, .csv and .tsv files.

  2. 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

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

FeatureWindowsAppleAndroid
Formulas and functionsYesYes, same engineYes, same engine
Editing cells and sheetsYesPartly: no autofill, styles, filters, undo or range copy and pasteYes; merged cells and frozen rows are kept but not shown
CSV and Excel import and exportYesIn progressIn progress

The Apple and Android apps are still in progress. Details in Install.

Next