Nexa Sheets — free spreadsheet

Find & Replace

Pivot table

Summarise your data. Row 1 is used as the column names.

Fields — drag into a box, or click to add

Rows

Columns

Values

Choose fields and press Build.

Gridsheet help

A real spreadsheet that lives in your browser. Nothing is uploaded — work saves on this device and to a file you control.

📱 Install on iPad / iPhone: open this page in Safari → tap the Share button → Add to Home Screen. It then opens full-screen with its own icon, just like an app.

The basics

Click a cellselect it, then start typing = …start with = to write a formula Enter / Tabmove down / right Savedownloads a .gridsheet file you can re-open CSVexport to Excel / Google Sheets / LibreOffice

Core formulas

=A1+B1+ − × ÷ ^ and brackets, e.g. =(A1+B1)*2 =B2*C2multiply — e.g. qty × rate =SUM(D2:D9)add a range =IF(B2>100,"OK","Low")test a condition ="Total: "&D6join text with &

Every function built in

Math & stats

SUMAVERAGEMINMAXCOUNTCOUNTAPRODUCTMEDIANSTDEVVARABSSIGNINTTRUNCMODPOWERSQRTEXPLNLOGLOG10ROUNDROUNDUPROUNDDOWNCEILINGFLOORSINCOSTANASINACOSATANATAN2DEGREESRADIANSPI

Logic

IFIFSIFERRORIFNAANDORNOTTRUEFALSE

Conditional & lookup

SUMIFCOUNTIFAVERAGEIFVLOOKUPHLOOKUPXLOOKUPMATCHINDEX

Just type = and a letter — a suggestion list pops up with every matching function and its arguments. Arrow keys to pick, Enter/Tab to insert.

Text

CONCATCONCATENATELENLEFTRIGHTMIDUPPERLOWERPROPERTRIMREPTSUBSTITUTEFINDSEARCHVALUE

Excel has 500+ functions; these are the ones people actually use day to day. Need one that's missing? Ask and it can be added.