What formulas does 4SheetsX support?

4SheetsX supports arithmetic with +, -, *, / and parentheses, cell references like A1 or B2, ranges like A1:A10, comparisons, and many functions including SUM, AVERAGE, MEDIAN, MIN, MAX, COUNT, PRODUCT, STDEV, VAR, ROUND, ROUNDUP, ROUNDDOWN, ABS, SQRT, POWER, MOD, LOG, LN, EXP, FLOOR, CEILING, INT, PI, trigonometric functions, and IF. Functions can be nested.

Can I export my spreadsheet?

Yes. You can export your spreadsheet to a Microsoft Excel (.xlsx) file or to CSV with one click.

Can I choose how many rows and columns I want?

Yes. You can set the number of rows and columns when creating the grid, and add or remove rows and columns at any time afterward.

4SheetsX - Free Online Spreadsheet with Formulas

Saved locally

Rows Columns

A1 fx

4SheetsX — a free online spreadsheet

4SheetsX is a lightweight, browser-based spreadsheet. Choose how many rows and columns you need, enter numbers and text, write formulas, format your cells, and export the result to Excel (.xlsx) or CSV — no account, no install.

Formulas you can use

Start a cell with = to make it a formula. You can use:

Arithmetic: =A1+B1, =(A1-B2)*3, =A1/B1

Cell references and ranges: A1, B2, A1:A10

Absolute references with $: $A$1, $A1, A$1 stay fixed when you drag-fill

Statistics: =SUM, =AVERAGE, =MEDIAN, =MIN, =MAX, =COUNT, =PRODUCT, =STDEV, =VAR

Math: =ROUND, =ROUNDUP, =ROUNDDOWN, =ABS, =SQRT, =POWER, =MOD, =LOG, =LN, =EXP, =FLOOR, =CEILING, =INT, =PI()

Trigonometry: =SIN, =COS, =TAN, =RADIANS, =DEGREES

Logic: =IF(A1>10, 100, 0) with comparisons > < >= <= = <>

Nesting: combine them, e.g. =ROUND(AVERAGE(A1:A10), 2)

Circular references show #CIRC and invalid math shows #ERR, so you can spot mistakes quickly.

Resizing the grid

Set the rows and columns up front, or use the Row/Col buttons in the toolbar to add or remove them at any time. Removing a row or column uses the currently selected cell as the reference point.

Auto-fill

Select a cell and drag the small square at its bottom-right corner down or across. 4SheetsX copies the value, continues a number sequence (like 1, 2, 3), or adjusts a formula's references automatically — just like a desktop spreadsheet.

Your work stays with you

Your spreadsheet is saved automatically in your own browser. Nothing is uploaded to a server — your data never leaves your device.

4SheetsX — Free Online Spreadsheet with Formulas

4SheetsX — a free online spreadsheet

Formulas you can use

Resizing the grid

Auto-fill

Your work stays with you